Hello – Using SAS EG 7.1; I’m trying to perform the same set of steps (w/ PROC SQL) based on multiple variables entered via a prompt. Example: let’s say I have a table with the following 4 fields: StoreID; StoreName; StoreCity; StoreRevenue There are hundreds of StoreIDs in the table; I want to create an individual report showing StoreName and StoreRevenue for each StoreID entered by the user via a prompt called “SID” (user can enter many). I know that when entered by the prompt, the variables become SID1, SID2, SID3, etc and the total number entered would be SID_count. But I don’t know how the PROC SQL steps would be included in the following to make it work (or if I’m off base completely). Any advice would be most appreciated! %macro MyLoop(SID_count); %do i=1 %to &SID_count; PROC SQL; Etc, etc; run; %end; %mend MyLoop; %MyLoop(&SID_count)
... View more