If i run above code...getting these errors.Can you guide me how to resole that filename statement error.
16 %let subdir=C:\Trade-NewSet-06132011\new;
17 filename dir pipe "dir &subdir.*.xls /B";
ERROR: Insufficient authorization to access PIPE.
ERROR: Error in the FILENAME statement.
18 data new;
19 infile dir truncover end=last;
20 input filename $100.;
21 filename=cats("&subdir",filename);
22 call symputx(cats('path',_n_),filename);
23 call symputx(cats('dsn',_n_),scan(scan(filename,6,'\'),1,'.'));
24 if last then call symputx('nobs',_n_);
25 run;
ERROR: No logical assign for filename DIR.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0
observations and 1 variables.
%macro import;
28 %do i=1 %to &nobs;
29 proc import datafile="&&path&i" out=&&dsn&i dbms=excel replace;
30 getnames=yes;
31 mixed=yes;
32 run;
33 %end;
34 %mend import;
WARNING: Apparent symbolic reference NOBS not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: &nobs
ERROR: The %TO value of the %DO I loop is invalid.
ERROR: The macro IMPORT will stop executing.
Thanks,
brm.
... View more