topic Creating Macros Based on months in SAS Procedures

Creating Macros Based on months

santhosh — Mon, 26 Mar 2012 06:14:40 GMT

Hi,

I am trying to create macros based on month

eg., if month is JAN FEB MAR then i need to create year macro -1 year

else i want to create macro +1 year

if Month JAN/FEB/MAR 2012 then i want to create macro year 2011

else i want to create macro year 2012

Creating Macros Based on months

manojinpec — Mon, 26 Mar 2012 06:21:37 GMT

Hi,

i the macro value (+1 year) (-1year) like that?

Thanks & Regards,

Manoj

Creating Macros Based on months

santhosh — Mon, 26 Mar 2012 07:00:50 GMT

yes

Creating macro year based on months conditionally

if month is JAN/FEB/MAR 2012 then want to create macro year=2011

else macro year=2012

Creating Macros Based on months

Ksharp — Mon, 26 Mar 2012 10:10:21 GMT

%let day='02jul2012'd ;

options minoperator;
%macro  a;
%if %sysfunc(substr(%sysfunc(putn(&day,monyy.)),1,3)) in JAN FEB MAR %then 
 %do;data _null_;call symputx('year',year(&day)-1);stop;run;%end;
 %else %do;data _null_;call symputx('year',year(&day));stop;run;%end;
%mend a;
%a
%put &year ;

Ksharp

Creating Macros Based on months

Haikuo — Mon, 26 Mar 2012 11:41:50 GMT

And if the 'date' goes with your system time dynamically, you don't need to feed it:

data _null_;

if month(date()) in (1,2,3) then

call symputx('year',year(date())-1);

else call symputx('year',year(date()));

run;

%put &year;

Regards,

Haikuo

Re: Creating Macros Based on months

data_null__ — Mon, 26 Mar 2012 12:45:38 GMT

Shifted interval...

29   %let day='02jul2012'd ;
30   %let year=%sysfunc(intnx(Year1.4,&day,0),year.);
31   %put YEAR=&YEAR;
YEAR=2012
 
 
35   %let day='02feb2012'd ;
36   %let year=%sysfunc(intnx(Year1.4,&day,0),year.);
37   %put YEAR=&YEAR;
YEAR=2011

Creating Macros Based on months

santhosh — Mon, 26 Mar 2012 13:47:24 GMT

Thanks Ksharp

it is working fine

title of program is report generated for the period 31 Dec 2011 for financial year 2011-2012

(if month is from april 2011 to march 2012)

if month is April 2012 then title will be " for financial year 2012-2013"

i am unable to put other date

Creating Macros Based on months

Haikuo — Mon, 26 Mar 2012 14:05:22 GMT

Data _null_'s code will for you then.

Creating Macros Based on months

santhosh — Mon, 26 Mar 2012 14:12:40 GMT

Thanks for your support

i want to generate a title

if the report generating period is form April 2011 to Mar2012 then title=

"for the financial year 2011 to 2012"

if the report is generating for period dec 2011 then title will be "for the financial year 2011-2012"

if the report is generating for period jan 2012 then title will be " for the financial year 2011-2012"

Creating Macros Based on months

Haikuo — Mon, 26 Mar 2012 14:23:54 GMT

I maybe misunderstand your question, but could it be done by just using the title statement?

Supposely you have already run _null_'s code:

Title "for the financial year &year.- %eval(&year.+1)";

Haikuo

Re: Creating Macros Based on months

data_null__ — Mon, 26 Mar 2012 15:57:37 GMT

How about this.

38   %let day='02feb2012'd ;
39   %let year=%sysfunc(intnx(Year1.4,&day,0,B),year.)-%sysfunc(intnx(Year1.4,&day,0,E),year.);;
40   %put YEAR=&YEAR;
YEAR=2011-2012

Creating Macros Based on months

santhosh — Tue, 27 Mar 2012 13:45:04 GMT

Thanks for support

can we select the date insted of system date the report can be generated for any month the date should vary

march to march