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
Are you involved in writing the inferential analysis plan? Tables specfications?
Explain proc univariate?
What would be the value of month at the end of data step execution and how many observations would be there?
What is proc sort?
Explain the use of proc print and proc contents?
Enlist the functions performed by sas.
how does sas handle missing values in procs? : Sas programming
what is sas application server? : Sas-di
How would you define the end of a macro? : sas-macro
What are symget and symput? : sas-macro
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 ...
how many types of prompts are there? : Sas-bi
what is the effect of the options statement errors=1? : Sas programming
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
Mention the category in which sas informats are placed?