The prompt is set up as numeric. I tried to set up a macro variable to reference but that is not working either. data _null_;
length int $32767 ;
do i=1 to &ACCT_NUMBER_Count;
int = catx(' ',(cats('&ACCT_NUMBER', i)));
end;
call symputx('ACCT_NUMBER_ALL',int); I am now referencing it here in the where clause but it only resolves to a singular input value not the multiple from the prompt WHERE t4.Account_Number IN (&ACCT_NUMBER_ALL)
... View more
