topic Re: create multiple macro vars from data set 2 columns in SAS Programming

create multiple macro vars from data set 2 columns

Ronein — Sat, 23 Oct 2021 18:55:16 GMT

Hello

I want to create multiple macro variables based on the data set macro_var_help.

In the data set 2 columns(First columns is values ,Second column is macro var name)

The following macro variables should be created:

Today(value 1903)

NextQ(value 1906)

Q3(value 1912)

Jan21(value 2101)

Apr21(value2104)

last(value2108),

What is the way to do it based on the data set values?

Data macro_var_help;
input YYMM name $;
cards;
1903 Today
1906 NextQ
1912 Q3
2101 Jan21
2104 Apr21
2108 last
;
Run;

Re: create multiple macro vars from data set 2 columns

Reeza — Sat, 23 Oct 2021 18:57:19 GMT

CALL SYMPUTX(), look at the third parameter option in the documentation to control if it's a global or local macro variable.

data _null_;
set macro_var_help;

call symputx(name, YYMM);

run;

%put &today.;
%put &Jan21.;
%put &Q3.;
%put &last.;

@Ronein wrote:

Hello

I want to create multiple macro variables based on the data set macro_var_help.

In the data set 2 columns(First columns is values ,Second column is macro var name)

The following macro variables should be created:

Today(value 1903)

NextQ(value 1906)

Q3(value 1912)

Jan21(value 2101)

Apr21(value2104)

last(value2108),

What is the way to do it based on the data set values?
Data macro_var_help;
input YYMM name $;
cards;
1903 Today
1906 NextQ
1912 Q3
2101 Jan21
2104 Apr21
2108 last
;
Run;

Re: create multiple macro vars from data set 2 columns

PeterClemmensen — Sat, 23 Oct 2021 18:58:39 GMT

Use the CALL SYMPUTX Routine.