DATA Step, Macro, Functions and more

Creating date

Accepted Solution Solved
Reply
Contributor
Posts: 25
Accepted Solution

Creating date

Hi,

 

I have the following dataset

data have;

input account_id reporting_date payment_day;
informat reporting_date  date9.;
format reporting_date  date9.;
cards;
1000 31JAN2017 10
1000 28FEB2017 10
1000 31MAR2017 10
1000 30APR2017 10
1000 31MAY2017 10
2000 31JAN2017 15
2000 28FEB2017 15
2000 31MAR2017 15
2000 30APR2017 15
;
run;

what I need is to use payment day and reporting month to get payment due date for each particular reporting month. For example for the first record the desired output will be 10JAN2017 and second record 10FEB2017

 


Accepted Solutions
Solution
‎10-24-2017 05:39 AM
Valued Guide
Posts: 570

Re: Creating date

Posted in reply to Adnan_Razaq

Split the date up with the month() and year() functions and then rebuild it with the mdy() function

 

data have;

input account_id reporting_date payment_day;
informat reporting_date  date9.;
format reporting_date  date9.;
cards;
1000 31JAN2017 10
1000 28FEB2017 10
1000 31MAR2017 10
1000 30APR2017 10
1000 31MAY2017 10
2000 31JAN2017 15
2000 28FEB2017 15
2000 31MAR2017 15
2000 30APR2017 15
;
run;

data want(drop= rmon ryear);
	format due_date date9.;
	set have;
	rmon=month(reporting_date);
	ryear=year(reporting_date);
	due_date=mdy(rmon,payment_day,ryear);
run;

View solution in original post


All Replies
Solution
‎10-24-2017 05:39 AM
Valued Guide
Posts: 570

Re: Creating date

Posted in reply to Adnan_Razaq

Split the date up with the month() and year() functions and then rebuild it with the mdy() function

 

data have;

input account_id reporting_date payment_day;
informat reporting_date  date9.;
format reporting_date  date9.;
cards;
1000 31JAN2017 10
1000 28FEB2017 10
1000 31MAR2017 10
1000 30APR2017 10
1000 31MAY2017 10
2000 31JAN2017 15
2000 28FEB2017 15
2000 31MAR2017 15
2000 30APR2017 15
;
run;

data want(drop= rmon ryear);
	format due_date date9.;
	set have;
	rmon=month(reporting_date);
	ryear=year(reporting_date);
	due_date=mdy(rmon,payment_day,ryear);
run;
SAS Employee
Posts: 20

Re: Creating date

Posted in reply to Adnan_Razaq

You could use something like the following:

 

      payment_due_date = mdy(month(reporting_date), payment_day, year(reporting_date));

 

Best regards, Jos

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 131 views
  • 1 like
  • 3 in conversation