LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2001, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 27 Nov 2001 07:39:02 -0600
Reply-To:   greg.woolridge@TAP.COM
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Greg Woolridge <greg.woolridge@TAP.COM>
Subject:   Re: Very nice situation !!!
Comments:   To: "A. L." <franz_cl2003@YAHOO.FR>
Content-type:   text/plain; charset=iso-8859-1

There may be a more elegant solution, but I think this will work for you.

/* determine number of data sets*/ data _null_; if 0 then set data_1 nobs=numobs; call symput('numobs',compress(put(numobs,best.))); stop; run;

/*create macro variables for use later*/ data _null_; set temp2; I+1; call symput('ds'||compress(put(I,best.)),mem_1); run;

/*macro to use in data step*/ %macro setit; %do a=1 %to &numobs; &&ds&a %end; %mend setit;

/*the data step that combines all*/ data final; set %setit; run;

Greg M. Woolridge Manager, Study Programming TAP Pharmaceutical Products Inc. e-mail: greg.woolridge@tap.com phone: 847-582-2332 fax: 847-582-2403

"A. L." <franz_cl2003@ To: SAS-L@LISTSERV.UGA.EDU YAHOO.FR> cc: Sent by: Subject: Very nice situation !!! "SAS(r) Discussion" <SAS-L@LISTSER V.UGA.EDU>

11/27/01 07:16 AM Please respond to "A. L."

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


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