I have the following code: proc sql; select distinct "'" || strip(code) || "'" into :process separated by "," from tbl1 where code_type="A"; create table temp as select * from tbl1 where code in ('&process'); quit; the above generates a list from the macro variable that matches my expectation. however, temp table generated is blank. what am i missing here? the reason i'm approaching this way is because I need to pass &process to a data step: data want1 want2; set have; if code in ("&process") then output want1; run; I rather not have to rewrite the existing code, so thought this would be a quick approach   ... View more

Hello, I'm trying to change a table from narrow to wide. What I have: Col1 Col2 Col3 a foo_a val_1 a foo_b val_2 b foo_a val_1 b foo_b val_2   What I want: Col1 Col2_1 Col2_2 Col3_1 Col3_2 a foo_a foo_b val_1 val_2 b foo_a foo_b val_1 val_2   I want to do it programmatically, since the unique values in Col2 and Col3 vary. Your help is appreciated! ... View more