How do i change the length of multiple variables and datatype of variables from numeric to character in sas teradata passthrough sql. Please check and suggest if the below syntax is correct E.g- proc sql; connect to teradata as tera1 (user=myuser password=mypass server=myserver tpt=yes fastexport=yes); create table mytable as select * from connection to tera1 (select age,entityno ,'fbu1' as put(segid) length=10, trnsid as put(profgrp_id) length=$30.,accno length=20,startdt length=10,enddt length=10 from mytable where age > 15 ); disconnect from tera1; quit; Thanks ... View more

Hi, Can anyone help me with below select query.writting the sample query due to internet access issues at workplace Proc sql, Connect to teradata as tera(server"eiwb." Authdomain="sgkac." Mode=teradata) Create table abc as select * from connection to teradata( Select Y.accno, Y.transactionky, Case when() Case when() .......... from ( Select X.accno, X.transactionky, Count(X.transcount) as transcnt, Log(acd) as acd2, Log(brd) as brd2, From( Select a.transactionky key,b.accno, Max(gsj) as jsh, Log......... from Kcseg.cashflow a join Kcseg.accountdm b On a.accountno=b.accountno Where accountno in (527828,6272929,5262828) and a.datekey between 20190801 and 20190831 Group by b.accountno,a.transactionky )x Group by accountno,transactionky )y )by tera; Disconnect from tera; Quit; Please help if i have it the right way.because the query is giving me results in teradata but using sas passthrough it is giving syntax error 22-322: ... View more