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 (January 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 14 Jan 2008 14:14:35 -0600
Reply-To:   "data _null_," <datanull@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "data _null_," <datanull@GMAIL.COM>
Subject:   Re: How to use macro to merge many dataset
Comments:   To: tammy1207@yahoo.com.tw
In-Reply-To:   <e3ece42f-6cc0-4544-b5ca-c8f5a4c57261@c23g2000hsa.googlegroups.com>
Content-Type:   text/plain; charset=ISO-8859-1

Example: concatenate 500 data sets with exactly the same variables... Use OPEN=DEFER on the set statement.

data _null_; array _n[251:700] (251:700); call symputX('members',cats('work.A',catx(' work.A',of _n[*]))); run; %put NOTE: members=&members;

data &members; do i = 1 to 10; output; end; run; data all; set &members open=defer; run; On Jan 14, 2008 1:26 PM, <tammy1207@yahoo.com.tw> wrote: > I have 500 dataset named from a251 to a750. All of them have exactly > the same variables. How can I merge them into one dataset by using > macro? Thanks. >


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