Importing data from excel xlsx sheets

desireatem — Thu, 24 Jan 2019 16:35:44 GMT

Hi-,

We used the code below to import xlsx data but kept having issues. Any help.

47 proc import datafile = 'C:\Users\s160578\Desktop\NEW_COMBINED.xlsx'

48 out= Baseline

49 dbms = xlsx;

50 sheet = 'Baseline for All';

51 getnames = yes;

52 run;

ERROR: Physical file does not exist, C:\Users\s160578\Desktop\NEW_COMBINED.xlsx.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.16 seconds

cpu time 0.01 seconds

54 proc import datafile = 'C:\Users\s160578\Desktop\NEW_COMBINED.xlsx'

55 out= daily

56 dbms = xlsx;

57 sheet = 'Daily';

58 getnames = yes;

59 run;

ERROR: Physical file does not exist, C:\Users\s160578\Desktop\NEW_COMBINED.xlsx.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

61 proc import datafile = 'C:\Users\s160578\Desktop\NEW_COMBINED.xlsx'

62 out= pupil

63 dbms = xlsx;

64 sheet = 'Pupil';

65 getnames = yes;

66 run;

ERROR: Physical file does not exist, C:\Users\s160578\Desktop\NEW_COMBINED.xlsx.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

Re: Importing data from excel xlsx sheets

Reeza — Thu, 24 Jan 2019 16:47:48 GMT

1. Is the file actually there? Find the file, select properties and get the full file path.

2. Are your sheet names correct? Try assigning a libname and then run proc datasets on the libname to get the sheet names.

Re: Importing data from excel xlsx sheets

desireatem — Thu, 24 Jan 2019 16:52:52 GMT

You are right. The path was wrong!

topic Re: Importing data from excel xlsx sheets in SAS Data Management

Importing data from excel xlsx sheets

Re: Importing data from excel xlsx sheets

Re: Importing data from excel xlsx sheets