BookmarkSubscribeRSS Feed
schreima
Calcite | Level 5

Hello SAS-Community,

would you have any idea how to create a Pareto Chart in SAS Visual Analytics. I'm interested to create 2 Pareto Chart.

The first one using a category and the frequency.

The second one using a category and a measure.

Those are the type of charts I can use in our SAS VA version.

Thanks a lot for your support

Best Regards,

Markus

5 REPLIES 5
PeterWijers
Lapis Lazuli | Level 10

Markus,

you must have already selected a non numberic variable, so the histogram  (Pareto) is greyed out.  (Historgam can not deal with a non numberic value).

Please start with an enpty screen and directly select the Historgrom before you select anay data fields.

If you did not yet select any variable, I have no idea why the Histogram icon is greyed out.  (and thats the one you need....Smiley Wink)

Good luck. Smiley Happy

schreima
Calcite | Level 5

Hi Peter,

creating the histogramm is fine for me, but how can I create a cumulative measure and cumulative percentage measure based on the used measure in the graph like e.g. frequency or kg and having a category on the x-axis, so that I can build the pareto?

Thanks for your help

PeterWijers
Lapis Lazuli | Level 10

Hi Marcus,

At first my mistake to mix up capability chart with Pareto. Sorry for that. 

A very simple presentation would be to select Bar-Chart and drag fill the category. Now the bar chart will automatically sort in large to small freq order.

This looks like a Pareto but has no cumulative line.

Seems to be you have VA 6.3 installed, I am running on 6.2  (To be updated soon)

Other option would be to use a Bar-Line report and create calculated fields on group level for this.   (I will check later if this also can be done in 6.2

I know that VA 6.3 has new functionality here, but I do not have it available yet.

Thats it for now......waiting on the upgrade to 6.3.

Greetings

Nascif_SAS
SAS Employee

Hi Markus,

From the UI screenshot I can tell you are using the VA Explorer. Peter's suggestion of using a Bar-Line would require you to switch to the VA Designer.

The missing piece to get a Pareto chart is to calculate the cumulative totals. As of the current release, VA can't do this calculation for generic categories; only for dates. This is something we are likely to add in a future version though.

NiranjanaKR
Obsidian | Level 7

For the benefit of new users like me, here is how I created my first Pareto Chart using SASUE Sudio:

 

I have used example given in the book - Statistical Methods for Quality Improvement by Hitoshi Kume. Table 3.2, Page 20.

 

Step1: Created XL file with the following columns: Type of Defects|Number of Defects|Percentage of Defects|Cumulative Percentage

ParetoData_HitoshiKume_Table3.2.PNG

Step 2: Sort the table in ascending order of Number of defects (As shown in the picture)

Step 3: Import the xl to SASUE. From the table select the column names for graph as shown:

As you see, I have chosen, Type_of_Defect| Number_of_Defects|Cumulative_Percentage column names.

 

ParetoTableinSASUE.PNG

Step 4: Go to Tasks and Utilities

Step 5: Select Bar-Line Chart

Step 6: Select Category variable as Type_of_Defect field

Step 7: Select Bar Response variable as Number_of_Defects field

Step 8: Select Line Response variable as Cumulative_Percentage

 

Run the program. With little tweaking of chart options, we get Pareto chart output.

ParetoChart_HitoshiKume_Table3.2.PNG

 

For your use, data file enclosed. 

 

Since I am also a new user of SAS University, I welcome comments, suggestions for improvements from experienced forum members.

 

I will require some help in changing "Number of defects" axis, where I want to show total number of defects. Here is the output from XL chart:

Pareto_InXL_HitoshiKume_Ex3.2.PNG

 

Hope this helps!

 

Kind regards,

Niranjana

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 4489 views
  • 2 likes
  • 4 in conversation