About sqltrysh

sqltrysh · ‎10-30-2014

thanks Kurt ! what do you mean by log ? I'm working with many tables in teradata using proc sql everytime ; so I don't use "data" syntax . When i tried : CASE WHEN A.SOUR in ('BIO') then input(G.FACT,best12.) else F.FACT end as FACT , i get this error : ERROR: Teradata execute: Syntax error: expected something between the 'then' keyword and the 'input' keyword. G.FACT is a varchar 50 in teradata and F.FACT is an integer and I want G.FACT as an integer in my proc sql in SAS I expect that it's more clear

sqltrysh · ‎10-30-2014

thanks but i tried this and i get an error : " Syntax error: expected something between the 'then' keyword and the 'input' keyword. " I have another question please ; which format should i apply if the column is an integer in teradata ? thanks

sqltrysh · ‎10-29-2014

hello, I have a problem in my sql sas procedures; I do a join between two tables to retrieve a field with a "case When " proc sql; select CASE WHEN A.SOUR in ('BIO') then G.FACT else F.FACT end as FACT the problem is that the attributes of the two fields are different in the two tables (G and F); I have a number and a varchar; This column will automatically take a varchar format and I want it to be number because later in my sql procedures I will join this field with the same but with a number format on other tables. I tried an update on the table but I get an error: Bad character in size If someone has an idea .. Thank you in advance

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: convert varchar to number in a proc sql

Re: convert varchar to number in a proc sql

convert varchar to number in a proc sql

Re: convert varchar to number in a proc sql

Re: convert varchar to number in a proc sql

convert varchar to number in a proc sql