Hello,    I have the following dataset:   data have; input cancer_year cancer_site $10. value_1 value_2 value_3 value_4; datalines; 1990 breast 100 100 100 100 1990 colorectal 2 1 5 10 1990 lung 8 78 64 30 1990 overall 1 2 3 4 1990 prostate 100 200 300 400 1990 thyroid 0 0 3 4 1991 breast 9 8 7 6 1991 overall 50 60 70 80 1992 overall 10 20 30 40 ;   But I want the following dataset.  data want; input cancer_year cancer_site $10. value_1 value_2 value_3 value_4; datalines; 1990 breast 100 100 100 100 1990 colorectal 2 1 5 10 1990 lung 8 78 64 30 1990 overall 1 2 3 4 1990 prostate 100 200 300 400 1990 thyroid 0 0 3 4 1991 breast 9 8 7 6 1991 colorectal 0 0 0 0 1991 lung 0 0 0 0 1991 overall 50 60 70 80 1991 prostate 0 0 0 0 1991 thyroid 0 0 0 0 1992 breast 0 0 0 0 1992 colorectal 0 0 0 0 1992 lung 0 0 0 0 1992 overall 10 20 30 40 1992 prostate 0 0 0 0 1992 thyroid 0 0 0 0 ; run; What I want is the 6 cancer_site values per each year. And I want zeros for value_1-value_4 for pairs not in the original dataset.   Any suggestions?   ... View more

I have this wide dataset structure.  data have; input ID 7. CO2 Methane N2O HFC; datalines; 1004377 54 28 54 30 1000112 88 40 72 1 ; And I want this long dataset structure.  data want; input ID 7. Substance $ Amount; datalines; 1004377 CO2 54 1004377 Methane 28 1004377 N2O 54 1004377 HFC 30 1000112 CO2 88 1000112 Methane 40 1000112 N2O 72 1000112 HFC 1 ; I'm sure there is an easy way to do this, but can't figure it out. Ideas? ... View more

I am working with a matched case control study, where there are multiple controls (case = 0) matched to one case (case = 1) by the variable "trimgroupid".   Each observation has it's own ID (uniqueid).   What I want to do is identify the controls that have a date of birth (dob) > 1 year away (+ or -) from it's matched case.   Here is what I have:   data have; infile datalines delimiter=','; length uniqueid $5 trimgroupid $7; format dob mmddyy10.; input uniqueid $ trimgroupid $ dob mmddyy10. case; datalines; X0131,XX01491,03/10/2000,1 X1831,XX01491,12/05/2002,0 X3691,XX01491,06/02/2000,0 X1971,XX04997,02/05/2010,1 X2611,XX04997,03/13/2011,0 X4371,XX04997,06/25/2009,0 X4621,XX04997,01/01/2009,0 ; run;   And here is what I want: data want; infile datalines delimiter=','; length uniqueid $5 trimgroupid $7; format dob mmddyy10.; input uniqueid $ trimgroupid $ dob mmddyy10. case; datalines; X1831,XX01491,12/05/2002,0 X2611,XX04997,03/13/2011,0 X4621,XX04997,01/01/2009,0 ; run;   For the trimgroupid value of XX01491 there is 1 control whose dob is > 1 year away from the case it is matched to. For the trimgroupid value of XX04997 there are 2 controls whose dob is > 1 year away from the case it is matched to. ... View more