An Idea Exchange for SAS software and services

Comments
by Super User
‎08-17-2016 06:52 PM - edited ‎08-17-2016 06:53 PM

You should be able to get the effect of "delete_column" but DROPping the variable(s) you don't want in what ever you are doing to create the output. Similarly a Where clause as a dataset option may allow only showing the rows you want or subset the data prior to what ever creates the output.

 

proc (whatever) data=mylib.mydataset (drop= thisvar thatvar where= ( othervar in (<some list of values))) ;

 

or othervar <3 or similar.

 

 

by Regular Contributor
on ‎08-18-2016 03:30 PM

Thanks, BallardW https://communities.sas.com/t5/user/viewprofilepage/user-id/13884 

 

But not good enough for me. You present truly reasonable reasons why I shouldn't need this feature. BUT -- How would you output PROC TABULATE column headers and append them to the top of subsequent PROC PRINT output.  I used the HIDDEN_ROWS option to do this with ODS EXCEL.  Would you know another way I could have structured PROC-TABULATE-like column headers with the option of string ouput as is available in PROC PRINT or REPORT? (I admit I didn't look very hard for another solution)

 

Example

 

Capture.PNG

by Super User
on ‎08-18-2016 04:08 PM

An example to clarify the issue would help if could show the behavior without the desired function and with the desired function. I'm not sure if your example is a before or after and what the exact desired change would be.

 

 

by Regular Contributor
‎08-29-2016 05:33 PM - edited ‎08-29-2016 05:35 PM

Sorry for the delay in responding, I certainly need a better illustration, forgive me, and thanks for responding.

 

So I like the ODS EXCEL option HIDDEN_ROWS because it allows me to hide the rows 6-8 in the output below, so that it is shown as it is in the graphic (my comment above). 

Capture2.PNG

I like HIDDEN_ROWS, but it would be also good if a user could chose to delete these rows; a user may not want their customer or anyone to have access or unhide these rows ever.

Idea Statuses
Top Liked Authors