thank you ... View more

Hi AnaV, As I know Till Now SAS didn't develop a technique to import several CSV files at once. but, you can use macro program to do that i.e. %Macro ReadCSV (infile , outfile ); PROC IMPORT OUT= &ofile             DATAFILE= &infile             DBMS=CSV REPLACE;      GETNAMES=YES;      DATAROW=2; RUN; %Mend ReadCSV; %ReadCSV("F:\SAS Institutional Ownership\46_q1_2000.csv", work.ofile1); %ReadCSV( "F:\SAS Institutional Ownership\45_q2_2000.csv", work.ofile); and so on for other files also there is other advanced technique for reading all files from one folder at once - using macros also. good luck ... View more

Thank you LinusH, you are right I know Mr. Mohamed Environment that's why I said that he can use DI Studio. ... View more

Yes, DI  can send emails. ... View more

as I see usig DI is the best for your case, as you can even create the reports after applying the rules. as Linus and Reeza recommeded Enterprise Guide is good but your data is huge as it is more than 1,000,000,000 so using good techniques and DI Features you can apply ur rules ... View more

we found that one of the team did a wrong configuration. we found it and fixed it. the problem was connecting to metadata server not SASAPP Server. the problem solved Thank you ... View more