Hi I use this code but I don't understand what it really does. It was written by someone in windows enviroment and now we changed to solaris(UNIX). I am not very clear with solaris(UNIX) syntax. Can someone explain to me what it says: proc sql; connect to sqlsvr as BDMIS (datasrc="BDMIS" user=sasuser password=XXXXXXX); create table temp4.FACT_BASE as select * from BDMIS (SELECT * FROM FACT_BASE WHERE &wherefmt); quit; ERROR: Invalid option name SELECT. ERROR: Some options for file WORK.BDMIS were not processed because of errors or warnings noted above. ... View more