Date:         Mon, 18 Dec 2006 04:32:34 -0800
Reply-To:     "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Organization: http://groups.google.com
Subject:      Re: Merging two files
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="us-ascii"

Dear Rams,

Your in= is invalid. IN= references at variable not a dataset.
It should be somthing like this.

data work.adverse_event;
merge work.ae (in = dataset_ae)  work.treatment (in =
datset_treatment);
by sno;
if dataset_ae and datset_treatment;
run;

Regards,
Mogens A. Krogh
PhD-student, DVM
www.kvl.dk

RAMS skrev:
> Hi all,
>
>
>         I have two data sets called AE and Treatment.  In AE data set I
> have the information about 43 subjects and in Treatment data set I have
> 24 subjects only.
>
> when i Try the Following code
>
> data work.adverse_event;
> merge work.ae (in = work.ae)  work.treatment (in = work.treatment);
> by sno;
> if ae and treatment;
> run;
>
>
> I am getting the error message of "Variable name is not valid".
>
> Anyone please help me to merge these two datasets.
>
> Thanks in advance.
>
>
> Regards,
>
>
> Ramsathish S