topic change date format in a column in SAS Studio

change date format in a column

mariange8282 — Sat, 08 Oct 2016 17:34:43 GMT

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 — Sat, 08 Oct 2016 17:47:56 GMT

Just assign a standard numeric format, like 5..

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

mariange8282 — Sat, 08 Oct 2016 18:12:57 GMT

Here is the solution:

proc sql;

ALTER TABLE WORK.TABLE1

MODIFY varialbe_data FORMAT=null.;

quit;

run;

Reeza — Sat, 08 Oct 2016 18:15:51 GMT

Null. Isn't a default SAS format.

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