topic Re: Change the date format in New SAS User

Change the date format

Smitha9 — Tue, 03 May 2022 18:20:44 GMT

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

Re: Change the date format

PaigeMiller — Tue, 03 May 2022 18:45:33 GMT

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

format variable_name yymmddn8.;

Re: Change the date format

Tom — Tue, 03 May 2022 22:19:51 GMT

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?