About Vi_

Vi_ · ‎06-13-2018

Hi, So I looked up Teradata's documentary. Substring and Substr are slightly different although they are all doing substring work. SAS Substr is equal to Substring in Teradata. My confusion is that when I code in sas, I ask sas to connect to Tera and perform query in tera, and then, create table in sas. So how did Teradata understand SAS substr and perform the query? Thanks, Vi

PGStats · ‎05-27-2018

1) The index is created to allow random access to the parent records. 2) This is precisely where the index comes in. This loop goes up the parent list (from the leaf to the root of the tree) and outputs every record along the way.The code id = parent; set Node key=Id/unique; replaces the current record with the parent of the current record.

Kurt_Bremser · ‎04-24-2018

Also see Maxim 12.

Online Status	Offline
Date Last Visited	‎08-27-2018 02:59 PM

Re: Proc SQL - TeraData - own sql

Re: Proc SQL - TeraData - own sql

Re: Any idea on how to generate customized Hpsplit Tree Rule?

Re: Any idea on how to generate customized Hpsplit Tree Rule?

Any idea on how to generate customized Hpsplit Tree Rule?

Re: macro write values into a variable instead of create new variables

Re: macro write values into a variable instead of create new variables

Re: macro write values into a variable instead of create new variables

Re: macro write values into a variable instead of create new variables

macro write values into a variable instead of create new variables

Re: ods pdf file fit on one page

Re: ODS PDF BOOKMARKS?

Re: macro variable in proc export excel file name

Re: macro write values into a variable instead of create new variables

Re: macro write values into a variable instead of create new variables

Re: Proc SQL - TeraData - own sql

Re: Any idea on how to generate customized Hpsplit Tree Rule?

Re: macro write values into a variable instead of create new variables