Recently I started learning SAS. I have Excel 2007 in my PC. I am using Unix SAS. Is there any way I can read Excel file from my local PC in Unix SAS? I have also WIN SCP installed in my computer.My colleague was saying that I need to use PC SAS. Is that true?
there is a SAS product that might help. See http://support.sas.com/kb/20/325.html
20325 - Using the EXPORT procedure with DBMS=XLS in 9.1.3 SAS/ACCESS® Interface to PC Files under UNIX to create a Microsoft Excel