The Stata codes were to generate a new insurance categorical variable (r{*}ins, i is from 1 to 13) within each study id repeating for 13 years which is a long form of data. Here is what I have figured out: Using the first year (r1ins) as an example: r1ins=.; If r1higov =1, then r1ins = 1; ELSE If (r1higov =1 & r1covr=1) or if (r1higov=1 & r1covs=1) then r1ins = 2; ELSE If (r1higov=1 & r1hiothp=1) then r1ins = 3; ELSE If (r1covr=1 or r1covs=1) and (r1ins is missing) then r1ins = 4; ELSE If (r1hiothp=1 & r1ins is missing) then r1ins = 5; ELSE If r1higov=0 & r1covr=0 & r1covs=0 & r1hiothp=0 then r1ins = 6; The last part of the Stata codes were to format the riins, which can be converted to following SAS codes: PROC FORMAT; VALUE ins_fmt 1 = "Government Insurance Only" 2 = "Government Insurance and Employer" 3 = "Government Insurance and Other" 4 = "Employer Only" 5 = "Other only" 6 = "No Insurance"; RUN; I still need help to write the SAS codes for all 13 years within each study id. Thanks.
... View more