Hi all, I am taking data from a survey that is numerical. The questions is how many days in a month have you had good mental health days. In the code book 0 days= 88 but 1 day is just 1 and so on. I need to change the 88 to 0 without messing up other numbers of days like 10, 20, 30 (ultimately need to look at the avg and the 88 is messing this obviously). My current code does not do that- my dataset puts in a (*) when it is 10,20,30. Here is what I have so far. Thanks so much! proc format; value menthlth 88= 0 ; run; data sasfile.Final_subset2; set sasfile.Final_subset; format menthlth menthlth. ; /*apply formats to created variables*/ run;
... View more