LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2012)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SPSSX-L page