topic Re: Dates in SAS Programming

Dates

Akshaya_1397 — Fri, 12 May 2023 11:00:00 GMT

Can anyone please help me in how to convert the date 03/01/2022 to 01MAR2022:00:00:00

Re: Dates

PaigeMiller — Fri, 12 May 2023 11:53:48 GMT

More information is needed.

Is 03/01/2022 in a character variable in a data set? Is it in a numeric variable in a data set? If numeric, what is the format? Is it found in a text file that you have to read into SAS? Is it something else?

Re: Dates

AMSAS — Fri, 12 May 2023 12:06:59 GMT

@Akshaya_1397 Take a look at
Working with Dates in the SAS System that's a good starting place

Dates, Times, and Intervals

Here's some examples of using SAS Date/Time values

data work.have ;
	date="15APR2023"d ; /* SAS Date Constant */
	put date= date= ddmmyy10. ; /* Output to the SAS log the raw date value and a formated date value */
	datetime="15APR2023 11:59:59"dt ; /* SAS Date Time Constant */
	put datetime= datetime= datetime. ;/* Output to the SAS log the raw datetime value and a formated datetime value */
	cdate=putn(date,"mmddyy8.") ; /* Convert a SAS date value into a character variable using a format (mmddyy8.) */
	put cdate= ;
run ;

Re: Dates

Akshaya_1397 — Fri, 12 May 2023 11:55:53 GMT

I have two seprate dates in which

Dataset A has the variable due_date = 03/01/2022- type-date length-8

Dataset B has the variable due_date = 01MAR2022:00:00:00- TYPE DATE

So I need to change the dates to same format.

Either A-B or B -A

Re: Dates

PaigeMiller — Fri, 12 May 2023 11:58:58 GMT

@Akshaya_1397 wrote:

I have two seprate dates in which

Dataset A has the variable due_date = 03/01/2022- type-date length-8

Dataset B has the variable due_date = 01MAR2022:00:00:00- TYPE DATE

So I need to change the dates to same format.

Either A-B or B -A

In SAS, there is no such thing as type-date, so I don't know what you mean. Nevertheless, you have not answered my questions, so I ask again:

Is 03/01/2022 in a character variable in a data set? Is it in a numeric variable in a data set? If numeric, what is the format? Is it found in a text file that you have to read into SAS? (okay, this last one is answered, these are in SAS data sets)

Re: Dates

yabwon — Fri, 12 May 2023 13:11:47 GMT

The origin of the confusion is that the EG, when you hoover over variable name in open dataset, if it recognise numeric variable with date/datetime fomat it displays "date" type.

Re: Dates

PaigeMiller — Fri, 12 May 2023 13:19:54 GMT

Ok, with the explanation for @yabwon you do the conversion in data set A like this

due_date=dhms(due_date,0,0,0);
format due_date datetime19.;