Interested to Buy Any Domain ? << Click Here >> for more details...
i have multiple .csv files in a unix directory.
every file is having variable names as header.even for empty file also.
suppose take 3 files
a.csv
b.csv
c.csv
a.csv contains data as
name;age,salary;
raja;34;4000;
ravi;33;5000;
kumar;25;3000;
b.csv contains data as
name;age,salary;
ajay;40;4500;
and c.csv contains
name;age,salary; (only headers)
Now i want to import and append all these files in to a single dataset.
i tried infile statement with *.csv to import all at a time.
but i m not getting correct data.
please help me . its urgent.
thank you in advance
- 2 Answers
- 4900 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vrana95
/*step 1: create a macro for the destination folder */
%let dirname = C:UsersRANAJIDesktopSAS_Class_CodeMultiple_csv_files;
filename DIRLIST pipe "dir /B &dirname*.csv";
data dirlist ;
length fname $256;
infile dirlist length=reclen;
input fname $varying256. reclen ;
run;
proc print data = dirlist;
run;
/* step 2 , append all the files in one. */
data all_text (drop=fname);
length myfilename $100;
length name $25;
set dirlist;
filepath = "&dirname"||fname;
infile dummy filevar = filepath length=reclen end=done missover;
do while(not done);
myfilename = filepath;
input name $ x1 x2 x3;
output;
end;
run;
proc print data=all_text;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe the function and untility of the most difficult SAS macro that you have written.
Are you involved in writing the inferential analysis plan? Tables specfications?
What is the use of function Proc summary?
how do you pull data from equifax?tell me the process?
what techniques and/or procs do you use for tables? : Sas programming
what is null hypothesis? why do you consider that?
What are the ways to do a “table lookup” in sas?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
What are the features of SAS?
Mention some common errors that are usually committed in sas programming.
what are the types of interactive display types? : Sas-bi
Can you execute a macro within a macro? Describe. : sas-macro
How many data types are there in SAS?
Describe the function and utility of the most difficult SAS macro that you have written?
Where do you use proc means over proc freq?
