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;
... View more
