December 21, 2007, 02:49 PM
TrinaAssign a variable with a number value coming from a hold file
How to assign a variable with a number value coming from a hold file?
Pls help...
Trina
December 21, 2007, 03:25 PM
jbementThis sample shows how I have been able to get this to work:
SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
DEFINE FILE EMPDATA
NHIREDATE/MDY = HIREDATE;
NHIREMY/MY =NHIREDATE;
NEWSAL/D12.2 = SALARY * 1.5;
END
TABLE FILE EMPDATA
SUM
CNT.SALARY/I5C AS 'SCOUNT'
SALARY/D12.2C AS 'SALARY'0
ON TABLE HOLD AS SAL_STUFF
END
TABLE FILE SAL_STUFF
SUM
COMPUTE AVG/D12.2=SALARY/SCOUNT;
ON TABLE SAVE AS SAL_AVG
END
-RUN
-READ SAL_AVG &SAL_READ.12
-TYPE &SAL_READ
TABLE FILE EMPDATA
PRINT
COMPUTE SDIF/D12.2 = SALARY- &SAL_READ;
SALARY
END
December 21, 2007, 04:13 PM
FrankDutchTrina
I would ask you to upgrade your signature so we know what version you have.
The example given is ok, the only addition I would give is.
-READ SAL_AVG &SAL_READ.I12
I added the "I" because you want a numeric value.
It's all described in the wf761appslang.pdf file
December 28, 2007, 10:49 AM
TrinaThanks a lot to both of you.
Frank thanks for mentioning to add I before the length.
Trina