topic Re: Dropping a variable from a SAS dataset in SAS Programming

Dropping a variable from a SAS dataset

JohnSAScom — Wed, 11 Jul 2018 18:34:46 GMT

How do I drop a variable from a SAS dataset?

Re: Dropping a variable from a SAS dataset

Kurt_Bremser — Wed, 11 Jul 2018 18:46:02 GMT

Use the drop statement or the drop dataset option. Documentation can be found by searching for "sas drop variable" on google.

Re: Dropping a variable from a SAS dataset

SuryaKiran — Wed, 11 Jul 2018 18:49:42 GMT

There are several way and depends on how you want it. You can use DROP= if you have only few variables to drop or KEEP= if there are more variables to drop and only few to keep.

Here are some way:

/* Reads from the input, but doesn't output */
data class (drop=Name);
set sashelp.class;
run;

/* Doesn't read from the input, so it will not be in output */
data class ;
set sashelp.class(drop=Name);
run;

/* You can also use drop in Proc SQL */
proc sql;
create table class(drop=Name) as
select *
	from sashelp.class;
quit;
/* Similar to above */
proc sql;
create table class as
select Sex,Age,Height,Weight /* Name variable is dropped */
	from sashelp.class;
quit;

/* You Can also alter table */
proc sql;
create table class as
select *
	from sashelp.class;
quit;
proc sql;
alter table work.class
drop name;
quit;

Re: Dropping a variable from a SAS dataset

JohnSAScom — Wed, 11 Jul 2018 19:16:12 GMT

Thanks Kurt.

Re: Dropping a variable from a SAS dataset

JohnSAScom — Wed, 11 Jul 2018 19:17:08 GMT

Thanks Surya.