topic What is wrong with my merging data set here ? What would be my solution on combing these 2 datasets in New SAS User

What is wrong with my merging data set here ? What would be my solution on combing these 2 datasets

Godzilla_Hat — Wed, 13 Oct 2021 21:00:43 GMT

/*Example 7: Merging datasets*/
Data EmpA;
Input First $ Gender $ EmpID;
datalines;
Togar 	M	121150
Kylie	F	121151
Birin	M	121152
;
Run;
Data EmpB;
Input EmpID Phone $16.;
datalines;
121150	+61(2)5555-1793
121151	+61(2)5555-1849
121152	+61(2)5555-1665
;
run;
proc print data=EmpB;
run;

data EmpAB;
	Merge EmpA EmpB; /*Merge replaces the set for side-by-side combining*/
	by EmpID; /*By statement variable must be within each data set*/
	          /*Usually need to sort by the 
	            same variable in each data set*/
Run;
proc print data=EmpAB;
 run;

This is my output data and I know it is incorrect. What should I change in my code ?

Re: What is wrong with my merging data set here ? What would be my solution on combing these 2 datas

ballardw — Wed, 13 Oct 2021 21:08:34 GMT

@Godzilla_Hat wrote:

/*Example 7: Merging datasets*/
Data EmpA;
Input First $ Gender $ EmpID;
datalines;
Togar 	M	121150
Kylie	F	121151
Birin	M	121152
;
Run;
Data EmpB;
Input EmpID Phone $16.;
datalines;
121150	+61(2)5555-1793
121151	+61(2)5555-1849
121152	+61(2)5555-1665
;
run;
proc print data=EmpB;
run;

data EmpAB;
	Merge EmpA EmpB; /*Merge replaces the set for side-by-side combining*/
	by EmpID; /*By statement variable must be within each data set*/
	          /*Usually need to sort by the 
	            same variable in each data set*/
Run;
proc print data=EmpAB;
 run;

This is my output data and I know it is incorrect. What should I change in my code ?

The code and generated data does not generate the result shown. The result you show means that you forced reading the Empid into the Gender, which typically means the data was read incorrectly, possibly incorrect use of column input instead of list.

Re: What is wrong with my merging data set here ? What would be my solution on combing these 2 datas

Astounding — Wed, 13 Oct 2021 22:55:54 GMT

SAS expects to find blanks between the variables in the DATALINES section.

You used tabs, not blanks.

You can use tabs, but then you would need to add an INFILE statement and an option to tell SAS you are using tabs instead of blanks to delimit your variables. It might be easiest to re-type the data, using spaces in between your variables.

Re: What is wrong with my merging data set here ? What would be my solution on combing these 2 datas

Reeza — Wed, 13 Oct 2021 23:42:09 GMT

Specify the delimiter appropriately, in this case a Tab as mentioned by @Astounding

/*Example 7: Merging datasets*/
Data EmpA;
infile cards dlm='09'x;
Input First $ Gender $ EmpID;
datalines;
Togar 	M	121150
Kylie	F	121151
Birin	M	121152
;
Run;
Data EmpB;
infile cards dlm='09'x;
Input EmpID Phone $16.;
datalines;
121150	+61(2)5555-1793
121151	+61(2)5555-1849
121152	+61(2)5555-1665
;
run;

@Godzilla_Hat wrote:

/*Example 7: Merging datasets*/
Data EmpA;
Input First $ Gender $ EmpID;
datalines;
Togar 	M	121150
Kylie	F	121151
Birin	M	121152
;
Run;
Data EmpB;
Input EmpID Phone $16.;
datalines;
121150	+61(2)5555-1793
121151	+61(2)5555-1849
121152	+61(2)5555-1665
;
run;
proc print data=EmpB;
run;

data EmpAB;
	Merge EmpA EmpB; /*Merge replaces the set for side-by-side combining*/
	by EmpID; /*By statement variable must be within each data set*/
	          /*Usually need to sort by the 
	            same variable in each data set*/
Run;
proc print data=EmpAB;
 run;

This is my output data and I know it is incorrect. What should I change in my code ?

Re: What is wrong with my merging data set here ? What would be my solution on combing these 2 datas

SASKiwi — Thu, 14 Oct 2021 00:01:50 GMT

I seem to recall you had exactly the same problem in another of your posts - tabs between DATALINE fields.

Since you are new to SAS I suggest you avoid using tabs in DATALINEs as they appear to be causing you confusion. The very fact that they are not visible in the SAS editor is the likely cause.