10-12-2015 04:21 PM
I ran this below code in SAS 9.4 on Linux
input a $ b $;
if b='r' then b='';
proc export data=test dbms=xlsx outfile='/data/com/test1.xlsx' replace;
returns an xlsx with Non Printable Blank values. This is made sure with =ISBLANK function on the excel. The =ISBLANK of column 'b' is false for both observations. Whereas it should not be False for 2nd observation.
Please is there any way to correct this proc export dbms=xlsx option. I am not using pcfiles, as SAS 9.4 export to Linux does not need that but xlsx engine will be taking care of it.
Thank you very much for your help!