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


Please Help Members By Posting Answers For Below Questions

What are pdv and it functions?

600


What are all the problems you faced while validating tables and reports?

3010


Name some categories in sas 9? : sas-grid-administration

557


what is snowflake schema? : Sas-di

696


Name any two sas spawners? : sas-grid-administration

558






what do the mod and int function do? What do the pad and dim functions do? : Sas programming

614


Are you sensitive to code walk-throughs peer review or QC review?

2607


Describe what are the different levels of administrative users in sas? : sas-grid-administration

600


What is interleaving in SAS?

673


what are _numeric_ and _character_ and what do they do? : Sas programming

675


what do you mean by data staging area? : Sas-di

604


Which command is used to save logs in the external file?

566


Differentiate between format and informat? : sas-grid-administration

580


do you prefer proc report or proc tabulate? Why? : Sas programming

573


Give e an example of..

1653