topic Re: SAS EG Computed Column in SAS Enterprise Guide

SAS EG Computed Column

WorkUser — Thu, 23 Mar 2023 12:58:24 GMT

I have the following dataset:

ID	NAME	AMOUNT
251717	Better Inc	$5
251717	Better Co	$24
252534	Pan Holdings	$520
252534	Pan Co	$820
259169	Province Inc	$300
259992	ABC Inc	$620

Is there a way in SAS EG query builder to create a new computed column called NEWNAME that when IDs are the same, to take the Name with the most amount? So the output would look like this following:

ID	NEWNAME	AMOUNT
251717	Better Co	$29
252534	Pan Co	$1,340
259169	Province Inc	$300
259992	ABC Inc	$620

Thanks

Re: SAS EG Computed Column

Kurt_Bremser — Thu, 23 Mar 2023 13:17:25 GMT

A little coding will be much easier than fiddling with the query builder:

proc sort data=have;
by id descending amount;
run;

data want;
set have (rename=(name=_name amount=_amount));
by id;
retain name amount;
if first.id
then do;
  name = _name;
  amount = _amount;
end;
else amount + _amount;
if last.id;
drop _:;
run;

Re: SAS EG Computed Column

SAS_V_R — Tue, 28 Mar 2023 16:39:42 GMT

I use EG. You can dabble with the calculator, go to Advanced Functions and mess around with the functions.

Otherwise, Drag the variable column name into select, then press the calculator thing. and identify the variable from its "source column like 't1'. or something like that and make an input statement.

Also, find out if you can make a case statement.