topic Sas to Teradata sql in SAS Programming

Sas to Teradata sql

Harish32 — Fri, 10 May 2019 06:40:28 GMT

I want the following code to be converted to Teradata SQL. Please help. Thanks In advance.

data weight2;
input IDnumber $ Week1;
datalines;
2477 200
2477 295
2431 220
2431 150
2412 135
;

proc sort data=weight2;
by descending IDnumber ;
run;

data we;
set weight2 ;
by descending IDnumber;
if first.IDnumber then do;
y=0;
end;
y=Week1-y;
retain y;
run;

Re: Sas to Teradata sql

LinusH — Fri, 10 May 2019 08:51:15 GMT

This is a SAS community, so Teradata knowledge can be limited.

The logic you show is not easy to directly convert to SQL, could be if Teradata have some specific functions/syntax for this.

You might be better off asking in a Teradata forum.

For slightly simpler queries, just use a Teradata libname, it will generate Teradata SQL on the fly (implicit SQL pass through).