%*let qtpParamStr = H:\QTP_SAS_QUERY_VALIDATION\Run_3-29_12-51-24,H:\QTP_SAS_QUERY_VALIDATION\Run_3-29_12-51-24\CBBRisk_Query_Validation_Set4.xlsx;
ata _null_ ;
Call symput('dirPath', scan("&qtpParmamStr", 1, "," )) ;
Call symput('testDataSheet', scan("&qtpParmamStr", 2, "," )) ;
run ;
Libname test "&dirPath.";
above is done in the windows and now the rsubmit;
Unix part;
rsubmit;
option mprint mlogic fullstimer;
Libname testunix "/listmgt/home/Testo568484/";
proc download infile="/listmgt/home/(&&ID&I).lst" outfile="&dirPath.\(&&ID&I).lst";
run;
endsubmit;
WARNING: Apparent symbolic reference DIRPATH not resolved.
MPRINT(QUERYTEST): proc download infile="/listmgt/home//(CBM018411).lst"
outfile="&dirPath.\(CBM018411).lst";
MPRINT(QUERYTEST): run;
How to pass the value of the macro to the unix part of the program?
Use syslput or sysrput you can transfer macro variable
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.