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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.