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-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!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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