topic Re: Converting Date Variables in New SAS User

Converting Date Variables

MagD — Fri, 28 Aug 2020 04:17:16 GMT

Hi All,

Please assist me with converting a date variable from 05AUG2014:00:00:00.000 to 201408 in a one line in proc sql query. I've been using this but its not working:

f.period as period format=yymmn6.,

Thank you in advance.

Re: Converting Date Variables

Shmuel — Fri, 28 Aug 2020 04:35:29 GMT

Your variable is probably a datetime type. The format yymmn6. relates to a date format. Use nextcode

datepart(f.period) as period format=yymmn6.,

Re: Converting Date Variables

Kurt_Bremser — Fri, 28 Aug 2020 06:42:45 GMT

In SAS, date values are (integer) counts of days from 1960-01-01 (this day is day zero). Time and date values are counts of seconds, from 00:00:00 (time) or 1960-01-01T00:00:00 (datetime).

To make a count of seconds into a count of days, you use the DATEPART function, as already explained.