topic Re: Data Step merge in SAS Data Science

Data Step merge

RajasekharReddy — Wed, 01 Oct 2014 10:15:48 GMT

hi ,

can any one tell me how we will write below SQL code in data step by using merge

PROC SQL;

CREATE TABLE merge AS

SELECT A.PATIENT,A.DATE , A.PULSE,

B.PATIENT, B.DOSES, B.AMT FROM VITALS as A , DOSING as B

where A.PATIENT=B.PATIENT and B.AMT ne " ";

quit;

RW9 — Wed, 01 Oct 2014 10:26:41 GMT

data want;

merge vitals (in=a) dosing (in=b where=(amt ne ""));

by ...;

if a and b then output;

run;

RajasekharReddy — Wed, 01 Oct 2014 10:30:12 GMT

thanks for providing code for same however small change in code and tell me how we can aply condtion in both data sets as

data want;

merge vitals (in=a where=(

A.pulse eq 'y') dosing (in=b where=(amt ne ""));

by ...;

if a and b then output;

run;

PROC SQL;

CREATE TABLE merge AS

SELECT A.PATIENT,A.DATE , A.PULSE,

B.PATIENT, B.DOSES, B.AMT FROM VITALS as A , DOSING as B

where A.PATIENT=B.PATIENT and A.pulse eq 'Y' and B.AMT ne " ";

quit;

Loko — Wed, 01 Oct 2014 10:34:21 GMT

helo,

/*prepare some data*/

data classwork;
set sashelp.class(where=(sex="M"));
if mod(_N_,2)=0 then call missing(height);
run;

/*output*/
data want;
merge sashelp.class (in=a) classwork (in=b);
by name;
if a and b and height ne .;
run;

husseinmazaar — Wed, 01 Oct 2014 14:44:14 GMT

data want;

merge vitals (in=a) dosing (in=b);

by PATIENT;

if a and b;

where amt ne ' ';

run;

thanks