%*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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.