Date:         Wed, 28 Mar 2012 04:57:10 -0700
Reply-To:     David Marso <david.marso@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         David Marso <david.marso@gmail.com>
Subject:      Re: SPSS data file to ASCII card data file
In-Reply-To:  <1332934583193-5600176.post@n5.nabble.com>
Content-Type: text/plain; charset=UTF-8

The string concatenation solution will be more direct!
DATA LIST /MR1 TO MR10 1-10.
begin data
0011011101
1110110110
1100110011
end data.
STRING MRCAT (A20).
VECTOR M=MR1 TO MR10.
LOOP #=1 TO 10.
IF M(#) MRCAT=CONCAT(RTRIM(MRCAT),STRING(#,N2)).
END LOOP.
LIST.

MR1 MR2 MR3 MR4 MR5 MR6 MR7 MR8 MR9 MR10 MRCAT

 0   0   1   1   0   1   1   1   0    1  030406070810
 1   1   1   0   1   1   0   1   1    0  01020305060809
 1   1   0   0   1   1   0   0   1    1  010205060910


David Marso wrote
>
> Please provide a very specific example of what the response pattern
> appears as in SPSS and what is required as output (are your source data
> numeric or strings, how wide etc...).  My thoughts are to conditionally
> concatenate the MR fields to a single string and output the result.
> Alternatively use the "power of 10" -or 100 as the case may be *YMMV after
> 10^16*.
> OTOH:  I must decline much further comment without the down and dirty re
> your data.
> COMPUTE result=0.
> DO REPEAT v=v1 TO v10.
> IF NOT MISSING (v) result=result*10+v.
> END REPEAT.
> --
>
>
> GauravSrivastava wrote
>>
>> Hi David,
>>
>> Thanks for your prompt reply. Let me brief you about floating data, may
>> be
>> it's not a right word which create confusion.
>> suppose I have a multi-response question with 1 to 10 categories and a
>> respondent answer 1,2,4,6,8th categories. with my below code I can
>> capture
>> the data in ASCII at 1st, 2nd, 4th, 6th and 8th column position for this
>> respondent.
>> Now I want to capture it straight at 1-5 column position without any
>> blank
>> (3rd and 5th in above case) which I am saying floating data.
>>
>> Hope this make it more clear. Please revert me ASAP.
>>
>> Regards,
>> Gaurav
>>
>> On Wed, Mar 28, 2012 at 4:22 PM, David Marso [via SPSSX Discussion] <
>> ml-node+s1045642n5600089h83@.nabble> wrote:
>>
>>> Perhaps you would be so kind and enlighten us to what you mean by a
>>> "floating data file"?
>>> I have never heard that particular expression before in 30 years of
>>> doing
>>> data analysis ;-).
>>> I am not even going to attempt to apply my incomparable ESPss intuitions
>>> to second guess.
>>> Note FWIW: SPSS respects the ancient FORTRAN record specifications in
>>> case
>>> it helps.
>>> What the following shall convey is that you can (and should) instruct
>>> SPSS
>>> to place *ANY* variable into *ANY* location you desire in the output
>>> file
>>> (Fd.w,A,N,X etc).
>>> DATA LIST FREE / A B C D (4F).
>>> BEGIN DATA
>>> 1 2 3 4
>>> end data
>>> STRING ALPHA (A8).
>>> COMPUTE alpha="abcdefgh".
>>> WRITE OUTFILE "C:\test1.txt"  /A B C D (4(F8.3,1X/)).
>>>    1.000
>>>    2.000
>>>    3.000
>>>    4.000
>>>
>>> WRITE OUTFILE "C:\test2.txt"  /A alpha B alpha C alpha D alpha
>>> (4(F8.3,1X,A8/)).
>>> EXE.
>>>
>>>    1.000 abcdefgh
>>>    2.000 abcdefgh
>>>    3.000 abcdefgh
>>>    4.000 abcdefgh
>>>
>>> WRITE OUTFILE "C:\test3.txt"  /A alpha B alpha C alpha D alpha
>>> (2(F8.3,1X,A8/N4,1X,A8/)).
>>> EXE.
>>>    1.000 abcdefgh
>>> 0002 abcdefgh
>>>    3.000 abcdefgh
>>> 0004 abcdefgh
>>>
>>> GauravSrivastava wrote
>>> Hi ALL,
>>>
>>> I am trying to convert the SPSS data into ASCII card data. I am using
>>> below code to convert it:
>>>
>>> GET FILE ='C:\Users\Gaurav S\Documents\Projects\Data Check\5687 - J&J
>>> Mega
>>> Tracker\Adult\HONGKONG\Data\p752065020_gsrivastava_20562058.sav'.
>>> WRITE OUTFILE = 'C:\Users\Gaurav S\Documents\Projects\Data Check\5687 -
>>> J&J Mega Tracker\Adult\HONGKONG\Data\DataCrd.dat'
>>>  RECORDS=10
>>>  /1 RespID 1-6 (N) '01' 7-8 R1 9 R2 10-11 (N) Respondent_ID 12-62 (A)
>>>  /2 RespID 1-6 (N) '02' 7-8 Q1 9 Q21 10 Q22 11 Q23 12 Q24 13
>>>  /3 RespID 1-6 (N) '03' 7-8 Data2 9-13 (comma,2)
>>>  /4 RespID 1-6 (N) '04' 7-8 R1_01 11-12(N) R1_02 13-14(N) R1_03 15-16(N)
>>> R1_04 17-18(N) R1_05 19-20(N)R1_06 21-22(N)R1_07 23-24(N)R1_08
>>> 25-26(N)R1_09 27-28(N)R1_10 29-30(N)R1_99 31-32(N).
>>>  Execute.
>>>
>>> It's working fine but it giving me a fixed width card ASCII data. I need
>>> the floating data file.
>>>
>>> Please help. I need it urgently.
>>>
>>> Regards,
>>> Gaurav
>>>
>>>
>>>
>>> ------------------------------
>>>  If you reply to this email, your message will be added to the
>>> discussion
>>> below:
>>>
>>> http://spssx-discussion.1045642.n5.nabble.com/SPSS-data-file-to-ASCII-card-data-file-tp5599936p5600089.html
>>>  To unsubscribe from SPSS data file to ASCII card data file, click
>>> here&lt;http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&amp;node=5599936&amp;code=c3JpdmFzdGdhdXJhdkBnbWFpbC5jb218NTU5OTkzNnwtMjExMDg3MDM5MQ==&gt;
>>> .
>>> NAML&lt;http://spssx-discussion.1045642.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&amp;id=instant_html%21nabble%3Aemail.naml&amp;base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml&gt;
>>>
>>
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-data-file-to-ASCII-card-data-file-tp5599936p5600222.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD