SAS Support Communities

Hi I want to create a loop for the following code so I can output a range of names...   data _null_; do i = 1 to 2; if i = 1 then class = "bank"; if i = 2 then class = "bonds"; end; summary = cats(class,"_summary"); call symputx('summary',summary); Current = cats(class,"_curr"); call symputx('current',current); run; %put &summary.; %put &current.;   But right now my output looks like this   bond_summary bond_curr   What I dont understand is why 1) my first i =1 clas = bank didnt appear? 2) why is an "s" missing in my "bond"   And then if the above code is run successfully I want to incorporate the following proc sql code but I dont know where to stick the code in the loop.   proc sql; create table &summary. as select Market_value from &current.; quit;   Many thanks for helping! ... View more

Hi I have this peace of code which i want to use to look up a file created 6 days ago, e.g. 20180816. The file name should be G20180816.txt.   %let kurs_datum = %eval(%sysfunc(today())-6);   data format_date; format kurs_datum yymmddn8.; run; %let infil="C:\G&kurs_datum..txt";   When i run this code i got this error message. It looks like that it is still using SAS's date format.   ERROR: Physical file does not exist, C:\G21412.txt.   How do I solve this? ... View more