topic Re: MERGING DO LOOP in SAS Programming

MERGING DO LOOP

anitapamu2 — Thu, 15 Oct 2015 09:34:24 GMT

Data one; input var1 $;

datalines;

scan

MRI

;run;

Data two; input res1 res2;

datalines;

; run;

OUTPUT: IN ONE DATASET

Var1 res1 res2

scan 10 45

scan 13 56

MRI 10 45

MRI 13 56

Patrick — Thu, 15 Oct 2015 09:27:51 GMT

Please provide valid and tested SAS syntax creating DATA ONE and DATA TWO.

Untested (as I didn't feel like fixing the data steps)

proc sql;
  create table want as
  select *
  from one,two
  ;
quit;

anitapamu2 — Thu, 15 Oct 2015 09:55:55 GMT

Hereafter It will not repeat and Thank you!

Can you please help out In Data Step Method ...for the same Problem

Astounding — Thu, 15 Oct 2015 11:22:58 GMT

The SQL solution already posted is easier, but for a DATA step:

data want;

set one;

do _n_=1 to _nobs_;

set two point=_n_ nobs=_nobs_;

output;

end;

run;