topic Merging Variables in New SAS User

Merging Variables

olivia123456 — Wed, 27 Mar 2019 19:48:39 GMT

The following data set information contains five variables name, sex, race, weight, and iq,

Using data set informationto create a SAS data set biothat contains three variables, name, sex, and race.
Using data set informationto create SAS data set personalthat contains name, weightand iq.
Given bioand personaldata sets, create the data set fullwith five variables.

Eric m White 130 60

Mary f African American 110 130

Lou m Asian 140 110

Frank m White 160 150

Jen f White 120 125

Re: Merging Variables

Reeza — Wed, 27 Mar 2019 19:59:49 GMT

Use the KEEP and DROP data set options.

http://support.sas.com/documentation/cdl/en/ledsoptsref/69751/HTML/default/viewer.htm#p0vw9lyyxk1cxkn0zzfemrsr3t9a.htm

For the last one you'll need a MERGE statement.

https://video.sas.com/detail/video/4572997800001/merging-sas-tables-in-a-data-step?autoStart=true&q=merge

Give these a shot and if you need further help please post the code and an explanation of what's not working.

@olivia123456 wrote:

The following data set information contains five variables name, sex, race, weight, and iq,

Using data set informationto create a SAS data set biothat contains three variables, name, sex, and race.

Using data set informationto create SAS data set personalthat contains name, weightand iq.

Given bioand personaldata sets, create the data set fullwith five variables.

Eric    m White   130 60

Mary   f   African American    110 130

Lou     m  Asian 140 110

Frank  m  White   160 150

Jen     f   White 120 125

Re: Merging Variables

andreas_lds — Wed, 27 Mar 2019 21:18:31 GMT

Interesting homework.

So you need one data step to create the datasets "bio" and "personal" and a second step to merge them to create "full". And to control which variables are written to each dataset, you will need one of the keywords already mentioned by @Reeza