Hi, please see attached my Dataset that I created with BY variable (period). Can you please help me with the code? I am trying the following. proc format;
value fmec
10 ="1. Errors due to system configuration and functionality "
11= "1.1 System malfunction "
12 ="1.2 System contains incorrect order sentence or other incorrect configuration "
13= "1.3 Limitation in system functionality"
20= "2. Prescribing for wrong patient"
30= "3. Selection Errors "
31= "3.1 Selection errors when ordering"
32= "3.2 Selection errors when constructing or editing an order "
40= "4. Construction Errors"
50= "5. Editing Errors"
51= "5.1 Editing errors (general)"
52= "5.2 Editing errors when using the dose calculator or recording patient weights"
53= "5.3 Editing errors that occur when correcting a previous TRE"
54= "5.4 Editing errors that occur when failing to edit default time/date "
55= "5.5 Editing errors that occur when misusing order actions on existing orders "
60= "6. Errors that occur when using new workflows"
61= "6.1 Failure to view the updated medication profile, active workspace, or medication chart prior to ordering"
62= "6.2 Errors that occur when prescribing via an order set "
63= "6.3 Failure to activate a future order, or failure to view planned/pending future order or current activated order "
64= "6.4 Errors due to misuse of actions when ordering discharge or outpatient prescriptions, or when ordering from medication history or using medication reconciliation functionality"
65= "6.5 Errors when using tasks and reminders"
66= "6.6 Other"
70= "7. Errors Due to Hybrid Systems"
71= "7.1 Errors occurring during initial system rollout (transition from paper to electronic)"
72= "7.2 Errors occurring during downtime"
73= "7.3 Errors occurring when paper charts are used for some prescribing "
74= "7.4 Errors occurring when different electronic systems operate within the same hospital";
data paretom; set paretom;
format mech10 fmec.; run;
proc sgplot data=paretom noautolegend; by period;
vbarbasic mech10 / response=count
datalabel;
refline 400 /axis=y label="80% line"
labelattrs=(color=green)
labelloc=inside;
series x=mech10 y=cum_pct/ markers y2axis ;
yaxis values=(0 to 500 by 50) label='Frequency';
y2axis values=(0 to 100 by 10) label='Cumulative %';
xaxis display=(nolabel) fitpolicy=split splitchar='*';
run;
... View more