I execute the proc sql pass through (Teradata to SAS). %let sql=select current_date from sys_calendar.calendar proc sql noprint; CONNECT TO TERADATA(Authdomain= SERVER= mode=); CREATE table &number AS SELECT * FROM CONNECTION TO TERADATA (&sql.); DISCONNECT FROM TERADATA; QUIT; I have a problem because I am seeing date format as DATEw. but I need format 'YYYY-MM-DD'. I know I can do that: select a, period_date format=yymmdd10. as c, b FROM CONNECTION TO TERADATA I have a date format: 13MAY2016, but I need: '2016-05-12' but I have about 150 sqls, so I prefer a more global solution than a new format for each sql. Can I use some options? I need the same for each date, so I wolud like do that in global way.
... View more