1 /* Macro proc import*/
2 options mprint;
3 %macro import(T01);
4 FILENAME REFFILE "filepath\&T01..xls";
5
6 proc import datafile=refile dbms=xls out=&T01. replace;
7 sheet="sheetname";
8 namerow=7;
9 startrow=10;
10 *Endrow=934 (the end rows are not the same for each table;
11 getnames=yes;
12 run;
13 %mend import;
14
15 %import (filename_2022-01-27);
MPRINT(IMPORT): FILENAME REFFILE
"filepath\filename_2022-01-27.xls";
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
NOTE: The SAS System stopped processing this step because of errors.
MPRINT(IMPORT): proc import datafile=refile dbms=xls out=filename_2022-01-27 replace
sheet="sheetname";
MPRINT(IMPORT): namerow=7;
MPRINT(IMPORT): startrow=10;
MPRINT(IMPORT): *Endrow=934 (the end rows are not the same for each table;
MPRINT(IMPORT): getnames=yes;
MPRINT(IMPORT): run;
NOTE: Line generated by the macro variable "T01".
1 filename_2022-01-27
---
22
200
ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG,
FILE, OUT, REPLACE, TABLE, _DEBUG_.
ERROR 200-322: The symbol is not recognized and will be ignored.
16 %import (filename_2022-01-31);
MPRINT(IMPORT): FILENAME REFFILE
"filepath\filename_2022-01-31.xls";
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The SAS System stopped processing this step because of errors.
MPRINT(IMPORT): proc import datafile=refile dbms=xls out=filename_2022-01-31 replace
sheet="sheetname";
MPRINT(IMPORT): namerow=7;
MPRINT(IMPORT): startrow=10;
MPRINT(IMPORT): *Endrow=934 (the end rows are not the same for each table;
MPRINT(IMPORT): getnames=yes;
MPRINT(IMPORT): run;
NOTE: Line generated by the macro variable "T01".
1 filename_2022-01-31
---
22
200
ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG,
FILE, OUT, REPLACE, TABLE, _DEBUG_.
ERROR 200-322: The symbol is not recognized and will be ignored.
17 /*etc.*/
18 /*the table name with -01-27, etc. that not work*/
19 run;
@PaigeMiller
... View more