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

[ybz12003]

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;

[Reeza · Accepted solution]

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;

---