topic Re: code to extract data month data in SAS Programming

code to extract data month data

anirudhs — Tue, 27 Nov 2018 05:00:13 GMT

i have a data set containing the data of 365 days.

i want to extract the data of 1st of every month and last day of every month.

eg. if i have data of 3 months jan, feb,march then i want output data set to contain 1st jan, 31st jan, 1st feb, 28th feb, 1st march,31st march.

Re: code to extract data month data

novinosrin — Tue, 27 Nov 2018 05:02:43 GMT

a simple intnx with begin and end option

would be nice if you posted sample of what you have and what you desire as output

Re: code to extract data month data

PGStats — Tue, 27 Nov 2018 05:32:53 GMT

something like:

data monthBegEnd;
set myData;
if date = intnx("month", date, 0, "beginning") or 
   date = intnx("month", date, 0, "end") then output;
run;

Re: code to extract data month data

anirudhs — Tue, 27 Nov 2018 05:42:00 GMT

start_date value

1/1/2018 123
1/2/2018 124
1/3/2018 125
1/4/2018 126
1/5/2018 127
1/6/2018 128
1/30/2018 129
1/31/2018 130
2/1/2018 131
2/2/2018 132
2/3/2018 133
2/4/2018 134
2/27/2018 135
2/28/2018 136
3/1/2018 137
3/2/2018 138
3/3/2018 139
3/4/2018 140
3/5/2018 141
3/6/2018 142
3/7/2018 143
3/8/2018 144
3/29/2018 145
3/30/2018 146
3/31/2018 147
4/1/2018 148
4/2/2018 149
4/3/2018 150

Output Data B:
start_date value

1/1/2018 123
1/31/2018 130
2/1/2018 131
2/28/2018 136
3/1/2018 137
3/31/2018 147
4/1/2018 148

Re: code to extract data month data

novinosrin — Tue, 27 Nov 2018 05:43:12 GMT

@PGStats code does that. 🙂

Re: code to extract data month data

anirudhs — Tue, 27 Nov 2018 05:43:15 GMT

will this extract the 1st day of all the months present in data set .??

Re: code to extract data month data

Kurt_Bremser — Tue, 27 Nov 2018 06:49:32 GMT

Maxim #4.

Re: code to extract data month data

PGStats — Tue, 27 Nov 2018 06:55:42 GMT

It will extract all dates which are the first of the month or the last of the month. It will never select March 2, for example, even if March 1 is absent from your data.

Try it and see.

Re: code to extract data month data

learsaas — Tue, 27 Nov 2018 07:34:58 GMT

sas learning