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
- 18473 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
What are the data types does SAS contain?
Explain append procedure?
for whom is sas data integration studio designed? : Sas-di
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How do you add a number to a macro variable? : sas-macro
How substr function works in sas?
How do you control the number of observations and/or variables read or written?
What is the maximum and minimum length of macro variable
What is the basic structure of the SAS base program?
what is SAS OPTIMIZATION?
Have you ever used the SAS Debugger?
What will calendar procedure do?
Tell me more about the parameters in macro? : sas-macro
How can sas program be validated?
Of all your work, where have you been the most successful?
