topic Using macro variables on terminology of data set. in SAS Programming

Using macro variables on terminology of data set.

Barney1998 — Mon, 27 Jun 2022 10:45:52 GMT

Hallo to all,

I desire to make my algorithm more flexible. From this reason I tried to used macro variables. I have problem to use marco variable on terminology of my data set.I want for example to have one marco variable as name,and with it i change the name of data sets.

Can someone help me?

Re: Using macro variables on terminology of data set.

Patrick — Mon, 27 Jun 2022 11:10:25 GMT

@Barney1998 Please re-read your question and consider if anyone can understand what you're asking for based on what you wrote and without any of the context that might exists in your brain.

Re: Using macro variables on terminology of data set.

Kurt_Bremser — Mon, 27 Jun 2022 11:18:16 GMT

Please post the code you want to make dynamic, and indicate which parts of it should be dynamic.

Re: Using macro variables on terminology of data set.

Barney1998 — Mon, 27 Jun 2022 11:49:19 GMT

from example ,
proc sql;
create table colour_dataset as
select t.*
from colours t
where t.colours='yellow';
quit;

I know how to use marco variable in where statement ,the question is if exist any way to use marco variable on tables onomastics i.e
%let colour = yellow;
%let colours= yellow;

proc sql;
create table &colour_dataset as
select t.*
from colours t
where t.colours='&colours';
quit;

I want give name to the table above from marco variable,videlicet i don't must to give the name yellow_dataset manual but i use one variable colour and every time i changed its name the table name changed too, for example from yellow to red.
Thanks in advance!

Re: Using macro variables on terminology of data set.

Tom — Mon, 27 Jun 2022 11:57:05 GMT

Two key things.

1) You are following the name of the macro variable you are trying to reference with a character that could be part of the name. You can use a period to let the macro processor know where the name ends.

2) The macro processor ignores quoted strings that are bounded on the outside by single quotes. Use double quotes for your strings that you want the macro processor to evaluate.

create table &colour._dataset as
  select t.*
  from colours t
  where t.colours="&colours"
;

Re: Using macro variables on terminology of data set.

Barney1998 — Mon, 27 Jun 2022 12:01:31 GMT

Perfect. thanks a million
Have a nice day!