Greetings 15GreyGoose. i pass most of my queries from SAS to the server hosting the data. by doing this, you can use just about any compliant SQL Statement (in my experience). the only common exception for me is the use of '--' for comment code in SQL Server. SAS does not seem to like that here. i suggest using block style commenting: /* comments */ here is a basic template you can use: PROC SQL;
CONNECT TO ODBC as Alias
(DATAsrc="DSN" authdomain=IfOneIsSetUp);
CREATE TABLE work.thing AS
SELECT *
FROM CONNECTION TO Alias
(
/*SQL Code*/
SELECT Convert(Date,DATEADD(MONTH, DATEDIFF(MONTH, -1, APP_DATE_AJUDICATED )+0, -1)) FROM YourDbTableName
);
DISCONNECT FROM Alias;
QUIT; you will need to know the DSN for the remote server hosting the data. you might be able to find the DSN by right click the Libname under libraries. you will also need credentials to connect, we use an authodomain, but something like this could work as well: (noprompt = "server=ServerName; UID=UserId; pwd=UserPassword;DRIVER=SQL Server; DATABASE = DatabaseNameOnServer" )
... View more