topic Re: Select variables with a KEEP statement and a prompt in SAS Programming

Select variables with a KEEP statement and a prompt

GuiVtzl — Thu, 05 Sep 2013 15:39:58 GMT

Hello !

Here's my problem : I've got a table with variables like TEST_Q3_07 TEST_Q4_07 [...] TEST_Q4_2012 THING_Q3_07 THING_Q4_07 [...] THING_Q4_2012

What I'd like is through a prompt and a KEEP statement allow the user to choose which set he'd like to keep.

My prompt would create a macro variable call &Variable and possible values would be TEST or THING and then my question is : how do I include a set of variables in a KEEP statement where's a prompt involved ?

Here's one of the codes I tried, unsuccessfully ;

DATA HISTO ; SET HISTO ;

KEEP=&Variable_Q3_07 &Variable_Q4_07 [...] &Variable_Q4_12;

run;

Thank you

Re: Select variables with a KEEP statement and a prompt

esjackso — Thu, 05 Sep 2013 15:46:58 GMT

did you try the code with the macro delimiter in the keep statement macro variables?

KEEP &Variable._Q3_07 &Variable._Q4_07 [...] &Variable._Q4_12;

by the way if you are using keep as part of the data step there is no = in the syntax. If you move to the set statement and use as a data set option Histo (keep= blah ); they you use the = and this might be a better option depending on the size of the data you are using.

See if that helps

Re: Select variables with a KEEP statement and a prompt

GuiVtzl — Thu, 05 Sep 2013 16:05:56 GMT

Thanks a lot, the macro delimiter works fine and the result's exactly what I expected.

Sincerely

Re: Select variables with a KEEP statement and a prompt

Astounding — Thu, 05 Sep 2013 16:06:23 GMT

I agree with all the recommendations so far, especially moving KEEP to the SET statement:

data histo;

set histo (keep=some list of variables);

run;

Also note ... if you want ALL variable names that begin with TEST or THING, you can abbreviate the code:

data histo;

set histo (keep=&variable:);

run;

The colon modifier (no space allowed before the colon) will automatically indicate that your list of variables includes all variable names that start with &VARIABLE

Good luck.

Re: Select variables with a KEEP statement and a prompt

GuiVtzl — Thu, 05 Sep 2013 16:23:04 GMT

Thanks Astounding ! It will make it better !

Sincerely