I am trying to export some data to Excel from SAS EG 7.1 using proc export and dbms = xls. It works well except that one of my numeric variables includes both ordinary missings and .S and both are converted to blanks in the export. Is there a way to retain the .S as this or some other value that distinguishes it from the ordinary missings?
One solution is to use dbms = .csv but I then have problems with losing leading zeros in a character variable. And I also can't export multiple SAS datasets to different worksheets in the same Excel file then.
And another is to convert the numeric variable to a character - this changes .S to S which is fine, but converts the ordinary numeric missings to . in Excel plus all numbers to text which isn't so helpful.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.