how can I permanently change variables values by using proc format...I want to create excle file.....but when I am trying to export file with formats it agains taking original variables values rathere then formats values.....
format govtn gov. age age.;
You don't show the formats for GOV. or AGE. formats. Without seeing how you are trying to format the numbers, it is impossible to understand what you mean when you say that Excel takes "original variable values rather than format values".
You also do not show the method by which you are getting output into Excel -- LIBNAME engine?? PROC EXPORT?? ODS CSV?? ODS HTML?? ODS TAGSETS.EXCELXP??
All of this information is essential to understanding the problem and making constructive suggestions.
value gov 0 = 'Confirming'
value $age '1'='25-49'
' 3'=' 70+'
format gover gov. age age.;
Now I am using proc export to export data set A in Excel format... I want format values in my exported excel sheet. But I got same variables values which are in data set B, how can I get this format values in my excel sheet....I will appreciate your help..