Hi I am trying to create age group variable  from age variable which is a character variable.  this code is not producing anything what is wrong with this code? data STIREPOT.STI2020_Age_Grp; set STIREPOT.STI2020_D; length age_grp $ 6; IF Age='0' And age='4' THEN AGE_GRP='0-4'; IF Age='5' AND age='9' THEN AGE_GRP= '5-9'; IF Age='10' AND age='14' THEN AGE_GRP= '10-14'; IF Age='15' AND age='19' THEN AGE_GRP= '15-19'; IF Age='20' AND age='24' THEN AGE_GRP= '20-24'; IF Age='25' AND age='29' THEN AGE_GRP= '25-29'; IF Age='30' AND age='34' THEN AGE_GRP= '30-34'; IF Age='35' AND age='39' THEN AGE_GRP= '35-39'; IF Age='40' AND age='44' THEN AGE_GRP= '40-44'; IF Age='45' AND age='49' THEN AGE_GRP= '45-49'; IF Age='50' AND age='100' THEN AGE_GRP= '>=50'; run; ... View more

data MSM2017; input Alerts $ MSM $ Counts; Datalines; No Yes 20 No No 240 Yes Yes 3 Yes No 3 ; proc freq data=MSM2017; tables MSM*Alerts/RELRISK; WEIGHT COUNTS ; RUN; Hi i would like to know what is wrong with the code i have above.  There are 3 patients that are MSM and they are Alert, and there are 20 patients that are MSM but they are not alert. There are 3 patients that are Alerts but they are not MSM, and there are 240 patients that are not MSM and Not Alert. I would like to know what is risk of being MSM to become an Alert.  Is MSM at higher risk of becoming an alert patient? ... View more

Hi I have a data like this: data have; input ID EventID Male $ Female $ MTF $ FTM $; datalines; 1 1 male 1 2  1 3 male 2 1    female 2 2    female 2 3  3 1          mtf 3 2          3 3        Mtf run;  I want it to be: 1 1 male 1 2  male 1 3 male 2 1    female 2 2    female 2 3    female 3 1          mtf 3 2          mtf 3 3         mtf data want; do until(last.Ieventid); set have; length m $4; length f $6; length mtf $14; length ftm $14; by eventid; M=Catx('' , Male); F=Catx('' , Female); mtf=Catx('' , mtf); end; run; ... View more

Hi I have a data like this data Test; input ClientID IncidentID Episodedate mmddyy10.; cards; 4750 3119 03/05/2018 1021 3110 11/06/2018 1021 3111 01/07/2019 4765 3576 03/28/2019 4767 3821 10/25/2019 4770 3332 10/08/2018 4770 3631 05/23/2019 4770 3798 10/09/2019 run;   I want ClientID IncidentID Episode Date Days between first and second Episode Days between second and third Episode 4750 3119 03/05/2018                  0 1021 3110 11/06/2018 1021 3111 01/07/2019                 52 4765 3576 03/28/2019                 0 4767 3821 10/25/2019                 0 4770 3332 10/08/2018 4770 3631 05/23/2019                227 4770 3798 10/09/2019                                                                              180   Please help me.  It needs to be grouped by client id.  Some client id has more than three episodes in two year period.  I tried this, did not work. proc sql; create table repeat as select clientid, min(Episodedate) as Episode1, max(Episodedate) as Episode2, max(Episodedate) - min(Episodedate) as repeat_inf_day from have group by Clientid; quit; ... View more