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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.