Hi,   I have a SAS data set which has data for "estimated population count" for 33 counties "Fipscode:county fipscode, 2-digit numeric"variable, years 1990-2016. I have to add a variable named ALAND10 (from excel) which has a land area for each of the fipscode county variable in SAS (33 counties).  Later I need to calculate population density from the land area and population estimates. I've attached a SAS data and excel clip.   Thanks       ... View more

Hi,   I have a cancer dataset "Test" for years 1990 to 2013. It has two variables Casite35 with 35 codes and Casite81 with 81 codes, each code represent a cancer type. All cancers were reported for years 1990 to 2013 except for Benign Brain Cancer from year 2004 to 2013 in both variables (Casite35 and casite81). I used the following SAS commands to restrict them to years 2004-2013:   data Cancer;     set Test;     if CaSite35 in (27) then do;          if 2004 le year le 2013 then output;          else; /* do nothing for the brain cancer codes*/     end;     else output; /* all the other codes for CaSite35*/ run;     data Cancer_13;     set Cancer;     if CaSite81 in (31020) then do;          if 2004 le year le 2013 then output;          else; /* do nothing for the brain cancer codes*/     end;     else output; /* all the other codes for CaSite81*/ run;   I know it's wrong to use it this way. The Cancer_13 observations were less than the observations in the original dataset "Test" and I think I figure out the reason why. I tried to change the codes in different ways like merging both statements into one statement for example but none worked. So is there anyway that I can restrict those two codes in both variables without affecting the other variables and the observations in the data set?   Thank you. ... View more

Hi, I have a cancer data set that have a Seer_group variable (have the same coding as SEER Cancer Data (20010, 20020...31010, 31020...) and a beh variable coded as 0, 1, 2 and 3 ( depending on the malignancy behavior). I'm trying to create a new variable CaSite81 which includes all the seer group variables plus adding 6 more variables for brain and breast cancer (also change the seer group variable into numeric)as follows: CASite81=Seer group*1; if Seer_group="" then CAsite81 = 99999; if Seer_group in ( 26000 ) and beh=2 then CASite81= 26010 ; *Breast, In Situ; if Seer_group in ( 26000 ) and beh=3 then CASite81= 26020 ; *Breast, Invasive; if Seer_group in ( 31010 31040 ) and beh in (0 1) then CASite81= 31020 ; *Brain and Other Nervous System (Benign); if Seer_group in ( 31010 31040 ) and beh=3 then CASite81= 31021 ; *Brain and Other Nervous System (Malignant); if Seer_group in ( 31010 ) and beh=3 then CASite81= 31030 ; *Brain (Malignant); if Seer_group in ( 31040 ) and beh=3 then CASite81= 31031 ; *Cranial Nerves Other Nervous System (Malignant);   When I run the Freq Casite81*beh or Casite*year all have frequencies except 31021. I can't find any explanation for that.  The freq table for the original variables (31010 1nd 31040) *beh has the following:                                Beh Seer_group      0      1       2        3   31010          197   215     0      2465     31040         2172  118     0      187   Freq for Casite81 I get:                                Beh Seer_group      0        1       2        3   31020           2369  333     0        0   31030             0       0        0      2465   31031             0       0        0      187   Freq Casite81 Seer_group *Year have only 31020, 31030, 31031 also. I'm so confused why this 31021 does not show at all.   Thanks     ... View more