topic Re: Needed one output for ds in SAS Programming

Needed one output for ds

goverdhan39 — Sun, 29 Jul 2018 12:21:49 GMT

I have 2 datasets with data
Ds1
1
2
3
Ds2
4
5
6

And I want output like below :
1
4
2
5
3
6

Can anyone help me out for this problem

Re: Needed one output for ds

PeterClemmensen — Sun, 29 Jul 2018 12:33:03 GMT

Assuming the variables have the same name (In this example x)

data ds1;
input x @@;
datalines;
1 2 3
;

data ds2;
input x @@;
datalines;
4 5 6
;

data want;
   set ds1 ds2;
run;

Re: Needed one output for ds

goverdhan39 — Sun, 29 Jul 2018 12:42:32 GMT

Hi

But for your sol the output will be like

1
2
3
4
5
6

But I need the output like below
1
4
2
5
3
6

Which is taking first observation from Ds1 and first observation from Ds2 like that it follows

Re: Needed one output for ds

PeterClemmensen — Sun, 29 Jul 2018 12:55:58 GMT

Ah ok. Do like this instead.

data ds1;
input x @@;
datalines;
1 2 3
;

data ds2;
input x @@;
datalines;
4 5 6
;

data want;
   do i=1 to max(nobs1,nobs2);
      set ds1 nobs=nobs1 point=i; output;
      set ds2 nobs=nobs2 point=i; output;
   end;
   stop;
run;

Re: Needed one output for ds

goverdhan39 — Sun, 29 Jul 2018 13:02:59 GMT

thanks dude

Re: Needed one output for ds

PeterClemmensen — Sun, 29 Jul 2018 13:35:17 GMT

Anytime 🙂

Re: Needed one output for ds

novinosrin — Sun, 29 Jul 2018 20:22:47 GMT

data ds1;
input x @@;
datalines;
1 2 3
;

data ds2;
input x @@;
datalines;
4 5 6
;

data want(keep=x);
set ds1; set ds2(rename=(x=x1));
output;
x=x1;
output;
run;