Interested to Buy Any Domain ? << Click Here >> for more details...
How to read multiple excel sheets from a single excel file
at once????
- 7 Answers
- 18334 Views
- HCL, Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answer Posted / ashish
%macro pim(sheet);
proc import out= payment
datafile = 'E:SAS DOCprojectCredit Banking.xls'
dbms = Excel;
sheet = "&sheet";
getnames = yes;
run;
%mend piim;
%pim(Customer Acqusition);
%pim(Spend);
%pim(Repayment);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain substr function?
Did you used proc test? when?
What are the advantages of using sas?
What is interleaving in SAS?
What versions of SAS have you used (on which platforms)?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what is the Population you used in your project, is it ITT or PP?
What is the difference between %put and symbolgen? : sas-macro
Tell e how how dealt with..
explain about various caches available in data integrator? : Sas-di
Do you know the features of sas?
What do the SAS log messages "numeric values have been converted to character" mean?
How would you define the end of a macro?
Explain how you can debug and test your SAS program?
How can you limit the variables written to output dataset in data step?
