How can I hide the OBS column in PROC PRINT?

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

How can I hide the OBS column in PROC PRINT?

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,

P.


Accepted Solutions
Solution
‎12-18-2012 02:37 PM
Super Contributor
Posts: 543

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

Smiley Happy

You can use "NOOBS"

PROC PRINT DATA = myDataSet NOOBS;

....;

RUN;

Smiley Happy

View solution in original post


All Replies
Super Contributor
Posts: 543

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

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.

Attachment
Contributor
Posts: 41

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

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,

P.

Solution
‎12-18-2012 02:37 PM
Super Contributor
Posts: 543

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

Smiley Happy

You can use "NOOBS"

PROC PRINT DATA = myDataSet NOOBS;

....;

RUN;

Smiley Happy

Contributor
Posts: 41

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

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

Regular Learner
Posts: 1

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

Thank you. it worked.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 3631 views
  • 2 likes
  • 3 in conversation