DATA Step, Macro, Functions and more

how to create 99/9999 as MM/YYYY

Reply
New Contributor
Posts: 3

how to create 99/9999 as MM/YYYY

Hi All,

 

How could we replace missing mm/yyyy as 99/9999 in sas?

 

Thanks.

SAS Super FREQ
Posts: 683

Re: how to create 99/9999 as MM/YYYY

You can make use of format that makes use of the nested format definition.

 

Here is a sample:

proc format;
  value my_mmyys (default=7)
    . = "99/9999"
    other = [mmyys7.]
  ;
run;

data have;
  do someDate = ., "01jan2016"d, "31aug2016"d;
    someDate2 = someDate;
    output;
  end;

  format
    someDate mmyys7.
    someDate2 my_mmyys.
  ;
run;

Bruno

PROC Star
Posts: 1,561

Re: how to create 99/9999 as MM/YYYY

Since 99 is not a valid month, you can't replace the missing date with 99/9999.

You can display the missing date as 99/9999 though, as @Bruno_SAS showed.

Super User
Super User
Posts: 7,401

Re: how to create 99/9999 as MM/YYYY

To what purpose?  If it is to display that in a report, then the simplest option is to have two variables - one a numeric date, and one a character version of that allowing for partials, and missing conversions.  This is what we do for analysis domains, the numeric to perform windowing and such like, and character for listings so it reflects the data.  I would not recommend applying some sort of internal format to the data for two (actually 3) reasons - first anyone who uses SAS knows dates and that . indicates missing - if you try to change that underlying understanding then anyone who uses your code/data has to learn all your specific things.  Secondly it requires a SAS specific thing - formats - to achieve, if your data is going anywhere to another system/format then that will cause further issues for you.  Also, I personally avoid the use of proprietary binary files as much as possible - the 32bit versus 64bit completely destroying any work done previously with catalogs is a very good example of why.  

Ask a Question
Discussion stats
  • 3 replies
  • 232 views
  • 0 likes
  • 4 in conversation