@Nyruz wrote:
Hello,
Thank you for your answer. I have 1178 variables, and I need to check them. you said I can use Proc Format code and SAS Formats to know the value of my variable, but how can I do that?
Here is a brief example of using a custom format to display a different more human legible value from a list of codes.
proc format library=work;
value $dummy
'A' = "Audi"
'B' = "BMW"
'C' = "Chevrolet"
'P' = "Pontiac"
other = "Not in list"
;
run;
data example;
input firstcar $ secondcar $ thirdcar $;
datalines;
A A .
B C P
D B A
;
run;
proc print data=example noobs;
format firstcar secondcar thirdcar $dummy.;
run;
Proc format creates the custom format that will display the value on the right side of the = sign instead of the code value on the left. The $ in the format name $dummy says this format is to be used with character varaibles, you could have another format dummy for numeric but they correct name must be used whe applying to variables depending on the variable type.
The special instruction other displays the text "Not in list" for any code that was not explicitly assigned. Without this instruction the actual value of the variable would display.
The data step just creates an example data set containg multiple variables that contain code values do display using the format. Note that just like SAS supplied formats that the format ends in a period when used.
The proc print shows one way of displaying the values using the format.
If your variables that are going to be displayed using the same format are "nice" , such as Var1 to Var100 then a variable list on the format statement makes the code short:
format Var1 - Var100 $dummy. ;
The format could be associated with the variables permanently when created and if the format is available they will by default show the formatted values.
