topic Re: How to import the dbf file having numeric file name like 102.dbf,103.dbf,etcs at the same time and merge these all.? in SAS Programming

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 — Fri, 19 Dec 2014 11:34:13 GMT

Hi all,

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

Regards,

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

Ksharp — Fri, 19 Dec 2014 11:48:28 GMT

Did you check proc import + dbms=dbf ?

Re: 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 — Fri, 19 Dec 2014 12:24:05 GMT

Hi I have used this code:

%Macor Combinefiles;

%do num = 102 %to 109;

filename avi "C:\Users\&num..dbf";

proc dbf db4=avi out=plots_&num;

run;

%end;

data allplots;

set

%do num = 102 %to 109;

"C:\Users\&num..dbf";

num = 308 %to 311;

plot_&num

%end;

run;

%mend
%Combinefiles

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

Community_Help — Fri, 19 Dec 2014 13:11:22 GMT

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 !

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

ballardw — Fri, 19 Dec 2014 16:34:01 GMT

I would be very tempted to try

filename avi "C:\Users\*.dbf";

if the files you want are the only DBF files in the folder.

Also when using this type of construct

set

%do num = 102 %to 109;

"C:\Users\&num..dbf";

%do num = 308 %to 311; /* assuming the %do got misplaced in pasting*/

plot_&num

%end;

1) Set is not going to accept DBF files. If you want to reference the sets

then make the 102 to 109 loop similar to the 308 to 311

2) you need to close each do loop

3) You want an ; AFTER the last %end to close the SET statememt

set

%do num = 102 %to 109;

plot_&num

%end;

%do num = 308 %to 311;

plot_&num

%end;

; /* this ; closes the Set*/

Re: 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 — Mon, 22 Dec 2014 05:56:33 GMT

Hi I have used this code for upload the all dbf file as well as I wish them to merge in one data set in SAS but I am getting error as:

there are 8 files 102, 103, 104...109 which have file name as number and they are having same format so how I can make data set in sas and merge them in sas itself?

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

Reeza — Mon, 22 Dec 2014 06:29:07 GMT

I'm assuming you mean you've imported all the dbf files?

SAS dataset names cannot start with numbers. I'm also assuming you mean append instead of merge.

So either the names are _102, _103 or perhaps '102'n or '103'n that you can use in your set statement.

Otherwise you'll need to clarify your question.

Re: 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 — Mon, 22 Dec 2014 12:05:35 GMT

My file name are numeric like 102, 103....109..I wish to import them in sas and after importing I wish to append these all database.

Re: 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 — Fri, 26 Dec 2014 06:22:49 GMT

My file name are numeric like 102, 103....109..I wish to import them in sas and after importing I wish to append these all database.

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

Reeza — Fri, 26 Dec 2014 07:02:12 GMT

proc import - RTM.

Re: 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 — Fri, 26 Dec 2014 08:46:44 GMT

hi Reeza,

I have used proc import but the import shows that the file name should not be numeric.

1.Shall we use some command where we can import the entire folder and merged it or

2.Shall we change the name of file where ever the location it is and then import it by sas code?

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

Reeza — Fri, 26 Dec 2014 09:00:06 GMT

The SAS data set cannot start with a number, the file can start with a number.

Add a letter in front of the number:

proc import data=D101 ... Rest of code.

If your having issues, please include your code and log.

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

jakarman — Fri, 26 Dec 2014 09:03:12 GMT

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

Re: 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 — Fri, 26 Dec 2014 11:34:26 GMT

Hi Reeza,

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;

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

Tom — Fri, 26 Dec 2014 14:54:48 GMT

Looks like you have gotten code to run the PROC IMPORT for each file.

To create a combined file there are a couple of choices.

1) You could add a PROC APPEND step into your looping macro. So that after each IMPORT you append the new dataset to the end of the aggregate dataset.

%macro Import_Fctbrd(start,end);

%do i=&start %to &End;

PROC IMPORT OUT=ABC&I

DATAFILE= "&i..dbf"

DBMS=DBF REPLACE;

RUN;

proc append base=combined data=ABC.&I force ;

run;

%end;

%mend Import_Fctbrd;

%Import_Fctbrd(Start=308,End=311);

2) Since your datasets are using a common prefix you could use dataset list in the SET statement of a new data step to combine them.

data combined;

set abc: ;

run;

Re: 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 — Mon, 29 Dec 2014 06:08:35 GMT

Hi Tom,

Actually my file type is dbf so can you please guide for that?

Re: 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 — Mon, 29 Dec 2014 06:09:46 GMT

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;

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

jakarman — Mon, 29 Dec 2014 06:35:00 GMT

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

Re: 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 — Mon, 29 Dec 2014 07:01:32 GMT

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

Re: 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 — Mon, 29 Dec 2014 07:06:24 GMT

Heartily thankful to you...

These code is working fine.