DATA Step, Macro, Functions and more

Merge two datasets

Accepted Solution Solved
Reply
Frequent Contributor
Frequent Contributor
Posts: 81
Accepted Solution

Merge two datasets

Dear all,

 

I'm trying to merge two datasets, but I have some questions about that.

One of the two datasets (have1) includes only one row, like the following:

A       B

3.2    1.2

And the other dataset (have2) has three variables with lots of observations like this:

X   Y   Z

2   3    1

6   3    1

3   3    1

... ...

The final dataset I want to output is:

X   Y   Z   A      B

2   3    1  3.2   1.2

6   3    1  3.2   1.2

3   3    1  3.2   1.2

... ...        3.2   1.2

 

If I use:

data want;

merge have1 have2;

run;

The result I got includes only the first row with the values of A and B, the others are all missing value.

I know I could directly use 

data want;  set have2;

A=3.2;

B=1.2;

run;

However, I'm writing a macro, and there has thousands datasets I want to do so, therefore it's not possible to do this.

 

Hope anyone can help me about this. Thank you!

 

Best,

Hua


Accepted Solutions
Solution
‎11-09-2017 03:35 PM
Super User
Posts: 24,012

Re: Merge two datasets

https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas

 

The first example here is relevant, it shows how to merge in the single row of data.

View solution in original post


All Replies
Solution
‎11-09-2017 03:35 PM
Super User
Posts: 24,012

Re: Merge two datasets

https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas

 

The first example here is relevant, it shows how to merge in the single row of data.

Frequent Contributor
Frequent Contributor
Posts: 81

Re: Merge two datasets

Yes! It is exactly what I want!
Thank you!!!
PROC Star
Posts: 631

Re: Merge two datasets

Hi,

 

SQL Cartesian product solves your problem.

 

Simply: 

proc sql;
create table need as
select * from have2,have1;
quit;

Thanks,
Suryakiran
Frequent Contributor
Frequent Contributor
Posts: 81

Re: Merge two datasets

Posted in reply to SuryaKiran
Right! It also works well! Thank you for your reply and help!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 148 views
  • 2 likes
  • 3 in conversation