Dear SAS-L-ers,

Poohbear posted the following:

> I am on a big project now, there are many .csv files in a > temp folder, and what I have to do are: > > 1. pick those csv files which are not empty, i.e., with at > least 1 observation 2. rename those files with a variable > value in the file, which is an id number 3. save the renamed > files to another folder > > I am totally lost....any help would be highly appreciated! :o) >

Poohbear, well I guess that you can call me Christopher Robin; although colleagues may describe me as more of a Tigger type because of my bouncy walk and energy.

I can offer one tip that may help you become un-lost in the Hundred Acre Woods. Check out my Honorably Mentioned SUGI 29 paper Automatically Process a Varying Number of Data Files in a "Data Directory":

http://www2.sas.com/proceedings/sugi30/035-30.pdf

It should give you some ideas on how you might address looking through the various and sundry data files that you find in your temp folder. You can apply some of the principles used in that paper to your task--though the paper is not an exact fit to the task that you describe.

Poohbear, best of luck to you in finding your way with this task, and keeping your muzzle out of the honey jar!

I hope that this suggestion proves helpful now, and in the future!

Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for illustrative purposes only and no warranty is stated or implied as to their accuracy or applicability. People deciding to use information in this posting do so at their own risk.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael A. Raithel "The man who wrote the book on performance" E-mail: MichaelRaithel@westat.com

Author: Tuning SAS Applications in the MVS Environment

Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=58172

Author: The Complete Guide to SAS Indexes http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=60409

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Tut, tut, looks like rain. - Christopher Robin +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++