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.
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.
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.
You can use "NOOBS"
PROC PRINT DATA = myDataSet NOOBS;
....;
RUN;
Yep. That's it! Thanks a lot Anca!
Thank you. it worked.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.