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

my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

2 Answers   Dr Reddys, Oracle,

if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.

2 Answers  

explain the proc in sas? : Sas-administrator

0 Answers  

What are the parameters of scan function?

0 Answers  

Mention what are the data types does SAS contain?

0 Answers  

How would you compile all macros from a folder in a study, within the autoexec program?

1 Answers  

Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,

I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  

where are dashboard components are created and maintained? : Sas-bi

0 Answers  

How would you delete duplicate observations?

9 Answers  

i want to upload titles and footnotes to excel file?how it is possible?

1 Answers  

What are the different versions of sas that you have used until now? : sas-grid-administration

0 Answers