topic Re: How to import an Excel file into a SAS file using SAS OnDemand for Academics in New SAS User

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

millice2 — Fri, 24 Mar 2023 15:19:45 GMT

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?

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

Reeza — Fri, 24 Mar 2023 16:09:12 GMT

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

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

millice2 — Fri, 24 Mar 2023 16:44:18 GMT

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?

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

millice2 — Fri, 24 Mar 2023 16:46:33 GMT

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;

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

Reeza — Fri, 24 Mar 2023 16:50:23 GMT

And the other corrections?

Code as text not images?

https://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio?autoStart=true&page=2&q=excel

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

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

millice2 — Fri, 24 Mar 2023 18:06:10 GMT

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;

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

Reeza — Fri, 24 Mar 2023 18:56:27 GMT

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.