Announcement Icon Online training class for Clinical R programming batch starts on Monday, 02Feb2026. Click here for details.

Import data from Excel workbooks - XLS

Lesson Description
-
  • Use PROC IMPORT in SAS or readxl in R to read .xls files.
  • Specify the sheet name when needed.
  • Update file paths to your local machine.
proc import datafile="path\\mf_data.xls"
    out=males
    dbms=excel
    replace;
    sheet="Males";
run;
  • DBMS=EXCEL reads the legacy .xls format.
  • SHEET selects the worksheet to import.
library(readxl)

males <- read_excel("path/mf_data.xls", sheet = "Males")
  • read_excel() supports legacy .xls files.
library(readxl)

males <- read_excel("path/mf_data.xls", sheet = "Males")
  • Base R can use readxl for .xls files.