error when ran ur code
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 proc import datafile="/folders/myfolders/sasuser.v94/GSK Vx-FORM-SDTM-Metadata-Extension-Form_v2.0.xlsx"
57 out=WORK.MYEXCEL
58 dbms=XLSX
59 replace;
60 sheet="Structural_Metadata";
61 getnames=YES;
62 run;
NOTE: Variable Name Change. VAR_FORMAT (Optional) -> VAR10
NOTE: The import data set has 29 observations and 13 variables.
NOTE: WORK.MYEXCEL data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.12 seconds
cpu time 0.11 seconds
63
64 proc print data=work.myexcel;
65 run;
NOTE: There were 29 observations read from the data set WORK.MYEXCEL.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.57 seconds
cpu time 0.57 seconds
66
67 filename myexcel "c:\temp.sas";
68 data _null_;
69 set work.myexcel end=last;
70 length statement_str $1000.;
71 if _n_=1 then put cat('data ',datasetname,';');
_______
22
76
72 if trim(var_format) ne " " then put cat('attrib ',varname,' label="',trim(var_label),'" format=',var_format,';');
_________
22
76
ERROR 22-322: Syntax error, expecting one of the following: a name, arrayname, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.
ERROR 76-322: Syntax error, statement will be ignored.
73 if last then put 'run;';
74 end;
___
161
ERROR 161-185: No matching DO/SELECT statement.
75 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
72:9
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.06 seconds
76
77
78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
90
... View more