Sas to Teradata sql

[Harish32]

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;

[LinusH]

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).