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 (May 2006, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 8 May 2006 07:07:44 -0400
Reply-To:     Eric Hoogenboom <erichoogenboom@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Eric Hoogenboom <erichoogenboom@YAHOO.COM>
Subject:      Re: Importing several external files

Flo,

I can think of three options. Quick and dirty (1): check if your raw data contains the var name, if so then skip it.

filename FN "D:\0317.??.csv";

data TEST (drop=first3); infile FN delimiter = ";" dsd; input first3 $ 1-2 @@; if first3 = 'v1' then input; else do; input @1 v1-v3; output; end; run;

2. Change the filename to a filevar solution (See doc). Is not as flexible as using the question marks.

3. Google for an earlier post by Harry Droogendyk of September 26 last year, see http://groups.google.com/group/comp.soft- sys.sas/browse_thread/thread/2997bb043db8e9a4/42c6f17d3fb0f422? q=concatenate+each+filename+infile&rnum=3#42c6f17d3fb0f422 where he uses the filename= option.

Hth, Eric


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