topic Re: subset in data step in SAS Programming

subset in data step

YW_CA — Tue, 25 Jun 2013 18:53:38 GMT

hi, I have dataset, for example like this:

data NAME1;

infile datalines delimiter=",';

input name $ gender $ age;

datalines;

AB,F,1

CD,M,2

XX,F,2

OO,M,3.5

PP,F,2

AC,F,2

;

RUN;

I have a prompt value (NAMA_SELECTED) which user enter names. So if user enter ALL, all or leave it blank, I want to export all the records to the dataset SELECTED_PEOPLE. If user enter AB and/or CD only, these two records should be exported to SELECTED_PEOPLE dataset.

I use %_eg_whereParam for subsetting when user enter AB. and/or CD, not problem. But when it come to check if the prompt value is ALL, or all or blank, it just cannot output everything. I am using if "&NAMA_SELECTED" = 'ALL' or "&NAMA_SELECTED" = 'all' or "&NAMA_SELECTED" = ' ' then do; output;end;

What's wrong this logic?

Re: subset in data step

Reeza — Tue, 25 Jun 2013 18:55:22 GMT

Post your full code.

Re: subset in data step

YW_CA — Tue, 25 Jun 2013 20:26:55 GMT

here is step for subsetting:

data selected_names;

set NAME1;

if "&NAME_SELECTED" = 'ALL' or "&NAME_SELECTED" = 'all' or "&NAME_SELECTED" = ' ' then do;

output;

end;

else do;

where %_eg_whereParam(name, NAME_SELECTED,IN,TYPE=S);

end;

run;

Re: subset in data step

ballardw — Tue, 25 Jun 2013 21:32:27 GMT

Slight improvement but depending on people may be usefule:

if upcase("&NAME_SELECTED") = 'ALL'

will handle ALL, All, aLL, alL, all and others.

Re: subset in data step

YW_CA — Tue, 25 Jun 2013 23:31:31 GMT

does not work. From the log, the step took the if as where and did the where NAME = 'ALL' logic, which is similar to what I've seen before.

Re: subset in data step

YW_CA — Tue, 25 Jun 2013 23:37:12 GMT

interesting, if I comment out the else do logic. just leave the first if end in the datastep. it export all the records.

data selected_names;

set NAME1;

if "&NAME_SELECTED" = 'ALL' or "&NAME_SELECTED" = 'all' or "&NAME_SELECTED" = ' ' then do;

output;

end;

else do; /*

where %_eg_whereParam(name, NAME_SELECTED,IN,TYPE=S);

OUTPUT;*/

end;

run;

Re: subset in data step

Tom — Wed, 26 Jun 2013 00:07:23 GMT

WHERE statement is applied before the data is read into the data step. Placing it inside of a conditional does not change this.

Use IF statement instead if you want to apply the filter conditionally.

Re: subset in data step

Vladislaff — Wed, 26 Jun 2013 08:54:25 GMT

%macro filter;

data selected_names;

set NAME1;

%if %upcase(&NAME_SELECTED) ^= ALL and &NAME_SELECTED ne %then %do;

where %_eg_whereParam(name, NAME_SELECTED,IN,TYPE=S);

%end;

run;

%mend;

%filter;

Re: subset in data step

deleted_user — Wed, 26 Jun 2013 09:08:33 GMT

Use If and else if instead of else and where