I hope that Brian's actual application is brimming with logic: I find very little in the sample data.

This is not difficult to do, not necessarily with MERGE. I'd use SET ... POINT=, something like (tested):

data three; set two; ptr + 1; if ptr > nn then ptr = 1; set one point = ptr nobs = nn; run;

That this should be useful to someone ...

Prosit, Puddin'

******************************************************* ***** Puddin' Man **** Pudding_Man-at-mail.com ******** *******************************************************;

A few words re "The Common Ground":

"You may have some great army at your command. You may have some politicians who'll eat out of your hand. You may have your servants who'll do anything you say. But Mother Earth is waiting, thats the debt you gotta pay.

Don't care how great you are, don't care how much you're worth. When it all comes down you got to go back to Mother Earth."

-from "Mother Earth", Memphis Slim, maybe 1952.

On 21 May 2004 14:44:29 -0700, in comp.soft-sys.sas you wrote:

>Hello, I am new to SAS. I need help with SAS merge below. Any help >is greatly appreciated. > > >DATA ONE; >INPUT MKTCELL; >CARDS; >001 >002 >003 >004 >005 >; >RUN; >/**************************************/ >DATA TWO; >INPUT APPS $3; >CARDS; >AA >AB >AC >AD >BA >BB >BC >BD >CA >CB >CC >CD >; >RUN; > >/**********************************************/ > >EXPECTED OUTPUT THAT THE FIRST DATA SET IS MERGED WITH THE DATA SET >TWO, AND THE NUMBER RECORDS SHOULD BE EQUAL TO THE NUMBER OF RECORDS >IN DATA SET TWO; > > > >AA 001 >AB 002 >AC 003 >AD 004 >BA 005 >BB 001 >BC 002 >BD 003 >CA 004 >CB 005 >CC 001 >CD 002 > > >Thanks, > >Brian Vuong

-- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm