Dear A.L.,

Try this *untested* code:

proc sql; select mem_1 into:mymacvar separated by ' ' from data_1; quit; data final; set &mymacvar; run;

Kind regards,

Louis Broekhuijsen - Blöys ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CMG Trade, Transport & Industry B.V. Divisie Systems Development Divisie Information Management (RTIM1) E-mail: Louis.Broekhuijsen-Bloys@CMG.NL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The Information contained in this email and its attachments is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any actions in reliance of the contents of this email and any attachments is strictly prohibited and may be unlawful. CMG is neither liable for the proper and complete transmission of the information contained in this email and any attachments nor for any delay in its receipt. If received in error, please contact CMG on +31 (0)020 50 33 000 quoting the name of the sender and the addressee and then delete it from your system. Please note that CMG does not accept any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). No contracts may be concluded on behalf of CMG by means of email communications.

> -----Original Message----- > From: A. L. [mailto:franz_cl2003@YAHOO.FR] > Sent: dinsdag 27 november 2001 14:16 > To: SAS-L@AKH-WIEN.AC.AT > Subject: Very nice situation !!! > > > Dear all ! > > The very nice situation I am working on at the moment > looks like this. > > I have data_1 having itself a character variable named > mem_1 with this structure: > > Data_1 > > mem_1 > > ddd00001 > dse00005 > fgt54669 > wse25003 > . > . > . > > What I would like to achieve just looks like this: > > DATA final; > SET dd00001 des00005 ftg54669 wse25003; > RUN; > > I would have done it that very simple way if I had > only > those four file names to deal with! > > Thank you all for for help. > Franz. > > > > ___________________________________________________________ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Courrier : http://courrier.yahoo.fr >