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
- 18618 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 difficulties u faced while doing vital signs table or dataset?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Describe the function and utility of the most difficult SAS macro that you have written?
What are the differences between sum function and using “+” operator?
what is factor analysis? : Sas-administrator
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
explain what is data set in sas? : Sas-administrator
How many ways to overcome a missing values???
how does sas handle missing values in procs? : Sas programming
explain about various caches available in data integrator? : Sas-di
What is PDV?
What are SAS/ACCESS and SAS/CONNECT?
What system options would you use to help debug a macro? : sas-macro
Explain the main difference between the sas procedures and functions? : Sas-administrator
