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

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

864


How to include or exclude specific variables in a data set?

847


what is sas data set?

847


Describe crosslist option in tables statement?

914


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2107






Differentiate between proc means and proc summary.

766


What is the use of stop statement?

802


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2323


Tell me about % include and % eval? : sas-macro

870


What is factor analysis?

836


What are the new features included in the new version of SAS Programming Language?

927


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

769


What is the work of tranwrd function?

896


how would you create multiple observations from a single observation? : Sas programming

755


why a stop statement is needed for the point= option on a set statement?

799