topic Re: concatenation in Administration and Deployment

concatenation

pallis — Wed, 18 Sep 2013 14:06:44 GMT

Hi,

I'm having two data files of two months. One is july and august.

Using proc sql I combines these two data sets

select * from

( select depnto,

comm

from emp_aug13)

union all

( select depnto,

comm

from emp_Jun13);

I got output

deptno Comm

10 1000

20 3000

30 1500

10 500

20 190

30 250

Loking for output ,

Aug Jul

deptno Comm deptno Comm

10 1000 10 500

20 3000 20 190

30 1500 30 250

Can any one share me hints to achive this.

regards,

venky

Re: concatenation

Linlin — Wed, 18 Sep 2013 14:14:35 GMT

an example:

data one;

input id var;

cards;

1 20

2 30

3 40

;

data two;

input id var;

cards;

1 200

2 300

3 400

;

proc sql;

select one.*,two.*

from one,two

where one.id=two.id;

quit;

id var id var

1 20 1 200

2 30 2 300

3 40 3 400

Re: concatenation

LinusH — Wed, 18 Sep 2013 14:30:26 GMT

Your desired output looks like a report, not a stored data set.

Take a look at PROC REPORT, potentially PROC TABULATE.

Re: concatenation

Amarnath7 — Wed, 18 Sep 2013 14:56:08 GMT

use 'comm' variable as commAug ,commJun in any in the data. you can not keep two variables on the same name.

Else use proc report

proc sql;

select emp_aug13.*,emp_Jun13.*

from emp_aug13,emp_Jun13

where emp_aug13.depnto=emp_Jun13.depnto;

quit;

deptno commAug commJun

10 1000 500

20 3000 190

30 1500 250

Re: concatenation

pallis — Wed, 18 Sep 2013 15:32:24 GMT

Thank you for the help. I got the output as you suggested me.