https://communities.sas.com/t5/SAS-Procedures/Question-on-PROC-TRANSPOSE-options/m-p/71659#M20695 Hi,<BR /> <BR /> Is there an option in PROC TRANSPOSE procedure where we can replace blank values with some character variable after data gets transposed.<BR /> <BR /> For example, if one of my variable is getting value as blank, I want to output as "n/a". I have checked SAS Documentation, but not sure there is an option to do this. Thanks in advance!! Fri, 26 Mar 2010 19:45:43 GMT deleted_user 2010-03-26T19:45:43Z https://communities.sas.com/t5/SAS-Procedures/Question-on-PROC-TRANSPOSE-options/m-p/71659#M20695 Hi,<BR /> <BR /> Is there an option in PROC TRANSPOSE procedure where we can replace blank values with some character variable after data gets transposed.<BR /> <BR /> For example, if one of my variable is getting value as blank, I want to output as "n/a". I have checked SAS Documentation, but not sure there is an option to do this. Thanks in advance!! Fri, 26 Mar 2010 19:45:43 GMT https://communities.sas.com/t5/SAS-Procedures/Question-on-PROC-TRANSPOSE-options/m-p/71659#M20695 deleted_user 2010-03-26T19:45:43Z https://communities.sas.com/t5/SAS-Procedures/Question-on-PROC-TRANSPOSE-options/m-p/71660#M20696 No option with TRANSPOSE - you may be able to use a DATA step to modify SAS CHARACTER variable(s) (depending on sufficient length or use a FORMAT). There is the possible alternative with NUMERIC variables to set MISSING='?' (one char allowed).<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Fri, 26 Mar 2010 20:11:40 GMT https://communities.sas.com/t5/SAS-Procedures/Question-on-PROC-TRANSPOSE-options/m-p/71660#M20696 sbb 2010-03-26T20:11:40Z