BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jeka1212
Obsidian | Level 7

Hi all,

 

I am having problem in combining two tables with different no. of columns.

compare_y1y1dbeta
11111100
1115000
11117201
1113700
11163901
1112000

 

 

compare_y2y2d1beta1
818100
8124001
8183101
8125601
8189001
815770

1

 

Now if I type command:

 

data table3;
                 set tabel1 table2;
                 run;

 

 I dont have the table3 I want.

 

Any help i can have table3 like this?

 

compare_y1y1dbetacompare_y2y2d1beta1
11111100818100
11150008124001
111172018183101
11137008125601
111639018189001
11120008157701

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
novinosrin
Tourmaline | Level 20

Are you looking for one to one merge?

 

data want;

set table1;

set table2;

run;

or

 

data want;

merge table1 table2;

run;

View solution in original post

2 REPLIES 2
novinosrin
Tourmaline | Level 20

Are you looking for one to one merge?

 

data want;

set table1;

set table2;

run;

or

 

data want;

merge table1 table2;

run;

jeka1212
Obsidian | Level 7
Many thanks Proc Star. Much appreciated

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 343 views
  • 0 likes
  • 2 in conversation