filename sheet1 dde "excel|sheet1!r7c1:r100c70" notab; libname sd2 'e:\tempsas\sd2\prepared'; data sd2.carer_checklist; infile sheet1 missover dlm='09'x dsd; input id : $10. hosp : $10. cQ11 : 4. cQ12 : date9. cQ13 : 1. checklist: 1. cQ14 : date9. cQ15 : $10. cQ16 : 1. cQ18 : 1. cQ21 : 1. cQ22 : 1. cQ23 : 1. cQ24 : 1. cQ25 : 1. cQ31 : 1. cQ31a : 1. cQ32 : 1. cQ32a : 1. cQ33 : 1. cQ34 : 1. cQ41 : 1. cQ42 : 1. cQ42tran : 1. cQ42meds : 1. cQ42DK : 1. cQ42oth : 1. cQ51 : 1. cQ52 : 1. cQ53 : 1. cQ54 : 1. cQ55 : 1. cQ56 : 1. cQ61GP : 2. cQ61PT : 2. cQ61OT : 2. cQ61DC : 2. cQ61DN : 2. cQ61ED : 2. cQ61SP : 2. cQ61Ch : 2. cQ61MOW : 2. cQ61OthHP: 2. cQ61oth : 2. cQ62 : 1. cQ62taxi : 6. cQ62shop : 6. cQ62chmst: 6. cQ62oth : 6. cQ62pet : 6. cQ62gap : 6. cQ62PH : 6. cQ63 : 1. cQ71 : 1. ; if cQ33=9 or cQ24=9 or cQ25=9 or cQ31=9 or cQ32=9 or cQ21=9 or cQ22=9 or cQ23=9 or cQ41=9 or cQ52=9 or cQ42=9 or cQ41=9 or cQ52=9 or cQ55=9 or cQ56=9 then group=9; **Process domains; **Domain 1 information on support structures; cdom1raw=cQ33+cQ24+cQ25+cQ31+cQ32; cdom1=(cdom1raw/7)*100; **Domain 2 medication management; cdom2raw=cQ21+cQ22+cQ23; cdom2=(cdom2raw/6)*100; **Domain 3 information on community management; cdom3raw=cQ41+cQ52; cdom3=(cdom3raw/3)*100; **Domain 4 control of circumstances; cdom4raw=cQ42; cdom4=(cdom4raw/1)*100; **total process domain; ctotdomr=cdom1raw+cdom2raw+cdom3raw+cdom4raw; ctotdom=(ctotdomr/17)*100; **Outcome; coutcomraw=cQ41+cQ52+cQ55+cQ56; coutcome=(coutcomraw/5)*100; **serviceuse; cservuse=cQ61GP+cQ61PT+cQ61OT+cQ61DC+cQ61DN+cQ61ED+cQ61SP+cQ61Ch+ cQ61MOW+cQ61OthHP+cQ61oth; **costs; ccosts=cQ62taxi+cQ62shop+cQ62chmst+cQ62oth+cQ62pet+cQ62gap+cQ62PH; c_age=(cQ12-cQ14)/365; proc freq; tables group; run; data temp; set sd2.carer_checklist; proc freq; tables hosp cQ11 cQ13 cQ15 cQ16 cQ18; proc freq; tables cQ21; proc freq; tables cQ22; proc freq; tables cQ23; proc freq; tables cQ24; proc freq; tables cQ25; proc freq; tables cQ31; proc freq; tables cQ31a; proc freq; tables cQ32; proc freq; tables cQ32a; proc freq; tables cQ33; proc freq; tables cQ41; proc freq; tables cQ42; proc freq; tables cQ42tran; proc freq; tables cQ42meds; proc freq; tables cQ42DK; proc freq; tables cQ42oth; proc freq; tables cQ51; proc freq; tables cQ52; proc freq; tables cQ53; proc freq; tables cQ54; proc freq; tables cQ55; proc freq; tables cQ56; proc freq; tables cQ61GP; proc freq; tables cQ61PT; proc freq; tables cQ61OT; proc freq; tables cQ61DC; proc freq; tables cQ61DN; proc freq; tables cQ61ED; proc freq; tables cQ61SP; proc freq; tables cQ61Ch; proc freq; tables cQ61MOW; proc freq; tables cQ61OthHP; proc freq; tables cQ61oth; proc freq; tables cQ62; proc freq; tables cQ62taxi; proc freq; tables cQ62shop; proc freq; tables cQ62chmst; proc freq; tables cQ62oth; proc freq; tables cQ62pet; proc freq; tables cQ62gap; proc freq; tables cQ62PH; proc freq; tables cQ63; proc freq; tables cQ71; proc means; var c_age; run; data temp1; set sd2.carer_checklist; if group ne 9; proc sort; by checklist; proc means; var cdom1 cdom2 cdom3 cdom4 ctotdom cQ71 coutcome cservuse ccosts; proc means; by checklist; var cdom1 cdom2 cdom3 cdom4 ctotdom cQ71 coutcome cservuse ccosts; proc ttest; class checklist; var cdom1 cdom2 cdom3 cdom4 ctotdom cQ71 coutcome cservuse ccosts; run;