topic Re: Setup running macro variable in SAS Programming

Setup running macro variable

hhchenfx — Thu, 10 Apr 2014 01:59:17 GMT

Hi Everyone,

I want to run a process every 3 month from 1990-2013.

I setup my macro like that:

%macro Myproblem (m=,y=);

data period; set original_data:

if m-3<month<=m+3 and year=y;

...

....

%mend;

%myproblem (m=3,y=1990);

%myproblem (m=6,y=1990);

...

%myproblem (m=12,y=2014);

Sure this code run but I believe that there should be a more efficient way rather than listing all (m=,y=).

Could you suggest a better way in this case?

(I know another way that make 02 files, 1 is the marco itself ; and 1 is for the m and y running together with calling the macro file.)

Thank you so much.

HHC

Re: Setup running macro variable

Tom — Thu, 10 Apr 2014 02:53:56 GMT

Why not just convert the date in your source file into a quarter and use BY group processing?

data period ;

set original_data ;

qtr = put(datevar,YYQTR6.);

run;

proc means;

by qtr ;

run;

Otherwise loop by quarter.

%macro loop(start,end);

%do i=0 %to %sysfunc(intck(qtr,&start,&end)) ;

%let qtr=%sysfunc(intnx(qtr,&start,&i),yyq6) ;

%put start=&start i=&i qtr=&qtr end=&end ;

proc print data=original ;

where put(date,yyq6.) = "&qtr" ;

title "Data for Quarter &qtr" ;

run;

%end;

%mend loop;

data original ;

do date='01FEB1990'd to '10APR1991'd by 90 ;

output;

end;

format date date9.;

run;

%loop('01JAN1990'd,'31DEC1991'd);

Re: Setup running macro variable

slchen — Thu, 10 Apr 2014 04:10:44 GMT

Use sashelp.workers as example.

%macro test (start,end);

%do i=&start %to &end;

%do j=3 %to 12 %by 3;

data year_&j.&i;

set sashelp.workers;

if month(date)=&j and year(date)=&i then output;

run;

%end;

%mend test;

%test (1977,1980);

Re: Setup running macro variable

Ksharp — Thu, 10 Apr 2014 09:24:38 GMT

Are you trying to split table ?

Re: Setup running macro variable

jakarman — Thu, 10 Apr 2014 11:27:34 GMT

Looks as a moving calculation like a moving average. There are many smarter solutions for that.

Re: Setup running macro variable

hhchenfx — Thu, 10 Apr 2014 12:20:12 GMT

Good morning,

Thank you for your help.

Since the data is quite large and the processing is heavy, I think about split the whole sample in to pieces to deal with one by one.

Have a nice day.

HHC

Re: Setup running macro variable

jakarman — Thu, 10 Apr 2014 15:35:00 GMT

@hhchenfx, converting a sequential process to one that goes for a divide an conquer approach will usually result in a even worse performance unless you have a fit in the infrastructure.

Luckily enough you can go for that infrastructure fit with grid-computing and/or the hadoop way. You have just describe the principles of those,