An Idea Exchange for SAS software and services

by Super User
on ‎08-18-2017 05:03 PM

Sincee the definition of the missing is a single character I doubt that SAS is going to make such a change.


However formats will do that though you would need one for character and another for numeric:


proc format;

value mymiss

. = 'NA';



proc print data=class;

   format _numeric_ mymiss.;


by Super User
on ‎08-18-2017 06:04 PM

Maybe. But they made that definition and can change it, I think consistency across applications is nice to implement. 

Yes, a nested format can be used in place but that's annoying when you have multiple formats, ie currency, time that you'd all like treated in a similar fashion. 



by Esteemed Advisor
on ‎08-20-2017 12:15 AM

I guess you would have to propose a similar change to the missing statement, so that missing values that can be output as NA could also be read back as missing.

by PROC Star
on ‎08-20-2017 02:12 PM

@PGStats I don't think it would need to be added to the missing statement.  That would require (I think) allowing numeric special missing values to be more than one character, which I'm guessing would be a big change.   If you're reading data with "NA" or "Missing" or "Null", I think it's fair for you to have to code your own informat, or deal with it some other way. 


But the ability using the missing option to have a numeric missing value displayed as "NA" or "Missing" instead of "." seems like it should be fairly simple.  I wonder if the mising option is using a hidden format in the background, somehow?

Idea Statuses
Top Liked Authors