Remove certain breakdowns from proc tabulate

Reply
N/A
Posts: 1

Remove certain breakdowns from proc tabulate

Hi I'm creating a table with multiple columns, but some of the columns I do not want to keep under certain nested columns.

table.bmp

So in the table I want to keep everything in green and remove everything in red (the amber showing the variables that are partially right/wrong).

So how can I get those removed?

This is my code that produces the table above

proc tabulate data=mytable missing noseps;

  class open_date2 area report_segment cleared cleared_within_sla;

  table open_date2=''*area='',

        report_segment=''*(all cleared='')*((cleared_within_sla='' all)*(n='Vol'*f=8. reppctn='%'));

  format open_date2 monyy.;

  keylabel n=" ";

run;

Any help or advice much appreciated.  I'm using SAS 9.1.

Regards,

Jim

Super User
Posts: 9,681

Re: Remove certain breakdowns from proc tabulate

I think it is hard for proc tablulate, but you can try proc report.

Xia Keshan

Super User
Super User
Posts: 7,401

Re: Remove certain breakdowns from proc tabulate

Hi,

Use the out= options to store the output from your proc tabulate.  Drop rows you don't want, then proc report the remaining dataset.

Ask a Question
Discussion stats
  • 2 replies
  • 193 views
  • 0 likes
  • 3 in conversation