topic Re: Removing blanks when opening files in SAS Programming

Removing blanks when opening files

a_zacMD — Tue, 01 Dec 2020 16:30:03 GMT

Hi there, I am using SAS Enterprise Guide.

I am aware there are ways to keep or drop variables when opening new files. For example:

data input_data_current;

set data_file (drop=var1 var2 var3);

run;

And I am aware that I can remove rows with missing IDs but can I remove those rows that are missing IDs when I initially open the file?

Re: Removing blanks when opening files

ballardw — Tue, 01 Dec 2020 16:50:06 GMT

Are you looking for something like this?

data want;
   set data_file ; 
   where not missing(id);
run;

Not quite sure what "initially open the file" actually means in your context.

Most procedures will honor the where statement as well and the few that might not would honor a data set option so you may not need to create a new data set.

Proc print data=somedatesetname;
   where not missing(id);
run;

/* or data set option*/
Proc print data=somedatasetname (where=( not missing(id)));
run;

Re: Removing blanks when opening files

PaigeMiller — Tue, 01 Dec 2020 16:48:09 GMT

data input_data_current;
    set data_file (where = (not missing(id))); 
run;

Re: Removing blanks when opening files

Reeza — Tue, 01 Dec 2020 16:50:31 GMT

You can use a WHERE statement or data set option to filter your data. A WHERE statement or the data set option filters can be used in almost every proc in SAS.

Data set option:

data input_data_current;
set data_file(drop = var1 var2 var3 where=(not missing(ID)));
run;

WHERE statement

data input_data_current;
set data_file(drop = var1 var2 var3);

where not missing(ID);
run;

Just a quick comment on terminology "Opening files" could be interpreted in several different ways so it's a very ambiguous term.

@a_zacMD wrote:

Hi there, I am using SAS Enterprise Guide.

I am aware there are ways to keep or drop variables when opening new files. For example:

data input_data_current;

set data_file (drop=var1 var2 var3);

run;

And I am aware that I can remove rows with missing IDs but can I remove those rows that are missing IDs when I initially open the file?