Hi, whatever I do, I can not make blank cells be really "empty", after I export the dataset to xlsx. Excel function ISBLANK returns always FALSE, no matter what data type the column is (datetime, number,string). Although, Cell.Value = "" (in Excel). I created an xlsx file which had really blank cells (ISBLANK returned TRUE), I imported it into SAS, without any change exported it back as xlsx and still i got FALSE from ISBLANK function. I tried to convert column to string, rewrite on "" (when the cell was null) and then convert it back to its original data type, did not help. Any advice? Thanks, Vojtech SAS vers. 7.1 HF1 (7.100.0.2002) (32-bit)
... View more