SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Curious datetime issue

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 90
Accepted Solution

Curious datetime issue

My program needs to compare the previous month/year (SEP2012) with the month/year of entries in a data set, in order to only extract entries from the previous month. My program successfully uses substr to extract the value "OCT2012" from the data set variable, which is in datetime20. format.

The problem arises when I'm trying to create a value for the previous month, because for some reason it appears as "01SEP12:00:00:00", meaning that the subst function cannot get "SEP2012" from it, only "SEP12".

This is the code that is being used:

%let last_month = %sysfunc(intnx(month, %sysfunc(today()), -1), date.):00:00:00;

The peculiar thing (to me) is that the following almost identical code was used to get it in the correct format ("01SEP2012:00:00:00") from the exact same data set variable:

%let recent_monday = %sysfunc(intnx(week1.2, %sysfunc(today()),0,b), date.):00:00:00;

So my question is, how can I edit the first line of code so that it extracts the full datetime, rather than abbreviating the year from 2012 to 12? I need it to be "01SEP2012:00:00:00".

Thanks. Smiley Happy


Accepted Solutions
Solution
‎10-11-2012 09:40 AM
Super User
Posts: 5,427

Re: Curious datetime issue

Posted in reply to EinarRoed

Use date9.

Data never sleeps

View solution in original post


All Replies
Solution
‎10-11-2012 09:40 AM
Super User
Posts: 5,427

Re: Curious datetime issue

Posted in reply to EinarRoed

Use date9.

Data never sleeps
🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 186 views
  • 1 like
  • 2 in conversation