topic Re: Importing spreadsheet with null values in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145944#M11554 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Or you can recode the fields once you get it into EG through a data step.</P><P></P><P>EJ</P></BODY></HTML> Tue, 28 Oct 2014 16:49:04 GMT esjackso 2014-10-28T16:49:04Z Importing spreadsheet with null values https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145943#M11553 <HTML><HEAD></HEAD><BODY><P>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?</P><P>Thanks!</P></BODY></HTML> Tue, 28 Oct 2014 16:36:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145943#M11553 fri0 2014-10-28T16:36:12Z Re: Importing spreadsheet with null values https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145944#M11554 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Or you can recode the fields once you get it into EG through a data step.</P><P></P><P>EJ</P></BODY></HTML> Tue, 28 Oct 2014 16:49:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145944#M11554 esjackso 2014-10-28T16:49:04Z Re: Importing spreadsheet with null values https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145945#M11555 <HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML> Tue, 28 Oct 2014 16:54:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Importing-spreadsheet-with-null-values/m-p/145945#M11555 fri0 2014-10-28T16:54:59Z