Hi,
I have the following table:
So far so, good.
But I want to use STATS TABLE CALC to calculate (share of total unemployment )= (Long termunemployment rate) / tunemp *100 and put the result in the tunemp columns.
My attempt is the following
STATS TABLE CALC SUBTYPE="custom table" PROCESS=PRECEDING/TARGET DIMENSION=COLUMNS LEVEL=-1 LOCATION=1 4 7 MODE=REPLACE LABEL="Share of total unemployment"FORMULA ="x[-1]/x[0]*100".
That does nothing; it does not even generate an error message.
I am obviously doing something wrong, but what? (I am using SPSS 27, on a windows 10 computer)
Best,
Jon
Send me an spv file containing the table (jkpeck@gmail.com), and I'll figure it out. Sometimes CTABLES output has some invisible structure.