How to import the dbf file having numeric file name like 102.dbf,103.dbf,etcs at the same time and merge these all.?

[rajendramehta03]

I have used below mention code where am trying to creat sas database for the file having numeric value at below mention folder an dappend them.Please guide me.:

  %LET Path1 = C:\Users\MehtRa06\Desktop\My SAS Training\UU\Input_Files\FCTBRD Files; *Path
of File;

  %LET Start=308;

  %Let End=311;                   /*Put Start and End File name*/

Optionsmprint mlogic;

  %MACRO
IMPORT_DBF (X);

  PROC IMPORT OUT=WORK.ABC&X

  DATAFILE= "&Path1.\&X..csv"

DBMS=DBFREPLACE;

  GETNAMES=YES;

  DATAROW=2;

  GUESSINGROWS=150000;

  RUN;

  %MEND;

  %macro
Import_Fctbrd;

  %Do
i=&start %to &End;

  %IMPORT_DBF(&i);

  %end;

  %mend;

  %Import_Fctbrd;

[rajendramehta03]

Heartily thankful to you...

These code is working fine.

[Reeza]

Please mark question as answered.

[Community_Help]

Hi there - looks like you posted your question in the "About Communities" section of the site.

Just so that others who are interested in your subject can have more visibility to your message, I am moving this message into the Macro community. The URL of the message will stay the same.  Thanks for posting a question to Communities on SAS and Welcome !

[jakarman]

as you are using DBF files.   Why not use proc dbf? SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Third Edition

[jakarman]

use proc dbf     it is named as proc dbf because the designed for dbf

[rajendramehta03]

Thanks each one of you for your help .I am able to upload file.