Remove _TYPE_ and _FREQ_ columns in the Proc summary output dataset?

ybz12003 — Thu, 25 Aug 2022 20:37:23 GMT

Hello,

There are _TYPE_ and _FREQ_ columns shown in the Proc summary output dataset. How to remove them? Do I have do it in the next data step?

Proc summary data=Have nway;
   class id;
   var Line_Total_Charge;
   output out=Want sum=;
   format class class.;
run;

Re: Remove _TYPE_ and _FREQ_ columns in the Proc summary output dataset?

Reeza — Thu, 25 Aug 2022 20:50:57 GMT

Use data set options to drop the variables in the OUTPUT statement.

 output out=Want (DROP= <list of variables>) sum=;

@ybz12003 wrote:

Hello,

There are _TYPE_ and _FREQ_ columns shown in the Proc summary output dataset. How to remove them? Do I have do it in the next data step?
Proc summary data=Have nway;
   class id;
   var Line_Total_Charge;
   output out=Want sum=;
   format class class.;
run;

topic Re: Remove _TYPE_ and _FREQ_ columns in the Proc summary output dataset? in SAS Programming

Remove _TYPE_ and _FREQ_ columns in the Proc summary output dataset?

Re: Remove _TYPE_ and _FREQ_ columns in the Proc summary output dataset?