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
|