Thank you ... View more

Thank you all, I ended u using Linlin's sugestion and also tried another way and was wondering if this way is correct as well I used this code and was wondering if it actually changes the values. DATA UT.BOOK1_TWN; SET UT.BOOK1_TWN_07;   if M022232 in (1,2) then M022232_1=1;     else M022232_1=0; if M022234A in (1,2) then M022234A_1=1;     else M022234A_1=0; if M022234B in (1,2) then M022234B_1=1;     else M022234B_1=0; if M042220 in (1,2) then M042220_1=1;     else M042220_1=0; drop M022232 M022234A M022234B M042220;   run; ... View more

Thank you The only problem I have is that I have never worked with SQL before and don't really know what it does. Thank you again ... View more

just a general question: does formatting change the actual value or does it only changes the appearance? Thank you ... View more

this is great. But would you please check my code for accuracy as well. will these variables be still numeric? Thank you proc format LIBRARY=LIB; value R4C   1 =1   8,98 =8   9,99 =9   other=0 ; value R2C 2=1 8,98 =8   9,99 =9   other=0 ; RUN; LIBNAME LIB 'C:\Users\Roofia\Desktop\GA\DATA\SAS\sascontrol'; OPTIONS FMTSEARCH=(LIB); RUN; dATA LIB.SUBSET_BK5_6try; SET LIB.GRADE8A ; format M022043 R4C. M022049 R2C.; run; ... View more

Hi, I have another quetion, When I apply the format to the variables, it looks like they are stored as characher variable since they are all left justidied. I was wondering why is that the case. Thank you R ... View more

thank you ... View more

Hello Patrick, I understand the first part (shown below) but don't quit get the rest. Am I creating a new format and then putting it in a permanent data set? if yes how does the rest does that? Also, It seems like I have use other, rather than otherwise, is that correct? Thank you proc format;   value M0Recode     4    =1     8,98 =8     9,99 =9     otherwise=0     ;   value M1Recode     10,19 =1     8,98  =8     9,99  =9     otherwise=0     ; run; ... View more

these are binary with: missing: 99 or 9 changed to 9 not administered: 98 or 8 changed all to  8 right now this is what I am doing, which is long for coding: IF M022043=4 THEN M022043=1; else if M022043=8 then M022043=8; else if M022043=98 then M022043=8; else if M022043=99 then M022043=9; else if M022043=9 then M022043=9; ELSE M022043=0; IF M022046=10 or  M022046=19 THEN M022046=1; else if M022046=8 then M022046=8; else if M022046=98 then M022046=8; else if M022046=99 then M022046=9; else if M022046=9 then M022046=9; ELSE M022046=0; below is an example of before and after. before after M0 M1 M02 M0 M1 M02 1 10 2 0 1 0 4 99 4 1 9 1 5 10 4 0 1 1 4 10 2 1 1 0 4 10 3 1 1 0 1 99 4 0 9 1 4 10 4 1 1 1 1 10 4 0 1 1 4 71 4 1 0 1 1 10 4 0 1 1 4 10 2 1 1 0 5 10 4 0 1 1 4 10 2 1 1 0 1 10 1 0 1 0 4 10 4 1 1 1 Thank you R ... View more

Thank you All, Low tech sounds great to me. Thanks ... View more

I've never worked with SQL syntax, so I actually do not know what any of these lines mean. Is there any other way to do this Thank you ... View more

Thanks Art, but this looks a lot more complicated than it should be. Is there any simple code for droping sequntial variables? thanks ... View more