BookmarkSubscribeRSS Feed
UcheOkoro
Lapis Lazuli | Level 10

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. 

5 REPLIES 5
UcheOkoro
Lapis Lazuli | Level 10
Never mind. I figured it out. Please, how do I delete this question?
SASKiwi
PROC Star

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

Reeza
Super User

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?

 

Reeza
Super User
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.
UcheOkoro
Lapis Lazuli | Level 10

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1223 views
  • 0 likes
  • 3 in conversation