How to read multiple excel sheets from a single excel file
at once????

Answer Posted / rajesh

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

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are you involved in writing the inferential analysis plan? Tables specfications?

2015


Explain proc univariate?

819


What would be the value of month at the end of data step execution and how many observations would be there?

823


What is proc sort?

928


Explain the use of proc print and proc contents?

755


Enlist the functions performed by sas.

892


how does sas handle missing values in procs? : Sas programming

917


what is sas application server? : Sas-di

765


How would you define the end of a macro? : sas-macro

873


What are symget and symput? : sas-macro

1016


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1175


how many types of prompts are there? : Sas-bi

791


what is the effect of the options statement errors=1? : Sas programming

840


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

834


Mention the category in which sas informats are placed?

819