[focus-l] Re: TRUNCATION
- From: "Hamilton, Robert" <roberth@xxxxxxxxxxxx>
- To: <focus-l@xxxxxxxxxxxxx>
- Date: Wed, 5 May 2004 11:52:04 -0500
If it finds FUND in the list pointed to by GS ddname then it returns '
' else XFUND WITH the statement
COL1 /A5 =3D DECODE FUND(GS ELSE 'XFUND');
GS is just a list of funds like so,
80424
84104
84404
84604
80305
82414
nothing more; if fund is found in this list then blanks are put in COL1
if=20
FUND is not in the list then COL1 has the value XFUND.
Another thing; is there a way to make focus list every value in each row
it
Is very confusing for the user to see
STU_ID FUND EFC OFFER_BAL ROW AMT1 cOL1 HOUSING
------ ---- --- --------- --- ---- ---- -------
xxx263738 84604 0 7029.00 1 0 XFUND
xxx267177 80014 0 1519.00 1 1519 2
84104 0 5500.00 1 0 XFUND
84404 0 114.00 1 0 XFUND
sss280621 80014 427 3600.00 2 3600 2
80424 0 5460.00 1 0 XFUND
84104 0 5500.00 1 0 XFUND
84404 0 1631.00 1 0 XFUND
vvv283051 80014 1658 2400.00 5 2400 1
82014 0 3140.00 1 0
82104 0 2000.80 1 0 XFUND
www283893 81004 4448 750.00 10 0 XFUND 3
82004 0 3140.00 1 0
82104 0 2248.00 1 0 XFUND
82224 0 264.00 1 0
I need to get stu_id to appear in each and every row and have never
Figured out how to do it . . .
Thnx for the help
bobh
Other related posts:
