03-03-2015 04:01 AM
i have excel file .
it contains different sheets like jan, feb, mar and apr .
how to import multiple excel sheets at a time using dde.
plz send me full notes on dde in sas
03-03-2015 07:10 AM
i don't DDE know but using libname statement it is possible.
libname abc "E:\sample.xls";
by running this all excel sheets data is copied to abc library. But one drawback is that the if you use this statement
then excel data is copied to abc library. and in excel that data is not available.
and again if you use libname abc clear; then copied as usual data is copied to excel.
If you SET statement to copied that datasets from another its not possible. then you have to use
this is the way moving data sets from another library.
03-08-2015 12:13 AM
The libname statements open a connection to the Excel file and you can reference the sheets as if they were datasets in a library.
No information is copied anywhere.
You do have to use name literal notation to reference Sheets, but not necessarily ranges.
03-07-2015 01:33 PM
instead of DDE you can try following code,