topic Re: datetime and date formatting issue in New SAS User

datetime and date in same column

user112a2 — Fri, 26 Apr 2019 15:45:53 GMT

I have a question. I have a field in my SAS dataset that has a mixture of datetime and date variables.
The field is PST_DT and is Type: Numeric. Group: Date. Format: Date9. Length: 8.
Some values look like this:

Removed

How can I turn just the datetime values in date format? I want all the values to be in date format.
Thanks.

Re: datetime and date formatting issue

PeterClemmensen — Wed, 10 Oct 2018 13:37:46 GMT

This does not look like a date9 formatted variable. Can you show a PROC CONTENTS output?

Re: datetime and date formatting issue

user112a2 — Fri, 26 Apr 2019 17:46:05 GMT

Removed

Re: datetime and date formatting issue

Kurt_Bremser — Wed, 10 Oct 2018 13:47:02 GMT

@user112a2 wrote:

I have a question. I have a field in my SAS dataset that has a mixture of datetime and date variables.
The field is PST_DT and is Type: Numeric. Group: Date. Format: Date9. Length: 8.
Some values look like this:
PST_DT
8/22/2018  11:59:59 PM
8/22/2018
How can I turn just the datetime values in date format? I want all the values to be in date format.
Thanks.

There's nothing at all that looks like a date9 formatted value.

Is your example actually a part of a text file you want to read into a SAS dataset?

Re: datetime and date formatting issue

Kurt_Bremser — Wed, 10 Oct 2018 13:49:38 GMT

Then your original example CAN NOT be from this dataset. Your date values would both(!) display as 22AUG2018, without ANY time value.

@user112a2 wrote:

Re: datetime and date formatting issue

user112a2 — Wed, 10 Oct 2018 13:51:11 GMT

These values were imported from an excel file into SAS. Some of the values had dates and some had datetime values. These were imported into a SAS data set.

Re: datetime and date formatting issue

Kurt_Bremser — Wed, 10 Oct 2018 13:52:51 GMT

Then please post the values as they are in the dataset. A date9. formatted variable can NEVER look like 8/22/2018. NEVER.

Re: datetime and date formatting issue

user112a2 — Fri, 26 Apr 2019 17:46:38 GMT

This worked!!!!

Removed

Re: datetime and date formatting issue

FreelanceReinh — Wed, 10 Oct 2018 21:07:51 GMT

@user112a2 wrote:

This worked!!!!

data OUT.REQ_1_3_02 ;
SET OUT.REQ_1_3_01;

a= day(PST_DT);
b= month(PST_DT);
 c= year(PST_DT);
 date = input(catx("/",b,a,c),mmddyy10.);
 format date mmddyy10.;
run ;

Under normal circumstances, if PST_DT contains valid SAS date values or ordinary missing values, the four highlighted lines above could be simplified to:

date=PST_DT;