Hi, I used proc import to transfer data to SAS. One of my variable ID (8 digit number) was transferred as numeric variable. When I used input function  to convert it to character variable by using   character=input(numeric, 8.);   it gives me a value of 0. I also tried using strip function before input but that gave me the same result. I want to convert a number (12345678) to character(12345678)   Does anyone have a suggestion?   Thanks     ... View more

Hi, I am having a trouble with my if then else statements, I wrote data all_1; set total; if hud080=. then h_count=.; else if hud080=77777 then h_count= .; else if hud080=99999 then h_count=.; else if huq071=1 and hud080=1 then h_count=1; else if huq071=1 and hud080 in (2,3,4,5,6) then h_count=2; else if huq071=2 then h_count=0; run;   Then my output for proc freq does not have h_count=0. Could anyone explain why h_count=0 is missing ?  Thanks SAS Output h_count Frequency Percent CumulativeFrequency CumulativePercent12Frequency Missing = 45980  3705 74.32 3705 74.32 1280 25.68 4985 100.00 ... View more

Hi all, I am trying to sum all values of some variables. Variables acd,bcd,.......ocd have either a value of 1,0, or missing So in order to get the total, I used the sum function.   data total; set start; count= sum(acd, bcd, ccd, dcd, ecd, fcd, gcd, hcd, icd, jcd, kcd, lcd, mcd, ncd, ocd); run;   But  I get an error message  on the log saying Missing values were generated as a result of performing an operation on missing values   What is wrong with my sum statement? thanks       ... View more

Hi, I have a dataset I want to flag if a condition is met.   The below is how my data look like. ID   treatment     1        0                    1        1                    1        1                    2        1                    2        1                     2        1                    3        1                    3        2                    3        2                       And I want to flag Ids that have used more than 1 treatment ID   treatment    Flag_multiple_tx (yes=1 no=0) 1        0                    1 1        1                    1 1        1                    1 2        1                    0 2        1                    0 2        1                    0 3        1                    1 3        2                    1 3        2                    1     I tried to use if tx=0 and tx=1 then flag_multiple_tx=0; if tx=0 and tx=2 then flag_multiple_tx=0; and so on. But it didn't work   Thanks ... View more

Hi, I have datasets that have multiple lines for person IDs and not sure if I can append these datasets. So my data contain;   Dataset1                ID        A     B      C 1          1     2      . 1          .      .       3 1          1     .       . 2          1     3     1 2           .     2     1 2          .      2       .   Dataset 2               ID        A     B      C 3         1     2      . 3          .      .       3 3         1     .       . 4         1     3     1 4           .     2     1 4          .      2       .   Is it possible to append dataset 1 and 2 and retain all the data in those datasets?   Thanks. ... View more

I have a large claims dataset that I flagged for variables of interest but now I want to identify those with no flagged variables, I flagged these variables by writing a code like this   data want; set have; if  ndc=123 then a=1; else if ndc=456 then b=1; else if ndc=789 then c=1; run;   What I have now is ID  A   B  C 1   1 2 3        1 4 5              1   Then I want to flag ID 2 and 5 for not having any flagged variables I tried data want; set have; where a ne 1 and b ne 1 and c ne; run; The above code did not flag ID 2 and 5   Please help Thanks ... View more