topic Re: Comparing a date variable to a year, to calculate how many date variables are in this year in SAS Procedures

Comparing a date variable to a year, to calculate how many date variables are in this year

alisondu77 — Mon, 25 Apr 2016 09:31:33 GMT

Hello everyone,

I have a little problem in my script SAS.

I have a starting date (01jan2015), and I add to this date one month eleven times (01jan2015, 01feb2015, ..., 01dec2015).
There is no problem for that, but after I would like to count how many dates are in 2015 or 2014, and i don't succeed... I just have "1" in output for nb_month_2014 and nb_month_2015, which is wrong. I should have : nb_month_2014= 0 and nb_month_2015=12.

%let date_start = "01jan2015"d; 
%let nb_month_2014=0;
%let nb_month_2015=0;
data _null_;
 do i=0 to 11 ;
 	dt=intnx("month",&date_start.,i,'same');
 	if (put(year(dt),z4.)=2014) then %let nb_month_2014 = %eval(&nb_month_2014 + 1) ;
 	if (put(year(dt),z4.)=2015) then %let nb_month_2015 = %eval(&nb_month_2015 + 1) ;
 end;
run;
%put nb_month_2014 = &nb_month_2014. ;
%put nb_month_2015 = &nb_month_2015. ;

Thank you for helping me ! and sorry for my poor english !

Alison

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

Loko — Mon, 25 Apr 2016 09:34:44 GMT

Hello,

This happenns beacuse you mix the macro statements within a data step. If you use macro statements/variables why you don't put them in a macro?

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

RW9 — Mon, 25 Apr 2016 09:50:09 GMT

What is it your trying to do. Post test data in the form of a datastep and what you want the output to look like. The reason I ask is because most of this code is not neccessary. If your couting interval's then there are functions for this, I can provide code, but I need to see the data and what the output should look like. In your code you are mixing Macro language and Base SAS code which doesn't work. Macro is text generator, and happens before any code actually runs. Hence the if statements are evaulated out before the code is even passed to the compiler. In almost all instances you will not need to use Macro language, it does have its place, however most tasks can be done directly in Base SAS.

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

alisondu77 — Mon, 25 Apr 2016 09:51:10 GMT

Thank you ! So, I should do something like this :

%macro test() ;
%let date_start = "01jan2015"d; 
%let nb_month_2014=0;
%let nb_month_2015=0;
%do i=0 %to 11 ;
 	%let dt=%sysfunc(intnx("month",&date_start.,&i.,'same'));
 	%if put(%sysfunc(year(&dt.),z4.))=2014 %then %let nb_month_2014 = %eval(&nb_month_2014 + 1) ;
 	%if put(%sysfunc(year(&dt.),z4.))=2015  %then %let nb_month_2015 = %eval(&nb_month_2015 + 1) ;
 %end;
%mend ;
%test() 
%put nb_month_2014 = &nb_month_2014. ;
%put nb_month_2015 = &nb_month_2015. ;

I don't manage my errors, I am a beginner in macro ... Can you help me to find what's wrong in my script ? Thank you in advance !

Alison

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

RW9 — Mon, 25 Apr 2016 09:52:50 GMT

As noted in my post below, this is a very good example of trying to force a very simple Base SAS task through the macro pre-processor which isn't built for writing code.

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

Loko — Mon, 25 Apr 2016 10:03:53 GMT

hello,

%macro test;
%let date_start = %sysfunc(inputn(01jan2015,date9.));
%let nb_month_2014=0;
%let nb_month_2015=0;
%do i=0 %to 11;

%let dt=%sysfunc(intnx(month,&date_start.,&i,same));
%if %sysfunc(year(&dt)) eq 2014 %then %let nb_month_2014 = %eval(&nb_month_2014 + 1) ;
%if %sysfunc(year(&dt)) eq 2015 %then %let nb_month_2015 = %eval(&nb_month_2015 + 1) ;

%end;

%put nb_month_2014 = &nb_month_2014. ;
%put nb_month_2015 = &nb_month_2015. ;

%mend test;

%test;

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

Reeza — Mon, 25 Apr 2016 10:13:34 GMT

Why are you using macro variables at all?

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

alisondu77 — Mon, 25 Apr 2016 11:03:55 GMT

You have surely right, I didn't manage very well "counting" procedures that's why, unfornunately, I make complicate things for "simple" things. Sorry I am still student and didn't practice so much on data procedures... 😕 I'm trying to learn by myself 😕

Thank you all for your advice and taking time for me !

Alison

Re: Comparing a date variable to a year, to calculate how many date variables are in this year

RW9 — Mon, 25 Apr 2016 11:21:42 GMT

Here is a datastep version, it is deliberately verbose to show the working of the date increment functions. You could even do the same thing for many years, but if you were to do that then either an array, or creating a big output dataset and then aggregate function on it:

%let date_start="01JAN2015"d;
data _null_;
  d=&date_start.;
  do i=0 to 11;
    year2014=sum(year2014,ifn(year(d)=2014,1,0));
    year2015=sum(year2015,ifn(year(d)=2015,1,0));
    d=intnx('month',d,1);
  end;
  put "2014=" year2014 ", 2015=" year2015;
run;