Using Drop contionally

[BIDD]

Hello All,

I want to combine 2 data sets as below and i am not sure how to use both where and Drop functions together for data set history.adm_ytd_pivot_2017.

It would be great help if you can assist me with this.

data adm_en4;
set adm_en3 history.adm_2017(where=( commence_year = '2017'));
run;

[Patrick]

If you want the where clause applied to all source data sets then you can write your code as below:

data adm_en4;
  set adm_en3 history.adm_2017;
  where commence_year = '2017';
run;

The way you've done it will only apply the where clause for the data set which goes with the where clause.

[BIDD]

Hi,

i want to use Where  and drop clause only for history.adm_2017, no changes in adm_en3 data.

[RW9]

Then put them on the set part as you have done:

data adm_en4;
  set adm_en3 history.adm_2017(where=( commence_year = '2017') drop=...);
run;

[BIDD]

Hi, thanks for the advice...it worked.

[Kurt_Bremser · Accepted solution]

---

@BIDD wrote:

Hello All,

I want to combine 2 data sets as below and i am not sure how to use both where and Drop functions together for data set history.adm_ytd_pivot_2017.

It would be great help if you can assist me with this.

data adm_en4;
set adm_en3 history.adm_2017(where=( commence_year = '2017'));
run;

---

Just add the drop dataset options:

data adm_en4;
set
  adm_en3
  history.adm_2017 (
    drop=variables you want to drop
    where=(commence_year = '2017')
  )
;
run;

[BIDD]

Hi, thanks for the advice...it worked.