Heartily thankful to you... These code is working fine. ... View more

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

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; ... View more

Hi Tom, Actually my file type is dbf so can you please guide for that? ... View more

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; ... View more

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? ... View more

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. ... View more

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. ... View more

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? ... View more

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_# run; %end; data allplots; set %do num = 102 %to 109; "C:\Users\&num..dbf"; num = 308 %to 311; plot_&num %end; run; %mend %Combinefiles ... View more