About Hercules

Hercules · ‎05-17-2015

Hmmmm ... that can be a logic. let me try out this one thanks

Hercules · ‎05-17-2015

That's what I was trying to do. See my second post. When I ma trying to replace spaces by # then its is giving me all the hashes. Like for col1 length 10 (representing dots as spaces) Col1 Anant... Sas Hello.. If I am using tranwrd then: Col1 Anant##### Sas####### Hello###### But ideally it should be Anant ### Sas Hello##

Hercules · ‎05-17-2015

Yes Jaap, that is helpful. But what if I want to select distinct values? If I am using this: Proc SQL; select distinct col1 from data1; quit; Then the output is: Col1 Anant Which actually should be: Col1 Anant Anant...... (Considering dots as spaces)

Hercules · ‎05-17-2015

Yes that is OK, but I don't only want to find the length. my main concern is to read these two as different values. If you write, proc SQL; select distinct col1 from x; run; Then the output will be- Col1 Anant But these are two different values.

Hercules · ‎05-17-2015

I just wrote a small data step. Data; Col1= 'Anant '; Col2= length(col1); run; When I copy paste the value Anant in a notepad, there is no trailing space. also the length has given me 5 as output. But it should be 10 (as I've given 5 spaces), right?

Hercules · ‎05-17-2015

I have tried that Xia, That is also not working.

Hercules · ‎05-17-2015

Hello Jaap, I agree with you, but not only Teradata, even if I am making a data set in SAS, then also the spaces are not coming. Its like SAS is removing trailing spaces by default.

Hercules · ‎05-17-2015

Then how can I have trailing spaces?

Hercules · ‎05-17-2015

My target column is a UPI in Teradata. That's why it is discarding the other value I.e. 026 with blanks. As there are two values of 026 and 026 with spaces.

Hercules · ‎05-17-2015

Hello, Thanks for the quick reply. Not even that working. I tried first converting spaces into hashes by using TRANWRD and then replacing # by spaces again. But when I do that, SAS converts all the non occupied places as spaces whether it was in the column value or not. Approach I'm using is- Tranwrd(column1,"20"x,"#") for eg, if the column1 has some values and length as 10 $ (Representing dot as spaces) COLUMN1 Anant... Sas. Oracle First it converts like- Anant##### Sas####### Oracle#### But it should be like, Anant### Sas# Oracle

Hercules · ‎05-16-2015

Ok, So I am trying to create a table in Teradata from Oracle using SAS. When I do that, SAS by default remove the trailing spaces, but I want those spaces. For example: If I have a value as 026... (dot representing spaces here) SAS load them into a Teradata table as : 026 How can I achieve that? Thanks in advance.

Hercules · ‎05-07-2015

The error is of Oracle with the error code 01858. This error can be because the data types of your columns are not date. Also I don't see any unit of measure with your truncate function as well. Are you trying to truncate date-time field to date? Also, is it the same query you are trying to run? Because I don’t see any alias name for the tables referred as 'a' , 'b' and 'x'. And if it is just an example and rec_date is date-time format then try nvl function with a date-time replacement, such as '31-dec-9999:00:00:00'. It would be helpful if you can provide your requirement.

Hercules · ‎02-24-2015

Hello, I'm trying to perform multiload in teradata but I'm getting some error in it. The program I'm writing is very simple. PROC SQL; INSERT INTO TERA.TEST1 (FASTLOAD=YES) SELECT * FROM ORA.TEST WHERE YEAR(DATEPART(RCRE_TIME))=2002; QUIT; This part is working just fine. Because of the fast load. But when I'm writing this program for multiload I'm getting the following error. PROC SQL; INSERT INTO TERA.TEST1 (MULTILOAD=YES) SELECT * FROM ORA.TEST WHERE YEAR(DATEPART(RCRE_TIME))=2003; QUIT; ERROR: Create semaphore failed with return code 28. ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [SQL (2) ] Segmentation Violation Traceback of the Exception: /sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x5165ad] /sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x41e9f8] /sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x41e6cf] /sasinst/SASHome/SASFoundation/9.3/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f011dd066e4] /lib64/libpthread.so.0() [0x3c6b80f710] /sasinst/SASHome/SASFoundation/9.3/sasexe/sasiotra(trclose+0x1724) [0x7f00f0757e04] /sasinst/SASHome/SASFoundation/9.3/sasexe/sasxdbi(dbiclos+0x48) [0x7f00f122b878] /sasinst/SASHome/SASFoundation/9.3/sasexe/sasxdbi(yoeclos+0x18c) [0x7f00f11fc11c] /sasinst/SASHome/SASFoundation/9.3/sasexe/sasyoio(yoclose+0x9c6) [0x7f00deb441c6] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2be01) [0x7f00de744e01] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2b93b) [0x7f00de74493b] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2dc50) [0x7f00de746c50] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(sqxexec+0x5a0) [0x7f00de762210] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(sqlloop+0xf8a) [0x7f00de75af2a] /sasinst/SASHome/SASFoundation/9.3/sasexe/sassql(sassql+0x276) [0x7f00cf229e66] /sasinst/SASHome/SASFoundation/9.3/sasexe/sas(vvtentr+0x104) [0x41e614] /lib64/libpthread.so.0() [0x3c6b8079d1] /lib64/libc.so.6(clone+0x6d) [0x3c6b4e8b6d] SAS WTABORT (SQL (2)) The SAS System has detected an abort condition. An Exception occurred during wthtrm(). Please Contact Technical Support. Tasks [MAIN ] [WAITING ] pri[ 5] reb[14B315C0] WC[0] WN[1] 2 The SAS System 13:04 Tuesday, February 24, 2015 [IDLETASK] [READY ] pri[ 9] reb[14B315C0] [EVENTTSK] [WAITING ] pri[ 0] reb[14B315C0] WC[0] WN[1] [sasxkern] [WAITING ] pri[ 3] reb[14B315C0] WC[0] WN[1] [Session ] [WAITING ] pri[ 3] reb[0E5FB0E0] WC[0] WN[1] [TKSRV ] [WAITING ] pri[ 3] reb[0E5FB6A0] WC[0] WN[1] [Object S] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1] [DOSSCHT ] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1] [OBJECT_E] [WAITING ] pri[ 7] reb[E409D260] WC[0] WN[1] [DOSSCHT ] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1] [ODX Moni] [WAITING ] pri[ 7] reb[E409D260] WC[0] WN[1] [SASODR ] [WAITING ] pri[ 3] reb[DF212190] WC[0] WN[1] [SQL (2) ] [RUNNING ] pri[ 7] reb[DF1685A0] Traceback No Traceback Available ERROR: User asked for termination

Hercules · ‎02-01-2015

Thank you so much Linus. Found the document and is very useful.

Hercules · ‎02-01-2015

Hello, Can SAS workflow be run or schedule through Unix shell script or base SAS code if I don't have LSF.

Online Status	Offline
Date Last Visited	‎10-13-2017 02:55 AM

Re: A SAS Macro for Enterprise Data Warehouse Dynamic implementation

Re: A SAS Macro for Enterprise Data Warehouse Dynamic implementation

A SAS Macro for Enterprise Data Warehouse Dynamic implementation

Re: Publish a Paper with SAS

Publish a Paper with SAS

Re: Create SAS users through Base SAS Program

Re: Create SAS users through Base SAS Program

Re: Create SAS users through Base SAS Program

Re: Create SAS users through Base SAS Program

Create SAS users through Base SAS Program

Re: Unable to use teradata or sql functions in table loader expression...

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Re: Don't want to remove trailing spaces

Don't want to remove trailing spaces

Re: SAS/SQL Error

Multiload error in teradata

Re: Sas workflow from Unix script

Sas workflow from Unix script