BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
desireatem
Pyrite | Level 9

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
1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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

2 REPLIES 2
Tom
Super User Tom
Super User

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;

desireatem
Pyrite | Level 9

Thanks a lot Tom

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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