topic Re: SAS DATE in SAS Programming

SAS DATE

robertrao — Wed, 22 Jul 2015 14:36:54 GMT

Hi,

I have a date variable with date9. format: 20FEB2014

I need to convert it to a number 20140220 and not a date.

Any comments highly appreciated

Regards

Re: SAS DATE

ballardw — Wed, 22 Jul 2015 14:44:56 GMT

Couple ways:

funnydate= year(date)*10000 + month(date)*100 + day(date);

funnydate = input(put(date,yymmdd8.),best8.);

Re: SAS DATE

stat_sas — Wed, 22 Jul 2015 14:56:44 GMT

data have;

date='20FEB2014'd;

date_want=input(put(date,yymmddn8.),best.);

run;

Re: SAS DATE

robertrao — Wed, 22 Jul 2015 15:02:27 GMT

Hi Ballard,

Thanks for the reply.

It would throw me an error as shown below.

The dater I have there is 20FEB2014. It's numeric and date9 format.

NOTE: Invalid argument to function INPUT at line 42 column 13.

Regards

Re: SAS DATE

robertrao — Wed, 22 Jul 2015 15:06:23 GMT

Thanks Stat,

It works. What is the logic behind putting n8. ????

Regards

Re: SAS DATE

stat_sas — Wed, 22 Jul 2015 15:20:24 GMT

Please see below for more detail.

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: SAS DATE

Tom — Wed, 22 Jul 2015 16:07:37 GMT

The YYMMDDN format is for displaying dates in ymd format without any separator character. Using a length of 8 will force it to use 4 digits for the year.