BookmarkSubscribeRSS Feed
Smitha9
Fluorite | Level 6

Hi I would like to change the two different date formats

Old: 2018-02-16     New: 20180216

Old:01FEB2018     New: 20180201

 

 I hope this works in SAS.

 

thanks

2 REPLIES 2
PaigeMiller
Diamond | Level 26

If these are numeric variables, then just change the format.

 

format variable_name yymmddn8.;
--
Paige Miller
Tom
Super User Tom
Super User

Are those two observations in the same dataset?  If so then OLD must be a character variable.

What type of variable do you want to create for NEW?  Do you want date values that are formatted in that style that saves two characters when printed but will confuse humans into not noticing that they should think of them as dates?  Or do you want to store that 8 digit string into a character variable?