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
- 18231 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 is the difference between %local and %global? : sas-macro
Which command is used to save logs in the external file?
How to create an external dataset with sas code?
Name validation tools used in SAS
Explain the purpose of retain statement.
How to read an input file in sas?
What is a macro routine?
How many data types are there in SAS?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What are the scrubbing procedures in sas?
describe about metadata object? : Sas-di
How is character variable converted into numeric variable and vice versa?
what is SAS OPTIMIZATION?
How we can create SAS USER DEFINED CODE?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
