topic Re: Quality Control (PROC PARETO) in SAS Procedures

Quality Control (PROC PARETO)

sss — Fri, 22 Apr 2011 17:50:03 GMT

ORGID SITEID ID FAILURES MTBF_HRS MTTR_HRS COST
CRIS CLAY 1001 949 1709.28 1323.68 4410.66
CRIS CLAY 1002 11 2635.68 4187.84 8154.27
CRIS CLAY 1003 37 3979.92 0875.92 8054.62
CRIS CLAY 1004 161 3144.24 2236.4 29079.5
CRIS CLAY 1005 42 1526.16 726.72 53186.23
CRIS CLAY 1006 21 5723.44 134.24 10191.55
CRIS CLAY 1007 75 7322.4 494.16 30624.88
CRIS CLAY 1009 91 9414.16 627.52 30427.12
CRIS CLAY 1013 1 237.12 36 814.5

proc pareto data=Failure;
vbar ID / freq = _failures
last = 'Miscellaneous'
scale = count
anchor = bl
nlegend ;
run;

I tried with porc pareto to get such kind of output but wasnt possible for me

@@@ |
@@@ |
failures |______________________________________
@@@ |
@@@ |
@@@ |
cost @ |______________________________________
@@@ |
@@@ |
@@@ |
MTTR |_________________________________________
@@@ |
@@@ |
@@@ |
MTBF@|________________________________________
1001 1002 1003 1004 1005 1006 ---- - - - - - - -

Hope u understood what i am looking for i want to print such kind of output in sas or eg etc by showing the values in vertical bars for id by varialbes .

Thr is no use of @ symbol to plot graph systematical i used @ symbol

please please help me out ....

thnk a lot

Re: Quality Control (PROC PARETO)

Bill — Mon, 25 Apr 2011 13:44:02 GMT

The code below works for me; You had freq=_failures instead of failures.

data failure;
input ORGID $ SITEID $ ID $ FAILURES MTBF_HRS MTTR_HRS COST;
cards;
CRIS CLAY 1001 949 1709.28 1323.68 4410.66
CRIS CLAY 1002 11 2635.68 4187.84 8154.27
CRIS CLAY 1003 37 3979.92 0875.92 8054.62
CRIS CLAY 1004 161 3144.24 2236.4 29079.5
CRIS CLAY 1005 42 1526.16 726.72 53186.23
CRIS CLAY 1006 21 5723.44 134.24 10191.55
CRIS CLAY 1007 75 7322.4 494.16 30624.88
CRIS CLAY 1009 91 9414.16 627.52 30427.12
CRIS CLAY 1013 1 237.12 36 814.5
;
run;

goptions reset=all dev=win;
proc pareto data=Failure;
vbar ID / freq = failures
maxncat=8
last = 'Miscellaneous'
other = 'Miscellaneous'
scale = count
anchor = bl
nlegend ;
run;

Re: Quality Control (PROC PARETO)

sss — Mon, 25 Apr 2011 16:45:15 GMT

hey BILL

Thanks for your reply.I really dont know how to express my problem, But i tried my best to explain it.

U have plotted the graph wrt to ID and Failures, what i am looking for is i want to plot the graph WRT ID, failures, MTBF_HRS MTTR_HRS COST.

In i single graph.. sample output has been posted in previous post