As a newbie, that scares me. But, I think I get it. Even though I previously applied and activated a format, the original numeric values for Race are still there and I should use those again? 1 = 'White' 2, 3, 4 = 'other'?
... View more
Sorry, I was trying to save time. I am aware that it is just a template to activate later. and it is not other='other' it really is .='other'. The source data is numeric. The original formating 1 = 'Causian' etc kept it numeric Let's ignore the 'not entered' for now. I think that is supposed to be other. I will have to double check later. My problem now is now to convert a numeric 'Caucasian' to 'White'.
... View more
In a previous formatting statement I created the numeric value of Race proc format; value Race 1 = 'Caucasian' 2 = 'Black' etc. so it is a numeric variable. I even double checked in the variables properties. And, yes 'Not Entered' and 'Other' are actual characters in the Race value.
... View more
I am receiving a syntax error with the following Race format. Can you please provide some guidance? Race is numeric and must remain numeric. proc format; value Race Caucasian = 'White' Black,Asian,not entered,other ='Other'; proc freq data=combine; tables Doselot Wt_Cat Race*Weight / nocum; format Race Race.;
... View more