topic Displaying data side by side ??? in New SAS User

Displaying data side by side ???

Harish2 — Tue, 28 May 2019 09:56:41 GMT

Hi team,

I have two tables

table A
sl no	Name
1	HARISH
2	GIRISH
4	RAMYA
5	RAMU
6	RAVI

table B
sl No	working
3	tcs
5	tcs
2	cts
1	hp
4	wipro
5	ge
7	NA

Need the output will be like below by using SAS code.Please help me to do this.

New Table
sl no	Name	sl No	working
1	HARISH	3	tcs
2	GIRISH	5	tcs
4	RAMYA	2	cts
5	RAMU	1	hp
6	RAVI	4	wipro
		5	ge
		7	NA

Thanks,

harish

Re: Displaying data side by side ???

PeterClemmensen — Tue, 28 May 2019 10:27:15 GMT

Remember, two variables can not have the same name.

Do something like this

data tableA;
input slno	Name $;
datalines;
1	HARISH
2	GIRISH
4	RAMYA
5	RAMU
6	RAVI
;

data tableB;
input slNo working $;
datalines;
3	tcs
5	tcs
2	cts
1	hp
4	wipro
5	ge
7	NA
;

data want;
   merge tableA tableB(rename=(slNo=slNo_B));
run;

Re: Displaying data side by side ???

Harish2 — Wed, 29 May 2019 06:14:20 GMT

Thanks for your help.