Hi all, I am trying to get ideas for generating a trend graph by year and a few other variables (4 exactly) by a categorical variable (3 categories). the year value represents crime per thousand. The building, traffic, space, and quality variables are all survey values (higher score is better) Any cool ideas are appreciated. Thanks data have; infile datalines dlm=','; input Area :$5. Year_2020 Year_2021 Year_2022 Building Traffic Space Quality; datalines; A,64,114,105,12.8,15,3.6,16.6 B,7,12,14,13.9,14.7,14.8,17.5 C,1,6,4,16.9,18.5,17,19.6 ;   ... View more

Hi, I have 2 datasets with 'initial' date  and several recorded dates for each ID. i want to be able to merge the dataset with the closest initial and recorded dates. Data Have1: ID Initial 1 1/31/2021 2 2/3/2021 3 1/4/2020 4 3/4/2019 5 3/5/2020 6 4/5/2019   data have1; infile datalines dlm=','; input ID Initial :mmddyy10.; format Initial mmddyy10.; datalines; 1,1/31/2021 2,2/3/2021 3,1/4/2020 4,3/4/2019 5,3/5/2020 6,4/5/2019 ; Data Have 2: ID Recorded  1 1/28/2021 1 2/5/2020 1 5/20/2021 1 2/21/2019 2 5/15/2021 2 2/18/2021 2 2/15/2021 3 3/2/2019 3 1/1/2020 3 5/5/2020 3 4/5/2021 4 5/2/2021 4 4/25/2020 4 3/20/2019 4 2/6/2020 4 6/10/2020 5 2/25/2020 5 3/18/2020 6 5/5/2019 data have2; infile datalines dlm=','; input ID Recorded :mmddyy10.; format Recorded mmddyy10.; datalines; 1,1/28/2021 1,2/5/2020 1,5/20/2021 1,2/21/2019 2,5/15/2021 2,2/18/2021 2,2/15/2021 3,3/2/2019 3,1/1/2020 3,5/5/2020 3,4/5/2021 4,5/2/2021 4,4/25/2020 4,3/20/2019 4,2/6/2020 4,6/10/2020 5,2/25/2020 5,3/18/2020 6,5/5/2019 ; Data Want: ID Initial Closest_Recorded 1 1/31/2021 1/28/2021 2 2/3/2021 2/15/2021 3 1/4/2020 1/1/2020 4 3/4/2019 3/20/2019 5 3/5/2020 2/25/2020 6 4/5/2019 5/5/2019 ... View more

Hi there,  I have 2 keywords that i need to search for and create new variables. The Keywords Med_A and Med_B are somewhere in free text in ColA and ColB. I need two create 2 new variables Med_A_Yes and Med_B_Yes. Basically these variables say if the ID has Med_A or Med_B. data have; infile datalines dlm=':'; input ID ColA :$100. ColB :$100.; datalines; 1: aam,Med_A,fsdsd: fdfd,Med_B 2: asd,Med_A,dasde: Med_A,dgdgd 3: dsd,Med_B,hrte: Med_B,dddfd 4: Med_A,dsfsf,rwrr++: dgdgd,Med_A 5: fdfdf,gdfgdg,Med_B: sfdfs,Med_A 6: Med_B,fssff,rrtwr,: Med_B,gsgsgs 7: ffdfd,Med_A,gdgdgg: Med_A,gsgse 8: Med_A,fsfgghe,fsgyt: Med_B,gdfsrer 9: dsdsf,Med_B,fghryhr: Med_B,++fdfs 10: fsfs,Med_B,gdghyyrr: . 11: ffsfs,tetetyeyy,Med_B: . 12: fsfsg,Med_Ahfhfhfhf: . ; Run; Data Have: ID ColA ColB 1 aam,Med_A,fsdsd fdfd,Med_B 2 asd,Med_A,dasde Med_A,dgdgd 3 dsd,Med_B,hrte Med_B,dddfd 4 Med_A,dsfsf,rwrr++ dgdgd,Med_A 5 fdfdf,gdfgdg,Med_B sfdfs,Med_A 6 Med_B,fssff,rrtwr, Med_B,gsgsgs 7 ffdfd,Med_A,gdgdgg Med_A,gsgse 8 Med_A,fsfgghe,fsgyt Med_B,gdfsrer 9 dsdsf,Med_B,fghryhr Med_B,++fdfs 10 fsfs,Med_B,gdghyyrr   11 ffsfs,tetetyeyy,Med_B   12 fsfsg,Med_Ahfhfhfhf     Data Want: ID Med_A_Yes Med_B_Yes 1 Med_A Med_B 2 Med_A   3   Med_B 4 Med_A   5 Med_A Med_B 6   Med_B 7 Med_A   8 Med_A Med_B 9   Med_B 10   Med_B 11   Med_B 12 Med_A   ... View more

Hi, I have a dataset with categories in different order. I want to create a consistency in the order as  [(i)cyt, (ii) end therapy, (iii) targ]. Also delete the (i),(ii), and (iii). Different versions are [(ii)cyt, (iii) targ, (ii) end therapy], [(iii)end therapy, (i) cyt, (iii) targ], etc. Please see the data below. Thanks   Data Have: ID Categories 1 (i)cyt, (ii) end therapy, (iii) targ 2 (ii)cyt, (iii) targ, (ii) end therapy 3 (iii)end therapy, (i) cyt, (iii) targ 4 iii) targ, (i) cyt, (ii) end therapy 5 (iii)end therapy, (i) cyt, (iii) targ 6 iii) targ, (i) cyt, (ii) end therapy 7 (i)cyt, (ii) end therapy, (iii) targ 8 (ii)cyt, (iii) targ, (ii) end therapy 9 (ii)cyt 10 (iii) targ 11  (ii) end therapy   Data Want: ID Categories Clean_Category 1 (i)cyt, (ii) end therapy, (iii) targ Cyt, End Therapy, Targ 2 (ii)cyt, (iii) targ, (ii) end therapy Cyt, End Therapy, Targ 3 (iii)end therapy, (i) cyt, (iii) targ Cyt, End Therapy, Targ 4 iii) targ, (i) cyt, (ii) end therapy Cyt, End Therapy, Targ 5 (iii)end therapy, (i) cyt, (iii) targ Cyt, End Therapy, Targ 6 iii) targ, (i) cyt, (ii) end therapy Cyt, End Therapy, Targ 7 (i)cyt, (ii) end therapy, (iii) targ Cyt, End Therapy, Targ 8 (ii)cyt, (iii) targ, (ii) end therapy Cyt, End Therapy, Targ 9 (ii)cyt Cyt 10 (iii) targ Targ 11  (ii) end therapy End Therapy   data have; infile datalines dlm=':'; input ID Categories :$100.; datalines; 1:(i)cyt,(ii)end therapy,(iii)targ 2:(ii)cyt,(iii)targ,(ii)end therapy 3:(iii)end therapy,(i)cyt,(iii)targ 4:iii)targ,(i)cyt,(ii)end therapy 5:(iii)end therapy,(i)cyt,(iii)targ 6:iii)targ,(i)cyt,(ii)end therapy 7:(i)cyt,(ii)end therapy,(iii)targ 8:(ii)cyt,(iii)targ,(ii)end therapy 9:(ii)cyt 10:(iii)targ 11:(ii)end therapy ; Run; ... View more