How to use marco variable in where statement

stataq — Wed, 25 Oct 2023 19:16:24 GMT

Hello,

I would like to get var list that start with certain pattern from sample data. for example, variables start with 'Cr'. Currently I have following codes, but I was not able to utilize the macro variable that was set up for pattern, Could anyone tell me what I did wrong?

```

proc contents data=sashelp.baseball noprint out=_contents_;
run;

%let np=Cr; /*macro variable for name pattern*/
data _contents1_;
set _contents_(where=(upcase(name)=:'&np.'));
run;

```

I tried "&np." and &np. and they are also not working.

Thanks.

Re: How to use marco variable in where statement

Quentin — Wed, 25 Oct 2023 19:22:53 GMT

Macro variables don't resolve inside single quotes; you need to use double quotes.

Since you are upcasing name you need to search for an uppercase "CR". Try:

%let np=Cr; /*macro variable for name pattern*/
data _contents1_;
set _contents_(where=(upcase(name)=:"%upcase(&np)"));
run;

topic How to use marco variable in where statement in SAS Programming

How to use marco variable in where statement

Re: How to use marco variable in where statement