I am trying to import certain columns from MYSQL server and I want to change the format for Datetime fields to 'YYYY-MM-DD HH:MM' and also I need space between column names as the report that uses the data has similar format.
I am trying something like this but seems to ran into error:
PROC SQL;
CONNECT TO xxx AS xxxx (noprompt = "server=xxxxx ;DRIVER=SQL Server;Trusted Connection=yes;DATABASE=xxxx;");
CREATE TABLE X AS
SELECT * FROM connection to A
(
SELECT t1.SAS data1,
t1.DateTime format=NLDATMS19. As DueDatetime
FROM xxx.xxxx as t1
);
DISCONNECT FROM xxxx;
QUIT;
Looks like your BatchServer runs with VALIDVARNME=V7, and your workspace server with VALIADVARNAME=ANY.
Please post the SAS log of the scheduled job.
Looks like your BatchServer runs with VALIDVARNME=V7, and your workspace server with VALIADVARNAME=ANY.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.