topic How can I hide the OBS column in PROC PRINT? in SAS Programming

How can I hide the OBS column in PROC PRINT?

pmdci — Tue, 18 Dec 2012 19:13:34 GMT

Hello,

I have the following code in SAS Base 9.2:

PROC PRINT DATA = myDataSet;

VAR var1 var2 var3 var4;

WHERE var1 <12 and var11 = 'bad';

RUN;

As a result I get a table with the columns (variables): Obs, var1, var2, var3, var4.

Is there a way for me to hide the Obs column?

Thank you,

Re: How can I hide the OBS column in PROC PRINT?

AncaTilea — Tue, 18 Dec 2012 19:29:18 GMT

HI.

I am not sure there is a way to remove that column.

But you could do something like this, instead:

PROC SQL;

SELECT VAR1, VAR2, VAR3,VAR4

FROM myDataSet

WHERE var1 <12 and var11 = 'bad';

QUIT;

Or, if you want to copy/paste the output from the PROC PRINT, you could do the following:

move the cursor all the way to down-right corner of the output.As you hold down the "Alt" key you can highlight only desired columns from a SAS output - see attached.

Good luck,

Anca.

Re: How can I hide the OBS column in PROC PRINT?

pmdci — Tue, 18 Dec 2012 19:32:10 GMT

Hello,

Thank you for the reply. But I'm afraid that I must hide the Obs column using code, and I am not supposed to be doing a PROC SQL -- it must be a PROC PRINT.

Regards,

Re: How can I hide the OBS column in PROC PRINT?

AncaTilea — Tue, 18 Dec 2012 19:37:31 GMT

You can use "NOOBS"

PROC PRINT DATA = myDataSet NOOBS;

....;

RUN;

Re: How can I hide the OBS column in PROC PRINT?

pmdci — Tue, 18 Dec 2012 19:40:31 GMT

Yep. That's it! Thanks a lot Anca!

Re: How can I hide the OBS column in PROC PRINT?

Sagattiger — Mon, 04 Apr 2016 23:45:33 GMT

Thank you. it worked.