@ChrisNZ: I run the code in message 20 (I think you mean message #20). Here is code: %macro Print (var=);
data _null_;
set SASHELP.VTABLE (where=(LIBNAME="ELTML" and upper(MEMNAME) like 'MLT%'));
call execute(cats('title "My Lending - ',MEMNAME,'";
proc export data=ELTML.',MEMNAME,"(where CR_APPL_NO=&var)",'
outfile="\\WLGFILE2\<PATH>\',MEMNAME,'.xlsx"
dbms=xlsx
replace;
run;'));
run;
%mend Print;
%Print (var=60048444); Here is log: The SAS System 08:40 Tuesday, August 9, 2016
1 %_eg_hidenotesandsource;
5 %_eg_hidenotesandsource;
39
40 %macro Print (var=);
41 data _null_;
42 set SASHELP.VTABLE (where=(LIBNAME="ELTML" and upper(MEMNAME) like 'MLT%'));
43 call execute(cats('title "My Lending - ',MEMNAME,'";
44 proc export data=ELTML.',MEMNAME,"(where CR_APPL_NO=&var)",'
45 outfile="\\WLGFILE2\<PATH>\',MEMNAME,'.xlsx"
46 dbms=xlsx
47 replace;
48 run;'));
49 run;
50 %mend Print;
51
52 %Print (var=60048444);
NOTE: The query as specified involves ordering by an item that doesn't appear in its SELECT clause.
NOTE: The map data sets in library MAPSGFK are based on the digital maps from GfK GeoMarketing and are covered by their Copyright.
For additional information, see http://support.sas.com/mapsonline/gfklicense.
NOTE: There were 0 observations read from the data set SASHELP.VTABLE.
WHERE (LIBNAME='ELTML') and UPCASE(MEMNAME) like 'MLT%';
NOTE: DATA statement used (Total process time):
real time 3.22 seconds
user cpu time 0.49 seconds
system cpu time 1.29 seconds
memory 7510.75k
OS Memory 29980.00k
Timestamp 09/08/2016 08:47:17 AM
Step Count 2 Switch Count 26
53
54 %_eg_hidenotesandsource;
67
68
69 %_eg_hidenotesandsource;
72 I need gfklicense to run this query?
... View more