cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Helannivas
‎07-27-2018
  • 115 Posts
  • 3 Likes Given
  • 0 Solutions
  • 9 Likes Received

Re: Problem while loading sas date into oracle

by Quartz | Level 8 in SAS Programming
‎07-09-2013 01:09 AM
‎07-09-2013 01:09 AM
Bailey, I hv defined the column as character datatype(not numeric). ... View more

Re: Problem while loading sas date into oracle

by Quartz | Level 8 in SAS Programming
‎07-08-2013 01:11 AM
‎07-08-2013 01:11 AM
Scott, I am using Oracle client.....Is ther any way to do this? ... View more

Re: Error in all SAS DI Client machines

by Quartz | Level 8 in SAS Data Management
‎07-07-2013 03:16 AM
‎07-07-2013 03:16 AM
Patrick, I will try this on tmrw an let  u knw. Anyhow,Thanks for your reply. ... View more

Re: Error in all SAS DI Client machines

by Quartz | Level 8 in SAS Data Management
‎07-07-2013 02:45 AM
‎07-07-2013 02:45 AM
Where we need to change this from local to SASMain(SAS App)? ... View more

Re: how to validate datetime column?

by Quartz | Level 8 in SAS Programming
‎07-06-2013 12:03 AM
‎07-06-2013 12:03 AM
Thanks all for ur reply. I am facing an issue in all client machines.So I cant able to run any job. I will try tis ,once the issue is resolved. Can u  pls help me in resolving this issue. https://communities.sas.com/thread/47658 ... View more

Error in all SAS DI Client machines

by Quartz | Level 8 in SAS Data Management
‎07-05-2013 11:56 PM
‎07-05-2013 11:56 PM
I am using SAS DI Studio 4.21. I am facing a new error from yesterday in all client machines,but the the job working fine in server . The error are as follows. 1)'A communication subsystem partner link setup request failure has occured'. '2)A Link must be established by executing the SIGNON command before you can communicate with LOCAL. These errors i got in file reader transformation. Do I need to change any configurations in server? Does anybody got these error before? Kindly help me on this. ... View more

how to validate datetime column?

by Quartz | Level 8 in SAS Programming
‎07-04-2013 12:50 PM
‎07-04-2013 12:50 PM
I have some source columns like(For Eg.) Process_Date Jun 01 2013 6.40pm Feb 14 2012 7.25am Mar 28 2011 3.40pm I need to validate this column,whether tis date is correct date or not. Then,I need to load this date column to target as (DD/MM/YYYY). like 01/06/2013 14/02/2012 28/03/2011 How to do this in SAS DI Studio?Kindly help me on this. ... View more

Re: Problem while loading sas date into oracle

by Quartz | Level 8 in SAS Programming
‎07-03-2013 03:17 AM
‎07-03-2013 03:17 AM
Hi bentleyj1, still i am facing that issue.While loading from flat file to oracle database,i am getting the date column as 01-Jan-1960. How to overcome tis issue.?I am using  SAS DI 4.21 Pls help ... View more

Re: Error in Date column

by Quartz | Level 8 in SAS Programming
‎07-02-2013 08:09 AM
‎07-02-2013 08:09 AM
Yes,my target in oracle database. My source s in flat file and extracted as character datatype in sas DI and i checked my target column (DOB) is in date format in oracle. I have tried some fncs ,its not workin.. ... View more

Error in Date column

by Quartz | Level 8 in SAS Programming
‎07-02-2013 05:12 AM
‎07-02-2013 05:12 AM
My source file for eg. DOB 28/10/1988 25/10/1988 I am loading into target table.I am getting the same o/p in SAS DI.(Right click on target table in sas DI job and open). But,When I check in oracle database,Its showing the o/p as DOB 01-Jan-1960 01-Jan-1960. What we we need to do?Pls help ... View more

Re: IFN function for date format?

by Quartz | Level 8 in SAS Programming
‎06-27-2013 07:48 AM
‎06-27-2013 07:48 AM
Hi, I dont know what to give in that 'DATE FORMAT'. I need to check the format(need to be in dd/mm/yyyy). For Eg: If DOJ is 13/12/1988 means o/p will be same             If DOJ is 13121988 means o/p will be any default date. Its possible by using IFN function? If not,how to proceed further. ... View more

IFN function for date format?

by Quartz | Level 8 in SAS Programming
‎06-27-2013 06:53 AM
‎06-27-2013 06:53 AM
In my source file, i have 2 columns For Eg: Name    DOJ Ram     13/12/1988 Kumar   21/05/1989 Ishant    110488 Can we use IFN Function here? IFN(DOJ = 'DATE FORMAT',DOJ,default date) whether it will work? I tried but no fruitful result. Help me on this. ... View more

Re: IS THERE ANY FUNCTION TO REPLACE null TO empty string

by Quartz | Level 8 in SAS Programming
‎06-27-2013 05:19 AM
‎06-27-2013 05:19 AM
In the Expression column I have given this. I cannot validate this expression.Its throwing error. I am using SAS DI studio 4.21. ... View more

IS THERE ANY FUNCTION TO REPLACE null TO empty string

by Quartz | Level 8 in SAS Programming
‎06-27-2013 05:02 AM
‎06-27-2013 05:02 AM
I have used coalescec function (coalescec(Name,' ' )) for this.But it is not working.KIndly help me on this. ... View more

Re: how to Load Row Number in SAS DI

by Quartz | Level 8 in SAS Programming
‎06-26-2013 05:02 AM
‎06-26-2013 05:02 AM
When I used coalescec('Name',' ' ),the Name column has the values as name in both the rows.(like this) Name   Emp_Id Name     123 Name     456 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-27-2018 10:46 AM
Likes given to
View All
Likes from
View All
Quick links