Importing data from excel xlsx sheets

[desireatem]

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

53

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

60

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

[Reeza · Accepted solution]

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.

[desireatem]

You are right. The path was wrong!