how to delete row and column from the output

Accepted Solution Solved
Reply
Super Contributor
Posts: 297
Accepted Solution

how to delete row and column from the output

How do I delete the rows and column that are in yellow bolow. I want table 1 to look like table 2 below.

proc means data=para noprint; class Variable; var estimate; output out=two mean(estimate)=col1

std(estimate)=col2 mean(StdErr)=col3;

run;

Table 1


ObsVariable_TYPE__FREQ_col1col2col3
10405.910333.422360.92869
2Intercept1202.614950.085030.13475
3TIMES1209.205711.082661.72264



Table 2

ObsVariable_  FREQ_    col1col2         col3
2Intercept202.614950.085030.13475
3TIMES209.205711.082661.72264

Accepted Solutions
Solution
‎02-10-2013 09:41 PM
Super User
Super User
Posts: 6,498

Re: how to delete row and column from the output

You can prevent PROC MEANS from generating the _TYPE_=0 row by adding the NWAY option.

You could drop the _TYPE_ column by using dsoption on output data set.

proc means nway data=para noprint;

  class Variable;

  var estimate;

  output out=two (drop=_type_)

        mean(estimate)=col1

        std(estimate)=col2

        mean(StdErr)=col3

  ;

run;

View solution in original post


All Replies
Solution
‎02-10-2013 09:41 PM
Super User
Super User
Posts: 6,498

Re: how to delete row and column from the output

You can prevent PROC MEANS from generating the _TYPE_=0 row by adding the NWAY option.

You could drop the _TYPE_ column by using dsoption on output data set.

proc means nway data=para noprint;

  class Variable;

  var estimate;

  output out=two (drop=_type_)

        mean(estimate)=col1

        std(estimate)=col2

        mean(StdErr)=col3

  ;

run;

Super Contributor
Posts: 297

Re: how to delete row and column from the output

Thanks a lot Tom

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 234 views
  • 0 likes
  • 2 in conversation