topic Reading sas dates in SAS Programming

Reading sas dates

Yamunanz2019 — Wed, 27 Feb 2019 15:02:18 GMT

Hi I have a columnX with date16.
Ex
X
22Sep17:11:30:22
22Sep17:11:32:11

I am writing sas code as
Data sample1;
Set sample;
Where x=‘‘22Sep17:11:30:22’’dt;
Run;

I am not able retrieve columns with 22Sep17:11:30:22.

Can you please help me where I am going wrong.

Thanks
Yam

Re: Reading sas dates

PaigeMiller — Wed, 27 Feb 2019 15:06:24 GMT

@Yamunanz2019 wrote:
Hi I have a columnX with date16.
Ex
X
22Sep17:11:30:22
22Sep17:11:32:11

I am writing sas code as
Data sample1;
Set sample;
Where x=‘‘22Sep17:11:30:22’’dt;
Run;

I am not able retrieve columns with 22Sep17:11:30:22.

Can you please help me where I am going wrong.

Thanks
Yam

This indicates to me that you have text in X, and not a valid SAS datetime. But really, we can't help further unless you show us your code you are using, and provide the input data as a SAS data step (and not in any other format).

Re: Reading sas dates

RW9 — Wed, 27 Feb 2019 15:06:41 GMT

Please review the post a question guidance, it is essential in almost every instance to provide data in the form of a runnable program. We can't see your computer, and "it does not work" does not tell us anything. This code for instance does work perfectly well:

data have;
  x="22Sep17:11:30:22"dt; output;
  x="22Sep17:11:32:11"dt; output;
run;

data sample1;
  set have;
  where x="22Sep17:11:30:22"dt;
run;

See:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

About getting your data usable.

Re: Reading sas dates

novinosrin — Wed, 27 Feb 2019 15:08:28 GMT

is that date16. or datetime16.?

Re: Reading sas dates

Yamunanz2019 — Wed, 27 Feb 2019 15:19:55 GMT

Datetime16.

And it is numeric

Re: Reading sas dates

Yamunanz2019 — Wed, 27 Feb 2019 15:20:40 GMT

The above mentioned solution is not working. It is returning zero records

Re: Reading sas dates

novinosrin — Wed, 27 Feb 2019 15:33:17 GMT

Here is my test, please verify


data have;
input date :datetime16.;
format date datetime16.;
cards;
22Sep17:11:30:22
22Sep17:11:32:11
;


data want;
set have;
where date='22Sep17:11:30:22'dt;
run;

Re: Reading sas dates

Yamunanz2019 — Wed, 27 Feb 2019 15:33:35 GMT

Can someone suggest a solution please

Re: Reading sas dates

PaigeMiller — Wed, 27 Feb 2019 15:38:00 GMT

@Yamunanz2019 wrote:
Can someone suggest a solution please

You have to provide us a portion of your data (as SAS data step code, and not in any other form) for us to help you further.

Re: Reading sas dates

FreelanceReinh — Wed, 27 Feb 2019 16:34:59 GMT

@Yamunanz2019 wrote:
Can someone suggest a solution please

Decimal places (fractions of a second) can be the reason why the values of X differ slightly from what the DATETIME16. format displays. In this case rounding should work:

where round(x)='22Sep17:11:30:22'dt;

Re: Reading sas dates

Tom — Wed, 27 Feb 2019 17:03:45 GMT

Two issues to check.

1) Your actual dates have fractions of seconds stored, so the values do not exactly match. Either round the values or use inequalities in your test.

2) Your actual dates are from a different century than the what you are testing for.

Display the values using DATETIME19. instead or DATETIME16. to see the full year. (there is a bug in the DATETIME format and you need to use 19 to get four digit years, even though it should fit in 18 characters.)

Display the values using DATETIME24.3 to see if there are fractions of seconds.

Re: Reading sas dates

Yamunanz2019 — Wed, 27 Feb 2019 17:05:50 GMT

Thank you. It worked.👍