SAS Excel Issue

Question

Hello,

I need help with SAS. I have an excel file that I am trying to import directly into SAS; however, it doesn't seem to want to work. I have tried changing the excel file type to no avail. I just need help getting the excel imported to create the SAS file.

Answer 1

To import a file into SAS try using the following code (perhaps try CSV if XLS does not work):

PROC IMPORT DATAFILE= '/home/yourusername/yourfilename.csv'

DBMS=CSV

OUT=WORK.nameforyourdataset;

GETNAMES=YES;

RUN;