How to import an Excel file into a SAS file using SAS OnDemand for Academics

[millice2]

I keep having an error trying to import an Excel file as a SAS file using the codes above. What can I do to correct the error?  OR, Do you have a different code I can use?

[Reeza]

Please post your code as text, it makes it easier to modify your code and show you the correct approach.

You need to provide the full file path for the code, for the datafile parameter. Right click on the Excel file, select properties and you'll find the file path there.

Change the DBMS to XLSX. I think some of the other parameters are also

Here's a video tutorial:

https://video.sas.com/detail/video/6295501319001/import-a-microsoft-excel-worksheet

[millice2]

Thank you for the response. It doesn't work the same for SAS Studio following the video. Can a version of SAS help me do the same as in the video?

[Reeza · Accepted solution]

And the other corrections?

Code as text not images?

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio?autoSta...

proc import datafile = '/home/Afiba/Screen addiction.xlsx'
out = addiction
dbms = xlsx
replace
;
run;

[millice2]

What is SAS code for finding the difference in mean of a lifestyle between Group A and Group B adjusting for age and gender?

I used the code below but it didn't work?
proc glm data=mydata;
class group gender;
model lifestyle = group gender age / solution;
lsmeans group / adjust=bon;
run;

[Reeza]

Please post as a new question. And clarify what didn't work means. That could mean anything from you missed a semicolon, to using the wrong procedure, to your computer is stuck in an infinite loop and explodes.

[millice2]

Below is the code I used.

PROC IMPORT
DATAFILE="path_to_excel_file.xlsx"
OUT=SAS_dataset_name
DBMS=EXCEL REPLACE;
SHEET="worksheet_name";
GETNAMES=YES;
MIXED=YES;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;