How to read multiple excel sheets from a single excel file
at once????
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 pdv and it functions?
What are all the problems you faced while validating tables and reports?
Name some categories in sas 9? : sas-grid-administration
what is snowflake schema? : Sas-di
Name any two sas spawners? : sas-grid-administration
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Are you sensitive to code walk-throughs peer review or QC review?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What is interleaving in SAS?
what are _numeric_ and _character_ and what do they do? : Sas programming
what do you mean by data staging area? : Sas-di
Which command is used to save logs in the external file?
Differentiate between format and informat? : sas-grid-administration
do you prefer proc report or proc tabulate? Why? : Sas programming
Give e an example of..