topic Re: Check When data set was lastly updated in SAS Programming

Check When data set was lastly updated

Ronein — Thu, 16 Nov 2023 08:38:55 GMT

Hello

I am running via SAS code to check when a table was created (And when was updated ).

This table is located in TeraData.

What is the reason that I see No information on this information

proc contents data=tcrmseg.gal_hravot_brzel_2023;Run;

/**Other Way**/
proc datasets library=TCRMSEG;
contents data=gal_hravot_brzel_2023;
run;

Re: Check When data set was lastly updated

Kurt_Bremser — Thu, 16 Nov 2023 10:22:29 GMT

I suggest you query the Teradata equivalent of DICTIONARY.TABLES in explicit pass-through.

Re: Check When data set was lastly updated

Ronein — Tue, 21 Nov 2023 12:07:55 GMT

So you recommend query it inside Tera and not in SAS?

Re: Check When data set was lastly updated

Quentin — Tue, 21 Nov 2023 13:37:28 GMT

After figuring out how to query the metadata in teradata, and getting that query working, then you can come back to SAS.

SAS Explicit pass-through SQL allows you to use SAS, but write native teradata SQL code that SAS will send to teradata for execution, and then return results to SAS. See for example https://www.lexjansen.com/sesug/2017/DM-57.pdf.

Re: Check When data set was lastly updated

Kurt_Bremser — Tue, 21 Nov 2023 13:45:07 GMT

@Ronein wrote:

So you recommend query it inside Tera and not in SAS?

From SAS, using Teradata code in explicit pass-through.

Re: Check When data set was lastly updated

SASKiwi — Wed, 22 Nov 2023 01:43:01 GMT

@Ronein - First you will need to define what you mean by "last updated". Does that mean the last time rows were updated, inserted, or deleted or all three? If you Google the question then you will get answers like this: https://stackoverflow.com/questions/58404933/teradata-how-to-find-when-was-table-last-updated-not-altered

Once you are happy with the Teradata query, you can wrap it inside a SAS PROC SQL step:

libname teradata teradata noprompt = "<Teradata connection string>";

proc sql;
 connect using teradata;
  create table Want as 
  select * from connection to teradata
  (<-Put your Teradata query here->)
  ;
quit;