Date:         Wed, 20 Jan 2010 08:46:36 -0500
Reply-To:     Shaik Hymad <hymadsk@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shaik Hymad <hymadsk@GMAIL.COM>
Subject:      How to open excel file in Sas using _null_?

Hi To all,

   I'm trying to open excel file and iam writing code like this.

 %let ext_file = C:\Documents and Settings\Desktop\Athx.xls;

  filename ddemd dde 'excel|system';

  data _null_;
    file ddemd;
     put '[FILE-open("&ext_file")]';
    put '[QUIT()]';
  run;

 But Iam getting error in the log  "The file was not exist"

 Can you please help me out this, where iam wrong.


Thanks&Regards,
Hymad Sk