I could not make your code work but try with %quote %let nm_list=%QUOTE(Assistance#Credit and suretyship#Fire and other damage#Motor vehicle liability#Motor, other ) ;
... View more
How about: data test; date1='2011-AUG-12'; date2=input(substr(date1,10,2)||substr(date1,6,3)||substr(date1,1,4),date9.); put date1= date2= ; run;
... View more
I have three questions: 1. Can a Table Loader Transformation have more than one input? Can we connect it to two data sources or do we always have to connect the two data sources to a SQL Join transformation and output of that is connected to the Loader. 2. How do we delete rows in a target table? 3. How can I get max/min values of some columns along with class/by variables ? Regards, Jagtar Cheema
... View more
In case you have access to SAS on the source platform then you could use Proc Format to create a dataset from the formats. On target platform again use Proc format to convert the dataset to formats
... View more
Yes '14NOV2011:00:00'dt works -- incidently '14NOV2011'd would not work. But I want to use date() or datetime() function in the insert clause / DI job
... View more
Thanks Tom. That will work but I am trying to find out the correct format. Actual problem is with a DI job I am creating which needs to insert current date into an Oracle date column. I have used date() function but I am getting 01 Jan 1960 .
... View more
I have the following code : proc sql; insert into ora.sas_ora_out( date_col) values('14-NOV-11'); quit; However, I get this error: ERROR: Value 1 of VALUES clause 1 does not match the data type of the corresponding column in the object-item list (in the SELECT clause).
... View more
