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;
@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;
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.
Hi,
i want to use Where and drop clause only for history.adm_2017, no changes in adm_en3 data.
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 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;
Hi, thanks for the advice...it worked.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: