topic Re: Reduce redundant code in SAS Programming

Reduce redundant code

Havi — Wed, 06 Jun 2012 09:31:10 GMT

Hi All,

Please help, I want to perform the same function for 3 different data sets. Is there a way to do this without having to create 3 separate data sets? Can I use a macro?

Eg:

data a;

set sum1;

dd=datepart(day);

month=month(dd);

year=year(dd);

month=month(dd);

if day(dd) le &max_daya. then day_group="&max_daya.";

if class le 97 then group='c' ;

if class gt 97 and class le 99 then group='02b';

if class in (97,98,99) then group='A';

if class ge 100 then group='H';

cost=cost/100;

vatexcl=cost/1.14;

format dd date.;

run;

data b;

set sum2;

dd=datepart(day);

month=month(dd);

year=year(dd);

month=month(dd);

if day(dd) le &max_dayb. then day_group="&max_daya.";

if class le 97 then group='c' ;

if class gt 97 and class le 99 then group='02b';

if class in (97,98,99) then group='A';

if class ge 100 then group='H'';

cost=cost/100;

vatexcl=cost/1.14;

format dd date.;

run;

data c;

set sum3;

dd=datepart(day);

month=month(dd);

year=year(dd);

month=month(dd);

if day(dd) le &max_dayc. then day_group="&max_daya.";

if class le 97 then group='c' ;

if class gt 97 and class le 99 then group='02b';

if class in (97,98,99) then group='A';

if class ge 100 then group='H';

cost=cost/100;

vatexcl=cost/1.14;

format dd date.;

run;

Re: Reduce redundant code

shivas — Wed, 06 Jun 2012 09:46:37 GMT

Hi,

Yes you can do that..

%macro Test(output,input);

data &output;

set &input;

dd=datepart(day);

month=month(dd);

year=year(dd);

month=month(dd);

if day(dd) le &max_daya. then day_group="&max_daya.";

if class le 97 then group='c' ;

if class gt 97 and class le 99 then group='02b';

if class in (97,98,99) then group='A';

if class ge 100 then group='H';

cost=cost/100;

vatexcl=cost/1.14;

format dd date.;

run;

%mend test;

%test(a,sum1);

%test(b,Sum2);

%test(c,Sum3);

Thanks,

Shiva

Re: Reduce redundant code

Havi — Wed, 06 Jun 2012 09:59:33 GMT

Thank you Shivas

Re: Reduce redundant code

data_null__ — Wed, 06 Jun 2012 11:29:56 GMT

What about....

if day(dd) le &max_daya. then day_group="&max_daya.";

if day(dd) le &max_dayb. then day_group="&max_dayb.";

if day(dd) le &max_dayc. then day_group="&max_dayc.";

Perhaps

if day(dd) le &&max_day&output. then day_group="&&max_day&output.";

Where are those variables?

Re: Reduce redundant code

Havi — Wed, 20 Jun 2012 15:19:33 GMT

Hi Shivas

I could really use your help. Please advise on the below.

I want to automate programs by adding them to my crontab to run daily.
Instead of adding in several entries for the different programs to my crontab, how do I create a macro/program that has all the program calls in it(the different program names)
Also before running the program each day I want the macro to check if the previous days data ran successfully and if the log dependancy for today is met before kicking of the jobs.

Eg: Prog02may2012.sas can only run if the Prog01may2012.sas ran successfully. Also the dependancy "extract.log.ok" needs to be met before I run any programs.

Hope this makes sense.
Thanks, appreciate it.