Hey, I am new to SAS university edition and I am trying to import data from an excel file into SAS. Here is my code below. LIBNAME Present 'C:\Users\asant\Documents\datamanagement\Module1.xlsx'; data Present.Module1; set Present.Module1 SHEET='SHEET1$'n end=; keep Student_id, Week_no_1, Week_no_2, Week_no_3, Week_no_4, Week_no_5, Week_no_6, Week_no_7, Week_no_8, Week_no_9, Week_no_10, Week_no_11, Week_no_12; label Student_id = 'Student ID' Week_no_1 = 'Week no 1' Week_no_2 = 'Week no 2' Week_no_3 = 'Week no 3' Week_no_4 = 'Week no 4' Week_no_5 = 'Week no 5' Week_no_6 = 'Week no 6' Week_no_7 = 'Week no 7' Week_no_8 = 'Week no 8' Week_no_9 = 'Week no 9' Week_no_10 = 'Week no 10' Week_no_11 = 'Week no 11' Week_no_12 = 'Week no 12'; run; proc contents data=Module1; run; proc print data=Module1; title Math attendance; run; libname Present clear ; These are the errors that I'm getting. This is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 LIBNAME Present 'C:\Users\asant\Documents\datamanagement\Module1.xlsx'; NOTE: Library PRESENT does not exist. 74 data Present.Module1; 75 set Present.Module1 SHEET='SHEET1$'n end=; _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT. ERROR 76-322: Syntax error, statement will be ignored. 76 keep Student_id, Week_no_1, Week_no_2, Week_no_3, Week_no_4, Week_no_5, Week_no_6, Week_no_7, Week_no_8, Week_no_9, _ 22 76 76 ! Week_no_10, Week_no_11, Week_no_12; ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, ;, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. 77 label Student_id = 'Student ID' 78 Week_no_1 = 'Week no 1' 79 Week_no_2 = 'Week no 2' 80 Week_no_3 = 'Week no 3' 81 Week_no_4 = 'Week no 4' 82 Week_no_5 = 'Week no 5' 83 Week_no_6 = 'Week no 6' 84 Week_no_7 = 'Week no 7' 85 Week_no_8 = 'Week no 8' 86 Week_no_9 = 'Week no 9' 87 Week_no_10 = 'Week no 10' 88 Week_no_11 = 'Week no 11' 89 Week_no_12 = 'Week no 12'; 90 run; ERROR: Library PRESENT does not exist. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 91 proc contents data=Module1; ERROR: File WORK.MODULE1.DATA does not exist. 92 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 93 proc print data=Module1; ERROR: File WORK.MODULE1.DATA does not exist. 94 title Math attendance; 95 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 96 libname Present clear ; NOTE: Libref PRESENT has been deassigned. 97 98 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
... View more
