topic Re: Does proc dataset support column level drop/keep functionality in SAS Viya 3.5/4 in SAS Viya

Does proc dataset support column level drop/keep functionality in SAS Viya 3.5/4

thesasuser — Mon, 27 Nov 2023 16:05:52 GMT

Hello
Does proc dataset support column level drop/keep functionality in SAS Viya 3.5/4 or even in SAS 9.4M8

Tom — Mon, 27 Nov 2023 16:33:29 GMT

No. It does not make any sense that it would. If you drop a variable you have a whole new dataset. So just make the new dataset.

sbxkoenk — Mon, 27 Nov 2023 16:40:01 GMT

No!

Data set has to be read and re-written for drop of a column.

You can do:

proc sql; alter table work.abc_xyz drop var_name; quit;
drop= or keep= data set options in data step
create a view on top of existing table leaving out the columns you are not interested in.

Let me know if you are working on CAS tables. For CAS tables there's one more approach.

Koen

thesasuser — Mon, 27 Nov 2023 17:01:58 GMT

Thanks @sbxkoenk
I would appreciate if you can list the other approach for CAS tables.
Thanks once again.

sbxkoenk — Mon, 27 Nov 2023 17:12:21 GMT

@thesasuser wrote:
I would appreciate if you can list the other approach for CAS tables.
Thanks once again.

Koen