topic Re: how to create 99/9999 as MM/YYYY in SAS Programming

how to create 99/9999 as MM/YYYY

Andrewpass — Wed, 12 Oct 2016 19:44:27 GMT

Hi All,

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

Thanks.

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

BrunoMueller — Wed, 12 Oct 2016 20:04:42 GMT

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

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

ChrisNZ — Wed, 12 Oct 2016 23:00:43 GMT

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 @BrunoMueller showed.

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

RW9 — Thu, 13 Oct 2016 08:26:41 GMT

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.