Hi I have a prompt which allows the user to select multiple items. i'm trying to use these selections with in statement, but to use a macro for concatenating these selections, since i have many variables with prompts. the macro below works fine (concatenating with delimiter), but the proc sql makes an error. i would appreciate any help here is the code: %macro CatPrompt (prmpt); %local i emit dlm1 dlm2; %let emit=; %let dlm1 = %str(%'); %let dlm2 = %str(,); %let i = 1; %if &&&prmpt._count>0 %then %do; %let emit = &dlm1.&&&prmpt&i.&dlm1.; %do i=2 %to &&&prmpt._count; %let emit=&emit.&dlm2.&dlm1.&&&prmpt&i.&dlm1.; %end; %end; &emit; %mend CatPrompt; PROC SQL; CREATE TABLE WORK.Tbl2 AS SELECT * FROM WORK.Tbl1 WHERE (&Prompt_MultUsrSlct_count=0) OR (myFld1 IN (%CatPrompt(Prompt_MultUsrSlct))) ; QUIT; ... View more

Hello, I'm newbie with sas. I'm having a table that has many columns (number&names of columns can be changed due to daily processing) I need to "freeze" the first row, and create a new table such that: Row(n) in NewTbl = Row(n) - Row(1) for all columns, except the first 3 columns, which names are constant so i can drop them and merge after (if necessary). also i need another table such that: Row(n) in NewTbl2 = Row(n)/Row(1) - 1   I would appreciate any help Thanks in advance  ... View more