topic Re: SAS macro problems in SAS Programming

SAS macro problems

Phoenix_LJ — Fri, 24 Sep 2021 08:08:13 GMT

Thank you very much, but I'd like to ask you a question. Thank you

Code as follws:

%macro Sets(start,end,prefix);
%do i = start %to end;
	&prefix.||&i.||' ' 
%end;
%mend; 
%Sets(2005,2050,data);

I want to generate a program like this:
```
data2005 data2006 data2007 ......data2050;
```
But my macro does not run successfully, how to modify this macro program

Re: SAS macro problems

Phoenix_LJ — Fri, 24 Sep 2021 08:12:13 GMT

I want to use this macro program for the following program

data WeekOfDate;
	set %sets(start=2005,end=2020,prefix=data);
run;

Re: SAS macro problems

PeterClemmensen — Fri, 24 Sep 2021 08:15:29 GMT

A few corrections.

Start, end and prefix are now macro variables. That means you should reference them with &.
The macro language is a text language. Consider everything as text. This means that the concatenation operators are redundant and so is the ' ' in the end.
To test if your macro (function) returns the correct result, test it with a %Put Statement as below.

Hope this helps 🙂


%macro Sets(start,end,prefix);
%do i = &start. %to &end.;
&prefix.&i.
%end;
%mend; 


%put %Sets(2005,2050,data);

Re: SAS macro problems

Kurt_Bremser — Fri, 24 Sep 2021 08:19:30 GMT

To use macro parameters in the macro, you need to address them like macro variables, and you do not need concatenation operators, as in macro everything is text:

%macro Sets(start,end,prefix);
%do i = &start. %to &end.;
	&prefix.&i 
%end;
%mend;

You can use this like this:

data want;
set
  &sets(2005,2050,data)
; /* this semicolon is NOT part of the macro call, it terminates the SET statement! */
run;

Re: SAS macro problems

Phoenix_LJ — Fri, 24 Sep 2021 08:33:20 GMT

First of all, thank you very much.

But,if you have two data set names 'data2005','data2006'。

now,use programs as follows:

/*define*/
%macro Sets(start,end,prefix);
%do i = &start. %to &end.;
	&prefix.&i. 
%end;
%mend; 


data a;
set
%Set(2005,2006,data)
;
run;

Unfortunately, the program will not run。

Re: SAS macro problems

Kurt_Bremser — Fri, 24 Sep 2021 08:35:29 GMT

You define macro Sets, but you use macro set (missing s).

If something else is the issue, please post the complete log of the data step, using this button:

Re: SAS macro problems

PeterClemmensen — Fri, 24 Sep 2021 08:37:18 GMT

Why does it not run? What does the log say?

Re: SAS macro problems

Phoenix_LJ — Fri, 24 Sep 2021 08:37:49 GMT

I'm very sorry for wasting your time, and I would like to express my heartfelt thanks for your help!

Re: SAS macro problems

Kurt_Bremser — Fri, 24 Sep 2021 08:37:59 GMT

Proof of concept:

data data2005;
set sashelp.class;
run;

data data2006;
set sashelp.class;
run;

%macro Sets(start,end,prefix);
%do i = &start. %to &end.;
	&prefix.&i 
%end;
%mend; 

data want;
set
%Sets(2005,2006,data)
;
run;

Re: SAS macro problems

Phoenix_LJ — Fri, 24 Sep 2021 08:41:22 GMT

thanks for your help!
This is a question that should not arise!

Re: SAS macro problems

Kurt_Bremser — Fri, 24 Sep 2021 08:45:38 GMT

@Phoenix_LJ wrote:

I'm very sorry for wasting your time, and I would like to express my heartfelt thanks for your help!

Really no waste, sometimes a second set of eyes is needed. Been there, done that, have the T-shirt.

Might be material for another Maxim.