First question: is there anything like SAS PROC SQL manual for JMP - ie SQL syntax a la JMP? Online?
Second question:
I am running the following query:
SELECT t1.Record, t1."plist.dict.array.dict.key._text" AS "key", t1."plist.dict.array.dict.string._text" AS string
FROM "antiwar-v3" t1
WHERE t1.Record IN (SELECT DISTINCT t2.Record FROM "antiwar-v3" t2 WHERE t2."plist.dict.array.dict.key._text" = "Object" )
ORDER BY t1.Record ASC, t1."plist.dict.array.dict.key._text" ASC;
The key to this is that the column, Record, is calculated - formula based on the previous row.
That same formula is returned as a result - not desired.
Is there a way to "cast" the formula in the source table into what is in the original table?
TIA
