How to get from JMP table format WIDE to LONG. With some twists... [JSL, scripting]
Hi, Simply put, I just need to get from JMP format WIDE to LONG.I'll use BIG CLASS to outline the basic idea: dt = Open( "$SAMPLE_DATA/big class.jmp" );
Basic objective: Structure BEFORENAME AGE SEX HEIGHT WEIGHT
KATIE 12 F 59 95
LOUISE 12 F 61 123
JANE 12 F 55 74
JACLYN 12 F 66 145
Structure AFTER (let's see NAME and SEX as IDs)NAME SEX SOURCE_COL VALUE
KATIE F AGE 12
LOUISE F AGE 12
JANE F AGE 1
...