topic Re: extract month in a year using loops in SAS Programming

extract month in a year using loops

BrahmanandaRao — Sat, 26 Mar 2022 05:20:52 GMT

data month;
st='01Jan2010';
enddt='31Dec2010';
do i=st to enddt;
month=intnx('Month',st,i,'same');
output;
end;
run;

Required output

Date	Month
01-Jan-10	Jan
01-Feb-10	Feb
01-Mar-10	Mar
01-Apr-10	Apr
01-May-10	May
01-Jun-10	Jun
01-Jul-10	Jul
01-Aug-10	Aug
01-Sep-10	Sep
01-Oct-10	Oct
01-Nov-10	Nov
01-Dec-10	Dec

Re: extract month in a year using loops

Kurt_Bremser — Sat, 26 Mar 2022 05:34:41 GMT

You cannot use character values as start and end of an iterative DO loop.

To make your strings into date literals, add a trailing d:

st = '01Jan2010'd;

Use the MONNAME format to get the character month from a SAS date value.

Re: extract month in a year using loops

BrahmanandaRao — Sat, 26 Mar 2022 05:44:20 GMT

data month;
do i= '01Jan2010'd to '31Dec2010'd;
month=put(month((i) ,monname3.));
output;
end;
run;

Re: extract month in a year using loops

Kurt_Bremser — Sat, 26 Mar 2022 07:10:25 GMT

As I mentioned, the MONNAME format is for date values, not month numbers. Please read the documentation.

And if you want to loop over months, not dates, you will need a different loop. Either DO WHILE and the INTNX function to increment, or a loop from 1 to 12, building dates with the MDY function.

Re: extract month in a year using loops

BrahmanandaRao — Sat, 26 Mar 2022 07:42:39 GMT

data date_range;
do Date ='01Jan2010'd to '31Dec2010'd ;
format Date : date11.;
if Date =intnx('month',Date,0,'b')  then output;
end;
run;


data month;
set date_range;
month=put(Date,monname3.);
run;

I tried my idea is it hard coded

Re: extract month in a year using loops

Kurt_Bremser — Sat, 26 Mar 2022 07:53:46 GMT

Use a DO WHILE:

date = '01jan2022'd;
do while (date le '01dec2022'd);
  output;
  date = intnx('month',date,1,'b');
end;

Re: extract month in a year using loops

BrahmanandaRao — Sat, 26 Mar 2022 08:03:39 GMT

data dw;
date = '01jan2022'd;
do while (date le '01dec2022'd);
  output;format date month: date11.;
  Month=put(date,monname3.);
  date = intnx('month',date,1,'b');
  end;
run;

As per your code i got output

Re: extract month in a year using loops

Kurt_Bremser — Sat, 26 Mar 2022 08:08:40 GMT

That's just the order of statements. Fix that.

Re: extract month in a year using loops

BrahmanandaRao — Sat, 26 Mar 2022 08:18:05 GMT

data dw;
date = '01jan2022'd;
do while (date le '01dec2022'd);
Month=put(date,monname3.);
  output;
  format date month: date11.;
  date = intnx('month',date,1,'b');
  end;proc print noobs;
run;