I'd like to create tables with the use of a nested do loop. Each loop should initialize a macro variable, and the table created should have its name as a combination of the two. The outline of my code is: %let names_a = name1 name2 name3; %let names_b = no1 no2 no3; %do i=1 %to 3; %let var_1=%qscan(&names_a,&i,%str( )); %do j=1 %to 3; %let var_2=%qscan(&names_b,&j,%str( )); data libname.&var_1.&var_2; run; %end %end So I'd like to have 9 tables in total, each with name name1no1, name1no2,....name3no3. This won't work, but I figure it has something to do with qscan. I'm new to SAS programming and any help would deeply be appreciated.
... View more