topic Re: Number Format to Date Format in SAS Studio

Number Format to Date Format

Alessandra_005 — Sat, 24 Jun 2017 07:58:29 GMT

Hi,

How can I transofm the number 201403 into the date 03/2014 on SAS?

Thank you

Re: Number Format to Date Format

SASKiwi — Sat, 24 Jun 2017 09:16:36 GMT

There isn't a SAS format for what you want but you can create your own (untested):

proc format;
  picture MyDateFmt low-high='%0m/%y' (datatype=date);
run;

data test;
  datenum = 201403;
  MyDate = input(put(datenum * 100 + 1, 8.), yymmdd8.);
  format MyDate MyDateFmt.;
  put _all_;
run;

Re: Number Format to Date Format

slchen — Sat, 24 Jun 2017 10:51:11 GMT

data _null_;
date=201403;
_date=input(put(date,6.),yymmn6.);
format _date mmyys7.;
put _all_;
run;

Re: Number Format to Date Format

Cynthia_sas — Sat, 24 Jun 2017 15:41:54 GMT

Hi:
This post is remarkably similar (uses the same number as this posting https://communities.sas.com/t5/Base-SAS-Programming/Importing-sas7bdat-file/m-p/370282#M88434) 201403 as an example of a number that is a date variable.

Homework?? Another possible answer was posted in the other forum. Also posted with a longer explanation of how date variables work.

cynthia