DATA Step, Macro, Functions and more

importing password protect excel file into sas

Reply
SAS Employee
Posts: 73

importing password protect excel file into sas

importing password protect excel file into sas, how?
SAS Employee
Posts: 73

Re: importing password protect excel file into sas

Posted in reply to Pavan_SAS
i know the password also.

help me !
Super Contributor
Super Contributor
Posts: 3,174

Re: importing password protect excel file into sas

Posted in reply to Pavan_SAS
You may have success using the FILENAME and DDE engine, as is mentioned in the SUGI technical paper below; this document makes mention that the DDE "open function" accepts parameters, one that would be a password. The specific format is unfamiliar to me, and I could find no reference at the SAS support website http://support.sas.com/ .

You may want to open a SAS support track for this inquiry, if you cannot determine the correct approach on your own.

Scott Barry
SBBWorks, Inc.

http://www.sas-consultant.com/professional/SUGI26-Against-All-ODS-1.pdf


SAS 9.1 Companion for Windows - search for FILENAME and DDE engine:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_hostwin_6974.pdf
Ask a Question
Discussion stats
  • 2 replies
  • 309 views
  • 0 likes
  • 2 in conversation