topic Re: how to delete row and column from the output in SAS Programming

how to delete row and column from the output

desireatem — Mon, 11 Feb 2013 02:31:16 GMT

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

Table 2

Tom — Mon, 11 Feb 2013 02:41:48 GMT

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 — Mon, 11 Feb 2013 02:49:09 GMT

Thanks a lot Tom