topic Re: Keep in SAS Programming

Keep= macro variables

AJ_Brien — Tue, 30 Nov 2021 21:14:39 GMT

Hello mentors,

I have a base dataset that has the following columns: _name_, 201902, 201903............202110.
I’m looking to extract the 1st and last columns, so I defined a macro variable:
%let yyyymm= %sysfunc(intnx(month,%sysfunc(date()),-1,s, yymmn6.);
Which gives me the value 202110.

So now i try to create a dataset:
Data want (keep= _name_ &yyyymm.);
Set have;
Run;

This keeps giving me errors:
Variable name “202110” is not valid.
Invalid value for the keep option.

I even did proc contents for ‘have’ dataset, and 202110 is a valid variable in there.
What am I doing wrong?

Thank you for all the help!

Re: Keep= macro variables

PaigeMiller — Tue, 30 Nov 2021 21:22:50 GMT

There are rules that determine what names are allowed. Normally, a variable name of 202110 is not allowed (and really is a bad idea to have calendar information in variable names anyway).

Either you are seeing the variable label when you look at the data set (are you?) or the data set was created with

options validvarname=any;

in which case you can refer to a variable name as '202110'n (note the quotes and the suffix which is the letter n) and so you can refer to it as

Data want (keep= _name_ "&yyyymm"n);

Do yourself a favor and turn this data set into a long data set (instead of a wide data set) where the month is the value of the variable named MONTH, and then almost all of your programming becomes much much much much much much much much easier muchly.

Re: Keep

AJ_Brien — Tue, 30 Nov 2021 22:51:20 GMT

That worked! I added ‘n’ as you suggested.
Thank you so much!

Re: Keep= macro variables

AJ_Brien — Tue, 30 Nov 2021 22:54:30 GMT

Someone else is creating the base dataset so I couldn’t update the variable names. But adding ‘n’ After the variable name totally worked. Thank you so much!

Re: Keep= macro variables

PaigeMiller — Wed, 01 Dec 2021 11:05:30 GMT

Let me correct something you said.

@AJ_Brien wrote:
Someone else is creating the base dataset so I couldn’t update the variable names. But adding ‘n’ After the variable name totally worked.

you don't add 'n' with quotes

you put the variable names in quotes and then append the letter n