BookmarkSubscribeRSS Feed
devnand
Obsidian | Level 7

%*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?

1 REPLY 1
BobyGadu
Calcite | Level 5

Use syslput or sysrput you can transfer macro variable

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 714 views
  • 0 likes
  • 2 in conversation