I am downloading many txt file from WRDS server. I can do one file at a time successfully. But the I have a list of 8000 paths of files in data A. I try to create macro variables from paths such as " /wrdslin/11551.txt, /wrdslin/1832555.txt, /wrdslin/18355557.txt", but the program return error. Could anyone please help me? data B ; set A; length link link2 $ 500; link=substr(Reference_Name_of_Complete_Repor, 1); link2= cats('/wrdslin/', link); keep link2; run; %let wrds=wrds-cloud.wharton.upenn.edu 4016; options comamid=TCP remote=WRDS; signon username=user password="xyz"; rsubmit; * working well proc download infile="/wrdslin/000000/6814/0000006814-95-000009.txt" outfile="E:/test1.txt"; * not working ERROR: Physical file does not exis %let link3=link2; proc download infile="&link3" outfile="E:/&link3"; run;
... View more