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 highest missing value for numeric?

1 Answers  

What is the difference between the proc sql and data step?

0 Answers  

What is criteria for adverse events and treatment-emergent adverse events?

2 Answers   Accenture,

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

How do dates work in SAS data?

0 Answers  

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

1 Answers   Accenture,

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

3 Answers   L&T,