Great! How would I go about selecting cases and matched controls based on the two variables? ... View more

What do you want the outcome to look like? ... View more

Data want ;      Set have ;      outcome = max (anxiety, stress, multiple, etc1, etc2, etc3, etc4) ; Run ; Richard ... View more

Since you didn't provide any example of your dummy variables or data layout I had to guess. If multiples of your dummy variables are 'Yes' then you need to describe the rules for which result you want. If the dummy variables are coded 0/1 and ONLY one is set to yest the code will work as described. Incomplete descriptions=incomplete answers. ... View more

Whist the above two answers are completely correct, I am questioning what the question is.  You state you have a starting point of 1998, which is fine.  It is this event date variable which I am not sure on.  Does this reference a time interval from the year or something else.  I.e. does it contain days since 1998, years since then, quarters, or is it something completely adhoc such as category 2 indicates 5 years. ... View more

So if the study start date is a constant then just use a date literal for the calculation. Assuming study day number 1 is 01JAN1988 then you would use. year = year(study_day + "01JAN1988"d -1) ; ... View more

I believe proc std rate will also give you the crude rate, which is essentially the incidence rate. You don't need a proc for this, its a simple data step, but you do have to have your data in an appropriate format. So, if you need help with the data step, you should post a sample of what your data looks like and the output you need. ... View more

Please post the SAS code you are using now to prepare your data for analysis and we'll take it from there. ... View more

Hello Mdormond, I have tested and it works exectily as you need: data Mdormond; input ID       Operation $       Start           End           Duration; datalines; 1 A 1 3 2 1 B 4 5 1 2 B 1 3 2 3 A 4 5 1 4 A 1 3 2 4 A 6 9 3 4 A 3 4 1 ; run; %macro Mdormond(var=);     proc transpose data=Mdormond                    out=&var.(drop=_name_)                    prefix=&var._;          var &var.;              by id;     run; %mend Mdormond; %Mdormond(var=Operation); %Mdormond(var=Start); %Mdormond(var=End); %Mdormond(var=Duration); data Mdormond_final;     merge Operation             Start               End               Duration;     by id; run; ... View more