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

Have you ever used the SAS Debugger?

0 Answers   Quintiles,

What are the functions used for character handling?

0 Answers  

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 Answers  

What Proc glm does?

0 Answers  

what is the use of LRECL option.

1 Answers   L&T,

what is the difference between floor and ceil functions in sas? : Sas-administrator

0 Answers  

how to delete the duplicate columns permanently in SQL

2 Answers   Satyam,

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

9 Answers   Quintiles,

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers   Accenture, Sciformix,

Which are the statements whose placement in the data step is critical?

0 Answers  

What would you change about your job?

0 Answers   Oracle,

how can you get the single data set from the library(which has the number of data sets)?

3 Answers   Accenture, Deloitte,