Desktop productivity for business analysts and programmers

Importing spreadsheet with null values

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

Importing spreadsheet with null values

HI, I have a problem when I try to import a excel spreadsheet where the null values are not blank spaces but NULL. Is there any form that the Guide could import that values as null instead of a string that say NULL?

Thanks!


Accepted Solutions
Solution
‎10-28-2014 12:49 PM
Super Contributor
Posts: 333

Re: Importing spreadsheet with null values

In excel NULL is a character string so SAS is reading it in properly. You didnt really explain your situation, but if its just one file you could just simply do a find and replace in the excel spreadsheet replacing NULL with a space.

Or you can recode the fields once you get it into EG through a data step.

EJ

View solution in original post


All Replies
Solution
‎10-28-2014 12:49 PM
Super Contributor
Posts: 333

Re: Importing spreadsheet with null values

In excel NULL is a character string so SAS is reading it in properly. You didnt really explain your situation, but if its just one file you could just simply do a find and replace in the excel spreadsheet replacing NULL with a space.

Or you can recode the fields once you get it into EG through a data step.

EJ

Contributor
Posts: 58

Re: Importing spreadsheet with null values

Well, the excel file is generated for another program. I will try with data steps, because is a process that run daily and it's not efficient replace the excel file manually everyday. Thanks!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 556 views
  • 0 likes
  • 2 in conversation