topic Re: Using Drop conditionally in SAS Programming

Using Drop contionally

BIDD — Thu, 21 Jun 2018 06:08:51 GMT

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;

Re: Using Drop contionally

Patrick — Thu, 21 Jun 2018 06:14:54 GMT

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.

Re: Using Drop contionally

BIDD — Thu, 21 Jun 2018 06:43:32 GMT

Hi,

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

Re: Using Drop contionally

RW9 — Thu, 21 Jun 2018 07:52:31 GMT

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;

Re: Using Drop conditionally

Kurt_Bremser — Thu, 21 Jun 2018 07:53:43 GMT

@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;

Re: Using Drop conditionally

BIDD — Fri, 22 Jun 2018 00:56:13 GMT

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

Re: Using Drop contionally

BIDD — Fri, 22 Jun 2018 00:56:29 GMT

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