Answer / sravan

Using libname statement.

Libname <lib_name> excel 'file_specification';

Answer / vinodnagesh

BY USING DDE TRIPLET

Answer / rajesh

First you have to split the excel sheets and write the
program in macros and use the dde triplet.

Answer / srinivas krishnan

BY USING DDE TRIPLET

Answer / paul

we can read by a simple libname access method:

eg:
libname exlbook 'd:\excel file location\file name.xls';
proc copy in=exlbook out=work;
run;

/*here i am coying the entire excel workbook to work library
in sas, so we can get all sheets at a time.
if we use proc import we can import a single sheet at a time
By the above method we can dump all table from a MS-access database or oracle database or any other db.
only we have to change the connection details, i.e.,

excel --> file name with path
access --> db name with path
oracle/any other RDBMS --> user=***, password=****,
path=**** or host=****

another advantage of this method is :
the library will not occupy any memory on hard disc
it only acts as a repository which save memory and
processing time */

Answer / 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);

Answer / lucylu

%macro read_moresheets(ifile, lib);
libname ixls excel &ifile;

proc sql;
select memname into :ds1 - :ds100
from sashelp.vtable
where libname = "IXLS" and index(memname,'$') = 0
;
quit;

%put _user_;

%do i = 1 %to &sqlobs;
data &lib..&&ds&i;
set ixls.&&ds&i;
run;
%end;
%mend;
%read_moresheets("C:\Ongoing\CallActivity.xls", work);

What is the difference between an informat and a format? Name three informats or formats.

13 Answers   Accenture, IBM,

What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,

how to read the variables in sas? : Sas-administrator

0 Answers  

Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?

5 Answers   American Express, Barclays,

What are Dashboard reports?And significance of these in analysis?

1 Answers  

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

0 Answers  

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

0 Answers  

Give some ways by which you can define the variables to produce the summary report (using proc report)?

0 Answers  

Which date function advances a date, time or datetime value by a given interval?

0 Answers  

What is the function of output statement in a SAS Program?

0 Answers  

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,

For what purposes have you used sas macros? : sas-macro

0 Answers