************.
* QUESTION.
************.
A CGI Script of mine produces data that is formatted this way:
var1=4 var2=5 var3=6 var4=8
How can I import that into SPSS so that the name of the variable is left
out and it looks like this:
v1 v2 v3 v4
4 5 6 8
And there is another problem. If there is missing data in one cell the
corresponding variable is just left out, for example:
var1=4 var3=6 var4=8
(var2 is missing because there is missing data in it).
How can I import that into SPSS so that it looks like this:
v1 v2 v3 v4
4 . 6 8
********.
* ANSWER posted by rlevesque@videotron.ca to SPSSX-L on 2001/05/16.
********.
DATA LIST FIXED /a 1-80(A).
BEGIN DATA
var1=4 var2=5 var3=6 var4=8
var1=12 var3=34 var=1
END DATA.
LIST.
LOOP cnt=1 TO 4.
DO REPEAT var=var1 TO var4 /vname='var1' 'var2' 'var3' 'var4' /v=v1 TO v4.
IF INDEX(a,vname)>0 v=NUMBER(SUBSTR(a,INDEX(a,vname)+5,2),F8.0).
END REPEAT PRINT.
END LOOP.
EXECUTE.