merging two datasets

swayto — Mon, 03 Jun 2019 19:14:45 GMT

I took a practice exam and question was a variable name in datasets employee is $char 10 format and a variable name in datasets sales has $char 15 format .

data both;

length name $ 20;

merge sales employee;

by id;

run;

Question What is the format for the variable name in the dataset both? I ran a number of dataset and the answer is $20 instead of $15.

Re: merging two datasets

tsap — Mon, 03 Jun 2019 19:52:52 GMT

You're confusing length and format.

The question is "What is the format for the variable name in the dataset both?"

$20 is the Length.

Neither datasets have a "Format" of $20.

The two options are

Dataset Variable Format

Employee name $10.

Sales name $15.

So in the merge, the first table read in is the 'Sales' table where the variable 'name' is formatted $15. so the new table has the variable 'name' formatted as $15.

Hope this helps.

topic Re: merging two datasets in New SAS User

merging two datasets

Re: merging two datasets