topic How can I hide the column in using the DATA step in SAS Programming

How can I hide the column in using the DATA step

Pups — Tue, 28 May 2019 18:43:44 GMT

Below is my code. I want to hide only those columns ( more then 20) after I have imported the file in the SAS format.

DATA work1.AAA_import;

SET work.AAA_import;

drop orgID org_name surveyID

RUN;

I wrote this code . is there any other way to hide the larger number of column.

thank you

Re: How can I hide the column in using the DATA step

PeterClemmensen — Tue, 28 May 2019 19:01:21 GMT

Does your code work? And if not, what does the log say?

Re: How can I hide the column in using the DATA step

PaigeMiller — Tue, 28 May 2019 19:17:43 GMT

What do you mean by "hide"? Do you mean eliminate the column so it is no longer in the data set, or somehow set things up so the column remains in the data set but isn't displayed. How do you want to view this data set with hidden columns (what specific method in SAS are you going to use to view the data set with hidden columns?)

If you just want the column to not appear when you look at the data set, you can create a view of the data set in PROC SQL which only will show specific columns that you select, and will not show other columns (even though those other columns are still in the data set).

Re: How can I hide the column in using the DATA step

Reeza — Tue, 28 May 2019 19:25:34 GMT

SAS does not have a concept of 'hiding' columns.

You can drop a column, but that removes it from the table entirely.

Also, this type of coding is problematic because now your original table is destroyed and to re-create it you have to re-import your data.

Don't use the same name in your DATA and SET statement unless your code is fully functioning and tested and you need to reduce space for some reason.

DATA work1.AAA_import;

SET work.AAA_import;

@Pups wrote:

Below is my code. I want to hide only those columns ( more then 20) after I have imported the file in the SAS format.

DATA work1.AAA_import;

SET work.AAA_import;

drop orgID org_name surveyID

RUN;

I wrote this code . is there any other way to hide the larger number of column.

thank you

Re: How can I hide the column in using the DATA step

anushreebiotech — Tue, 28 May 2019 19:46:55 GMT

Hi,

If you don't want to use these columns anywhere in your new data set, then you use drop= option in the set statement.

DATA work1.AAA_import;

SET work.AAA_import (drop= orgID org_name surveyID);

run;

Regards,

Anushree

Re: How can I hide the column in using the DATA step

heffo — Wed, 29 May 2019 00:55:24 GMT

As other has told you, hiding doesn't really exist as a concept in this case. But if you want to remove many variables at once there are some tricks.

*Remove all variables between (and including) the variables named below;
data x;
	set sashelp.baseball;
	drop nAtBat--CrBB;
run;

*Remove all variables starting with cr. We can use the : as a wildcard, but only "ending with".;
data x;
	set sashelp.baseball;
	drop cr: ;
run;

*Remove all variables of one type. ;
data z;
	set sashelp.baseball;
	drop _char_ ; * or use _numeric_ ;
run;