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).
Here is the solution:
ALTER TABLE WORK.TABLE1
MODIFY varialbe_data FORMAT=null.;
View solution in original post
Just assign a standard numeric format, like 5..
Or use the format in a put statement or put() function.
Null. Isn't a default SAS format.
Changing the format is correct, but if it's a SAS dataset I'd recommend 8. instead.