BookmarkSubscribeRSS Feed
0 Likes

Just as there is the option HIDDEN_ROWS.  For those that don't want to just hide a row, but want it to be deleted.

4 Comments
ballardw
Super User

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 ❤️ or similar.

 

 

PhilC
Rhodochrosite | Level 12

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

ballardw
Super User

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.

 

 

PhilC
Rhodochrosite | Level 12

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.