Help using Base SAS procedures

simple intnx and date formatting question...

Reply
N/A
Posts: 0

simple intnx and date formatting question...

I'm trying to create a new date which is exactly 18 years prior to a date currently held in my data.

I've used the intnx function only to find it gives the first day of the year that occurred 18 years ago.

I tried this but I'm getting no joy as I can't get the date format to be recognized... can anyone help?


dateminus18=intnx('year',start_date,-18);

day=put(day(start_date),z2.);
month=put(month(start_date),z2.);
year=year(dateminus18);

newdate=(compress(day||month||year));
newdate2=input(newdate,ddmmyyn8.);
Super Contributor
Super Contributor
Posts: 3,174

Re: simple intnx and date formatting question...

Investigate using the SAMEDAY argument to INTNX in your first assignment statement.

Scott Barry
SBBWorks, Inc.
N/A
Posts: 0

Re: simple intnx and date formatting question...

Awesome. I knew it would be simples.
N/A
Posts: 0

Re: simple intnx and date formatting question...

Awesome. I knew it would be simples.
Ask a Question
Discussion stats
  • 3 replies
  • 207 views
  • 0 likes
  • 2 in conversation