Date: Wed, 10 Sep 2003 10:10:26 -0400 Frank Ivis "SAS(r) Discussion" Frank Ivis Re: merge text/plain; charset="iso-8859-1"

For this type of problem, the simplest approach is to use TWO sets, not merge;

data new ; set a ; if _n_ = 1 then set b; run;

Regards,

Frank

-----Original Message----- From: Groeneveld, Jim [mailto:jim.groeneveld@VITATRON.COM] Sent: Wednesday, September 10, 2003 7:35 AM Subject: Re: merge

Hi Fred,

Then this should be your specific solution, but remember, very specific, valid only for one observation in B. If there are more the algorithm must be extended.

DATA A; INPUT X Y; CARDS; 1 2 2 2 3 5 2 4 3 3 ; RUN;

DATA B; Z = 6; RUN;

DATA C; IF _N_ EQ 1 THEN MERGE A B; ELSE SET A (FIRSTOBS=2); RUN;

PROC PRINT DATA=C; RUN;

Regards - Jim.

Y. (Jim) Groeneveld MSc Biostatistician Vitatron B.V. Meander 1051 6825 MJ Arnhem The Netherlands +31/0 26 376 7365; fax 7305 Jim.Groeneveld@Vitatron.com www.vitatron.com

-----Original Message----- From: Frédéric Paillé [mailto:f79redo@yahoo.fr] Sent: Wednesday, September 10, 2003 13:18 To: Groeneveld, Jim Subject: RE: merge

Thank you Jim! It is exactly what I wanted. I'm not a SASer and your help is very precious. Kind regards.

Fred

"Groeneveld, Jim" <jim.groeneveld@vitatron.com> wrote:

Hi Fred,

In _this_specific_case_ a solution can given as:

DATA A; INPUT X Y; CARDS; 1 2 2 2 3 5 2 4 3 3 ; RUN;

DATA B; Z = 6; RUN;

DATA C; IF _N_ EQ 1 THEN MERGE A B; ELSE SET A; RUN;

PROC PRINT DATA=C; RUN;

but if your case changes, the solution has to be adopted.

Regards - Jim.

Y. (Jim) Groeneveld MSc Biostatistician Vitatron B.V. Meander 1051 6825 MJ Arnhem The Netherlands +31/0 26 376 7365; fax 7305 Jim.Groeneveld@Vitatron.com www.vitatron.com

-----Original Message----- From: Fred [mailto:F79redo@YAHOO.FR] Sent: Wednesday, September 10, 2003 11:42 To: SAS-L@LISTSERV.UGA.EDU Subject: merge

Hi,

I have a problem. Could someone help me please?

I have 2 datas like these:

Data A Data B

X | Y Z------ - 1 | 2 6 2 | 2 3 | 5 2 | 4 3 | 3

With a merge, I obtain:

Data C

X | Y | Z ---------- 1 | 2 | 6 2 | 2 | . 3 | 5 | . 2 | 4 | . 3 | 3 | .

But I wish:

X | Y | Z ---------- 1 | 2 | 6 2 | 2 | 6 3 | 5 | 6 2 | 4 | 6 3 | 3 | 6

How can I make it? Thank you.

Frédéric PAILLE

_____

Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Testez le nouveau Yahoo! Mail <http://fr.mail.yahoo.com>

Back to: Top of message | Previous page | Main SAS-L page