topic Re: Converting YYMMDD10. character date to numeric date in SAS Programming

Converting YYMMDD10. character date to numeric date

Cruise — Thu, 02 Apr 2020 00:44:46 GMT

Hi Folks:

I'm baffled that seemingly correct solution to convert character date to numeric date doesn't work. According to the SAS Viewtable I'm using correct format YYMMDD10. in the code below. However, the code below outputs missing Date1 variable. What am I doing wrong here, any idea?

data time1; set time;
Date1=input(date,YYMMDD10.);
run;

Re: Converting YYMMDD10. character date to numeric date

ballardw — Thu, 02 Apr 2020 01:12:16 GMT

INPUT works is to read a CHARACTER value for the first parameter using the informat specified in the second parameter.

Your Date is already numeric. So input isn't correct to use.

If you want to convert numeric to character then use PUT.

date1 = put(date,yymmdd10.);

or other format.

Re: Converting YYMMDD10. character date to numeric date

ChrisNZ — Thu, 02 Apr 2020 01:39:11 GMT

The variable DATE is already a a date.

You don't need to convert it.

You can change its associated format to display it differently.

Re: Converting YYMMDD10. character date to numeric date

Cruise — Thu, 02 Apr 2020 07:36:38 GMT

Thanks.
format date best5.;
This did the job.

Re: Converting YYMMDD10. character date to numeric date

Kurt_Bremser — Thu, 02 Apr 2020 09:46:52 GMT

@Cruise wrote:
Thanks.
format date best5.;
This did the job.

format date;

to remove any format.

Re: Converting YYMMDD10. character date to numeric date

Cruise — Thu, 02 Apr 2020 09:59:12 GMT

quite handy! thanks a lot for the trick.