topic Re: Date conversion from Today() to yymmddN8 format in SAS Programming

Date conversion from Today() to yymmddN8 format

SaraDob — Tue, 28 Aug 2018 18:58:54 GMT

Hello!

Still new to SAS world and certainly very new to date conversion.

The query I'm trying to run, has dates, that has to be changed every day. the date plugged inside the query has to be in yymmddN8 format( eg: 20180827)

can you please let me know how do you convert tSAS today() date to the above said format.

Also I have a condition to verify , if the today is friday, get today date and sunday date also.

Please help!

Re: Date conversion from Today() to yymmddN8 format

Reeza — Tue, 28 Aug 2018 19:03:50 GMT

@SaraDob wrote:

The query I'm trying to run, has dates, that has to be changed every day. the date plugged inside the query has to be in yymmddN8 format( eg: 20180827)

can you please let me know how do you convert tSAS today() date to the above said format.

Do you need that in a numeric or character variable?

@SaraDob wrote:

Also I have a condition to verify , if the today is friday, get today date and sunday date also.

Please help!

Look at INTNX for this one. WEEKDAY(TODAY()) returns the Weekday number, 1 being Sunday and 7 being Saturday.

Are you looking for the Sunday after or before the Friday? If before, use a negative interval, if after, use a positive interval.

What about holidays?

Re: Date conversion from Today() to yymmddN8 format

ballardw — Tue, 28 Aug 2018 21:03:48 GMT

Is your value actually a numeric 20180827? Then it is not a date to SAS. Currently the largest valid number of days to treat as a date is around 6588970, about 14,000,000 less than your value.

If numeric then

input(put(today(),yymmddn8.),8.)

if character

put(today(),yymmddn8.)