09-01-2015
jcheema
Calcite | Level 5
Member since
11-14-2011
- 8 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by jcheema
Subject Views Posted 2307 12-13-2011 09:47 AM 1865 12-12-2011 08:20 AM 2161 12-09-2011 11:28 AM 2227 12-07-2011 03:48 PM 4698 11-17-2011 09:32 AM 1910 11-14-2011 12:07 PM 1910 11-14-2011 11:36 AM 2205 11-14-2011 11:05 AM -
Activity Feed for jcheema
- Posted %scan has too many arguments on SAS Programming. 12-13-2011 09:47 AM
- Posted DI Studio -- How To? on SAS Data Management. 12-12-2011 08:20 AM
- Posted Re: Problem using yymmdd11. informat on SAS Programming. 12-09-2011 11:28 AM
- Posted DI Studio -- How To? on SAS Data Management. 12-07-2011 03:48 PM
- Posted How to use the format catalog generated from other operating system. on SAS Programming. 11-17-2011 09:32 AM
- Posted What is the correct syntax for inserting into Oracle date col? on SAS Programming. 11-14-2011 12:07 PM
- Posted What is the correct syntax for inserting into Oracle date col? on SAS Programming. 11-14-2011 11:36 AM
- Posted What is the correct syntax for inserting into Oracle date col? on SAS Programming. 11-14-2011 11:05 AM
12-13-2011
09:47 AM
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
12-09-2011
11:28 AM
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
12-07-2011
03:48 PM
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
11-17-2011
09:32 AM
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
11-14-2011
12:07 PM
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
11-14-2011
11:36 AM
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
11-14-2011
11:05 AM
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