Converting YYMMDD10. character date to numeric date

[Cruise]

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;

[ballardw]

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.

[ChrisNZ · Accepted solution]

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.

[Cruise]

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

[Kurt_Bremser]

---

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

---

Or

format date;

to remove any format.

[Cruise]

quite handy! thanks a lot for the trick.