Question: how to import a password protected excel file into sas?
Answer: Without password protection, MS Excel files can be imported into SAS data sets in one of the following ways: 1) Proc Import; 2) Proc Access; 3) Using Import Wizard (Manually); 4) Using DDE routine syntax; 5) Using SAS/Access to ODBC (Proc SQL); 6) Using JMP (Manually or programmatically); or 7) Using Data step (saving ...