topic Re: Entire numeric and datetime variables missing after being imported in SAS in SAS Programming

Entire numeric and datetime variables missing after being imported in SAS

UcheOkoro — Fri, 07 May 2021 20:44:54 GMT

I imported a dataset into SAS from excel and noticed that the an entire numeric and datetime variables are showing as missing in SAS.

Please, I need some help with this.

Thank you.

Re: Entire numeric and datetime variables missing after being imported in SAS

UcheOkoro — Fri, 07 May 2021 20:52:31 GMT

Never mind. I figured it out. Please, how do I delete this question?

Re: Entire numeric and datetime variables missing after being imported in SAS

Reeza — Fri, 07 May 2021 20:55:01 GMT

Does that variable have a lot of missing data?
If so, and you can pre-sort your file so that some of your non missing values are at the top that would be the quickest fix.

If that's not possible please provide the following information to help answer your question:

How are you importing your data set?
And it's an Excel file, not CSV?
What is the variable type/format once imported?
Please show the code and log as well.

Re: Entire numeric and datetime variables missing after being imported in SAS

SASKiwi — Fri, 07 May 2021 22:26:26 GMT

@UcheOkoro - You don't delete questions, you mark them as answered.

Re: Entire numeric and datetime variables missing after being imported in SAS

Reeza — Fri, 07 May 2021 22:33:34 GMT

You post what the answer/resolution is and you can mark your own answer as the solution. Rest assured if you're having this issue others have as well and part of the purpose of a discussion board such as this is to leave a trail for future users to search for questions AND answers.

@UcheOkoro wrote:
Never mind. I figured it out. Please, how do I delete this question?

Re: Entire numeric and datetime variables missing after being imported in SAS

UcheOkoro — Fri, 14 May 2021 14:15:49 GMT

I discovered that the data was deleted due to an exclusion criteria, I applied to the data set.