change date format in a column

[mariange8282]

Hi, I have a column DATE, type Numeric and Format MMDDYY10. 

I need to show that dates in numbers since 1/1/1960 (original SAS format). 

Thanks

[Kurt_Bremser]

Just assign a standard numeric format, like 5..

Or use the format in a put statement or put() function.

[mariange8282 · Accepted solution]

Here is the solution:

proc sql;

ALTER TABLE WORK.TABLE1

  MODIFY varialbe_data FORMAT=null.;

quit;

run;

[Reeza]

Null. Isn't a default SAS format. 

Changing the format is correct, but if it's a SAS dataset I'd recommend 8. instead.