I've got some code that runs in Enterprise Guide after the user has "prompted" for a few input parameters. One of those prompts (FID) asks the user to identify one or more FormID values. If the user enters just one value (e.g., 1), then the following macro variables are created, among others: %LET FID_count = 1; %LET FID1 = 1; If the user enters just more than one value (e.g., suppose the user enters 1, 5 and 9), then the following macro variables are created, among others: %LET FID_count = 3; %LET FID1 = 1; %LET FID2 = 5; %LET FID3 = 9; I need help with the WHERE statement in the code below. %macro temp; PROC SQL; SELECT t1.CANDIDATE_ID, t1.FORM_ID, t1.TOTAL_SCORE, FROM ORA_SAS.CANDIDATE_EXAMS t1, WHERE t1.FORM_ID IN (?????????) ORDER BY t1.CANDIDATE_ID; QUIT; %mend; %temp; Specifically, if the user enters only 1 value (e.g. 1), then the WHERE statement should resolve to: WHERE t1.FORM_ID IN (1) If the user enters multiple values (e.g. 1, 5, and 9), then the WHERE statement should resolve to: WHERE t1.FORM_ID IN (1,5,9) Thanks!! Please let me know if something isn't clear. As a reminder, I'm using the prompting interface inside of Enterprise Guide and will eventually be building some Stored Processes with this code. -- Andy
... View more