What Am I Doing Wrong?

[madtex99]

I have this statement written but when I run the code my format statement doesn't print. Any idea what I'm doing wrong?

data work.HW6;
        set TMP1.hw6;
proc format;
        value $TestSite 'Thoracic'='T' 'Lumbar-Spine'='LS';
        value TypeOfImaging 1='MRI' 2='CT' 3='Plain';
proc sort data=work.HW6 nodupkey;
        by descending dos;
proc print data=work.HW6;
run;

[ballardw · Accepted solution]

You would have to associate the Format with the variables that you want to use it.

Example: (Assumes that variables Thisvar and Thatvar are in the data set, Thisvar is a character variable and that you want those variables to show the formatted values.

proc print data=work.HW6;
   FORMAT thisvar  $testsite. thatvar TypeofImaging. ;
run;

If you want a variable to use a format by default then you make the association permanent by assigning it in a data step or use the utility procedure Datasets to modify the set as such.

The data step version would look like:

data work.HW6;
        set TMP1.hw6;
       format thisvar $testsite. thatvar TypeofImaging. ;
run;

The format does not actually have to exist in your session when assigned the variable but you should make sure it is available when you want to use it.