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;
Heartily thankful to you...
These code is working fine.
Please mark question as answered.
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 !
as you are using DBF files. Why not use proc dbf? SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Third Edition
use proc dbf it is named as proc dbf because the designed for dbf
Thanks each one of you for your help .I am able to upload file.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.