topic Trailing dot in sas teradata passthrough in SAS Procedures

Trailing dot in sas teradata passthrough

nid197 — Wed, 29 Jan 2020 14:35:09 GMT

Hi I am Getting trailing "." (Period,dot) when i try to create a dataset using teradata passthrough.i want the variable as character.
Eg.
Prf_id(varchar)
626278.
726277.
627277.
726256.
62727.

Please help.
Thanks

Re: Trailing dot in sas teradata passthrough

Kurt_Bremser — Wed, 29 Jan 2020 14:46:16 GMT

Please post the whole code that created this dataset. Use the "little running man" to post code.

Re: Trailing dot in sas teradata passthrough

nid197 — Wed, 29 Jan 2020 14:52:40 GMT

Here is the code-

proc sql;
connect to teradata as tera1 (user="xxxxxx" password="xxxxxxx" server="xxxxx"
tpt=yes fastexport=yes);
create table mytable as
select * from connection to tera1
(select age
,entityno
,cast(segid as varchar(50)) as fbu1
,cast(profgrp_id as varchar(30)) as trnsid
,cast(accno as integer)as accno
,cast(startdt as varchar(10)) as startdt
,cast(enddt as varchar(10)) as enddt
from mytable1 a
Mytabke2
where age > 15 );
disconnect from tera1;
quit;

Re: Trailing dot in sas teradata passthrough

nid197 — Wed, 29 Jan 2020 14:53:29 GMT

Just a demo code.with changed names.sorry if i there is typo.but syntax is same

Re: Trailing dot in sas teradata passthrough

nirajs — Wed, 29 Jan 2020 18:12:22 GMT

Since the original values are in decimal format, you will need the double cast.

proc sql;
connect to teradata as tera1 (user="xxxxxx" password="xxxxxxx" server="xxxxx"
tpt=yes fastexport=yes);
create table mytable as
select * from connection to tera1
(select age
,entityno
,cast(cast(segid as format 'Z(I)') as varchar(50)) as fbu1
,cast(cast(profgrp_id as format 'Z(I)') as varchar(30)) as trnsid
,cast(accno as integer)as accno
,cast(cast(startdt as format 'Z(I)') as varchar(10)) as startdt
,cast(cast(enddt as format 'Z(I)') as varchar(10)) as enddt
from mytable1 a
Mytabke2
where age > 15 );
disconnect from tera1;
quit;

Let me know if this helps.