help with 'get data' error
Locked
 
Banned User
|
CONTENTS DELETED
The author has deleted this message.
|
Re: help with 'get data' error
|
|
Eric,
I assume, perhaps incorrectly, that you wrote the get data syntax rather than going through the menu setup. I think your problem is that you have specified invalid variable names. Embedded blanks have not been allowed (but perhaps 17 is different)--and you have plenty of variable names like that. Change the embedded blank to underscore '_' and see if you get the same error. Gene Maguin >>I am writing syntax for SPSS to get data from a large txt file, and I receive the following error message. I'm using SPSS 17. Can anyone help me understand what I am missing? Thank you in advance. -Eric GET DATA /TYPE=TXT /FILE='C:\Users\Tara\Desktop\PNSS.txt' /FIXCASE=1 /ARRANGEMENT=FIXED /FIRSTCASE=1 /IMPORTCASE=ALL /VARIABLES= state 0-1 A2 V2 2-4 F3.0 V3 5-5 F1.0 V4 6-8 F3.0 V5 9-17 F9.0 V6 18-20 F3.0 V7 21-25 F5.0 V8 26-28 F3.0 V9 29-29 F1.0 V10 30-32 F3.0 V11 33-33 F1.0 V12 34-36 F3.0 V13 37-44 F8.0 V14 45-47 F3.0 V15 48-55 F8.0 V16 56-56 F1.0 V17 57-57 F1.0 V18 58-58 F1.0 V19 59-66 F8.0 V20 67-69 F3.0 Womens age 70-71 F2.0 V22 72-74 F3.0 Womens age RECODE 75-75 F1.0 V24 76-78 F3.0 Ethnic Code 79-80 F2.0 V26 81-83 F3.0 V27 84-89 F6.0 V28 90-92 F3.0 V29 93-95 F3.0 V30 96-98 F3.0 V31 99-100 F2.0 V32 101-103 F3.0 Marital Status 104-104 F1.0 V34 105-107 F3.0 Education 108-109 F2.0 V36 110-112 F3.0 Education RECODE 113-113 F1.0 V38 114-116 F3.0 Household Size 117-118 F2.0 V40 119-121 F3.0 Monthly household income 122-125 F4.0 V42 126-128 F3.0 Migrant Status 129-129 F1.0 V44 130-132 F3.0 WIC prenatal visit 133-133 F1.0 V46 134-136 F3.0 WIC postpartum visit 137-137 F1.0 V48 138-140 F3.0 V49 141-141 F1.0 V50 142-144 F3.0 V51 145-145 F1.0 V52 146-148 F3.0 Medicaid prenatal visit 149-149 F1.0 V54 150-152 F3.0 Medicaid Postpartum visit 153-153 F1.0 V56 154-156 F3.0 V57 157-157 F1.0 V58 158-160 F3.0 V59 161-161 F1.0 V60 162-164 F3.0 V61 165-172 F8.0 V62 173-175 F3.0 V63 176-184 F9.0 V64 185-187 F3.0 Height (inches) decimal 188-190 F3.0 V66 191-193 F3.0 V67 194-197 F4.0 V68 198-200 F3.0 Height metric (decimal) 201-204 F4.0 V70 205-207 F3.0 prepregnancy weight (lbs) 208-210 F3.0 V72 211-213 F3.0 prepregnancy weight (metric) RECODE 214-217 F4.0 V74 218-220 F3.0 Prepregnancy BMI (decimal) RECODE 1 221-223 F3.0 V76 224-226 F3.0 Prepregnancy BMI (RECODE 2) 227-227 F1.0 V78 228-230 F3.0 V79 231-234 F4.0 V80 235-237 F3.0 V81 238-241 F4.0 V82 242-244 F3.0 V83 245-248 F4.0 V84 249-251 F3.0 V85 252-254 F3.0 V86 255-257 F3.0 V87 258-258 F1.0 V88 259-261 F3.0 V89 262-265 F4.0 V90 266-268 F3.0 V91 269-272 F4.0 V92 273-275 F3.0 V93 276-279 F4.0 V94 280-282 F3.0 V95 283-285 F3.0 V96 286-288 F3.0 V97 289-289 F1.0 V98 290-292 F3.0 weight gain sign 293-293 A1 V100 294-296 F3.0 total weight gain 297-298 F2.0 V102 299-301 F3.0 Ideal weight gain RECODE 302-302 F1.0 V104 303-305 F3.0 V105 306-308 F3.0 V106 309-311 F3.0 V107 312-314 F3.0 V108 315-317 F3.0 V109 318-325 F8.0 V110 326-328 F3.0 V111 329-329 F1.0 V112 330-332 F3.0 V113 333-335 F3.0 V114 336-338 F3.0 V115 339-341 F3.0 V116 342-344 F3.0 V117 345-352 F8.0 V118 353-355 F3.0 V119 356-359 F4.0 V120 360-362 F3.0 Previous Pregnancies 363-364 F2.0 V122 365-367 F3.0 Parity 368-369 F2.0 V124 370-372 F3.0 Date last pregnancy ended 373-380 F8.0 V126 381-383 F3.0 Gestational diabetes (postpartum) 384-384 F1.0 V128 385-387 F3.0 gestational hypertension (postpartum) 388-388 F1.0 V130 389-391 F3.0 Medical care began 392-392 F1.0 V132 393-395 F3.0 medical care began RECODE 396-396 F1.0 V134 397-399 F3.0 V135 400-407 F8.0 V136 408-410 F3.0 Trimester Date Enrolled 411-411 F1.0 V138 412-414 F3.0 multivitamin consumption prior to pregnancy 415-415 F1.0 V140 416-418 F3.0 multivitamin consumption during pregnancy 419-419 F1.0 V142 420-422 F3.0 cigarettes/day- 3 months prior to pregnancy 423-424 F2.0 V144 425-427 F3.0 cigarettes per day prenatal visit 428-429 F2.0 V146 430-432 F3.0 cigarettes per day- last 3 months of pregnancy 433-434 F2.0 V148 435-437 F3.0 V149 438-439 F2.0 V150 440-442 F3.0 smoking changes prenatal visit 443-443 F1.0 V152 444-446 F3.0 smoking changs postpartum visit 447-447 F1.0 V154 448-450 F3.0 V155 451-451 F1.0 V156 452-454 F3.0 V157 455-455 F1.0 V158 456-458 F3.0 V159 459-460 F2.0 V160 461-463 F3.0 V161 464-465 F2.0 V162 466-468 F3.0 V163 469-470 F2.0 V164 471-473 F3.0 V165 474-475 F2.0 V166 476-478 F3.0 V167 479-486 F8.0 V168 487-489 F3.0 V169 490-495 F6.0 V170 496-498 F3.0 Gestational age RECODE 499-501 F3.0 V172 502-504 F3.0 Number of Infants 505-505 F1.0 V174 506-508 F3.0 Baby Sex 509-509 F1.0 V176 510-512 F3.0 Born alive or dead 513-513 F1.0 V178 514-516 F3.0 Alive or dead postpartum visit 517-517 F1.0 V180 518-520 F3.0 birthweight Metric 521-524 F4.0 V182 525-527 F3.0 V183 528-531 F4.0 V184 532-534 F3.0 V185 535-538 F4.0 V186 539-541 F3.0 V187 542-601 A60 V188 602-604 F3.0 V189 605-612 A8 V190 613-621 A9 V191 622-624 A3 V192 625-627 F3.0 V193 628-630 A3 V194 631-631 F1.0 V195 632-634 F3.0 V196 635-635 F1.0 V197 636-638 A3 V198 639-639 F1.0 V199 640-642 F3.0 V200 643-643 F1.0 V201 644-646 F3.0 V202 647-650 A4 V203 651-653 F3.0 V204 654-657 F4.0 V205 658-660 F3.0 V206 661-664 F4.0 V207 665-667 F3.0 V208 668-668 F1.0 V209 669-671 F3.0 V210 672-672 F1.0 V211 673-675 F3.0 V212 676-676 F1.0 V213 677-678 F2.0 V214 679-679 F1.0 V215 680-680 F1.0 V216 681-683 F3.0 V217 684-691 F8.0 V218 692-694 F3.0 V219 695-697 F3.0 V220 698-700 F3.0 V221 701-703 F3.0 V222 704-706 F3.0 V223 707-709 F3.0 V224 710-712 F3.0 V225 713-715 F3.0 V226 716-716 F1.0 V227 717-718 F2.0. CACHE. EXECUTE. DATASET NAME DataSet2 WINDOW=FRONT. Error. Command name: GET DATA (2265) Unrecognized or invalid variable definition. This command not executed. CACHE. EXECUTE. Error # 105. Command name: EXECUTE This command is not valid before a working file has been defined. This command not executed. DATASET NAME DataSet2 WINDOW=FRONT. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
|
|
In reply to this post by Buhi, Eric
Eric: It looks like you have a mixture of variable labels mixed in
with variable names. E.G. Womens
age 70-71 F2.0 This looks like the label for V21. It is being read as the
name for variable, but “Womens age” is invalid. Spaces are
not allowed in variable names. Try editing the syntax to use valid variable names. You
can add the variable labels afterwards. --jim From: SPSSX(r) Discussion
[mailto:[hidden email]] On Behalf Of Buhi, Eric Hi, I
am writing syntax for SPSS to get data from a large txt file, and I receive the
following error message. I'm using SPSS 17. Can anyone help me understand what
I am missing? Thank
you in advance. -Eric GET DATA Error. Command
name: GET DATA (2265) Unrecognized
or invalid variable definition. This command not
executed. CACHE. EXECUTE. Error # 105.
Command name: EXECUTE This command is not
valid before a working file has been defined. This command not
executed. DATASET NAME
DataSet2 WINDOW=FRONT. |
|
|
In reply to this post by Maguin, Eugene
That, and I think you are limited to 8 characters in a variable NAME,
unless that has changed recently. It does not say that in the Help file, but none of the variables names in the example are greater than 8 characters. It seems like you have variable names and "labels" on the input command set of variables. You go along with the standard V1, V2, V3,... V20, and then instead of the expected V21 there is Womans age. Then this happens with other variables periodically, where V41, V43, V45 etc. might be expected. I'd put in the missing Vxx, variable names and then write Variable Labels to say what they are about if that is desired.. FWIW. Cheers, Necia A. Black, Ph.D. e-mail: [hidden email] 246 Computing Center Web URL:http://www.acsu.buffalo.edu/~black SUNY-Buffalo Buffalo, New York 14260 On Wed, 15 Apr 2009, Gene Maguin wrote: > Eric, > > I assume, perhaps incorrectly, that you wrote the get data syntax rather > than going through the menu setup. I think your problem is that you have > specified invalid variable names. Embedded blanks have not been allowed (but > perhaps 17 is different)--and you have plenty of variable names like that. > Change the embedded blank to underscore '_' and see if you get the same > error. > > Gene Maguin > > >>> I am writing syntax for SPSS to get data from a large txt file, and I > receive the following error message. I'm using SPSS 17. Can anyone help me > understand what I am missing? > > Thank you in advance. > > -Eric > > GET DATA > /TYPE=TXT > /FILE='C:\Users\Tara\Desktop\PNSS.txt' > /FIXCASE=1 > /ARRANGEMENT=FIXED > /FIRSTCASE=1 > /IMPORTCASE=ALL > /VARIABLES= > state 0-1 A2 > V2 2-4 F3.0 > V3 5-5 F1.0 > V4 6-8 F3.0 > V5 9-17 F9.0 > V6 18-20 F3.0 > V7 21-25 F5.0 > V8 26-28 F3.0 > V9 29-29 F1.0 > V10 30-32 F3.0 > V11 33-33 F1.0 > V12 34-36 F3.0 > V13 37-44 F8.0 > V14 45-47 F3.0 > V15 48-55 F8.0 > V16 56-56 F1.0 > V17 57-57 F1.0 > V18 58-58 F1.0 > V19 59-66 F8.0 > V20 67-69 F3.0 > Womens age 70-71 F2.0 > V22 72-74 F3.0 > Womens age RECODE 75-75 F1.0 > V24 76-78 F3.0 > Ethnic Code 79-80 F2.0 > V26 81-83 F3.0 > V27 84-89 F6.0 > V28 90-92 F3.0 > V29 93-95 F3.0 > V30 96-98 F3.0 > V31 99-100 F2.0 > V32 101-103 F3.0 > Marital Status 104-104 F1.0 > V34 105-107 F3.0 > Education 108-109 F2.0 > V36 110-112 F3.0 > Education RECODE 113-113 F1.0 > V38 114-116 F3.0 > Household Size 117-118 F2.0 > V40 119-121 F3.0 > Monthly household income 122-125 F4.0 > V42 126-128 F3.0 > Migrant Status 129-129 F1.0 > V44 130-132 F3.0 > WIC prenatal visit 133-133 F1.0 > V46 134-136 F3.0 > WIC postpartum visit 137-137 F1.0 > V48 138-140 F3.0 > V49 141-141 F1.0 > V50 142-144 F3.0 > V51 145-145 F1.0 > V52 146-148 F3.0 > Medicaid prenatal visit 149-149 F1.0 > V54 150-152 F3.0 > Medicaid Postpartum visit 153-153 F1.0 > V56 154-156 F3.0 > V57 157-157 F1.0 > V58 158-160 F3.0 > V59 161-161 F1.0 > V60 162-164 F3.0 > V61 165-172 F8.0 > V62 173-175 F3.0 > V63 176-184 F9.0 > V64 185-187 F3.0 > Height (inches) decimal 188-190 F3.0 > V66 191-193 F3.0 > V67 194-197 F4.0 > V68 198-200 F3.0 > Height metric (decimal) 201-204 F4.0 > V70 205-207 F3.0 > prepregnancy weight (lbs) 208-210 F3.0 > V72 211-213 F3.0 > prepregnancy weight (metric) RECODE 214-217 F4.0 > V74 218-220 F3.0 > Prepregnancy BMI (decimal) RECODE 1 221-223 F3.0 > V76 224-226 F3.0 > Prepregnancy BMI (RECODE 2) 227-227 F1.0 > V78 228-230 F3.0 > V79 231-234 F4.0 > V80 235-237 F3.0 > V81 238-241 F4.0 > V82 242-244 F3.0 > V83 245-248 F4.0 > V84 249-251 F3.0 > V85 252-254 F3.0 > V86 255-257 F3.0 > V87 258-258 F1.0 > V88 259-261 F3.0 > V89 262-265 F4.0 > V90 266-268 F3.0 > V91 269-272 F4.0 > V92 273-275 F3.0 > V93 276-279 F4.0 > V94 280-282 F3.0 > V95 283-285 F3.0 > V96 286-288 F3.0 > V97 289-289 F1.0 > V98 290-292 F3.0 > weight gain sign 293-293 A1 > V100 294-296 F3.0 > total weight gain 297-298 F2.0 > V102 299-301 F3.0 > Ideal weight gain RECODE 302-302 F1.0 > V104 303-305 F3.0 > V105 306-308 F3.0 > V106 309-311 F3.0 > V107 312-314 F3.0 > V108 315-317 F3.0 > V109 318-325 F8.0 > V110 326-328 F3.0 > V111 329-329 F1.0 > V112 330-332 F3.0 > V113 333-335 F3.0 > V114 336-338 F3.0 > V115 339-341 F3.0 > V116 342-344 F3.0 > V117 345-352 F8.0 > V118 353-355 F3.0 > V119 356-359 F4.0 > V120 360-362 F3.0 > Previous Pregnancies 363-364 F2.0 > V122 365-367 F3.0 > Parity 368-369 F2.0 > V124 370-372 F3.0 > Date last pregnancy ended 373-380 F8.0 > V126 381-383 F3.0 > Gestational diabetes (postpartum) 384-384 F1.0 > V128 385-387 F3.0 > gestational hypertension (postpartum) 388-388 F1.0 > V130 389-391 F3.0 > Medical care began 392-392 F1.0 > V132 393-395 F3.0 > medical care began RECODE 396-396 F1.0 > V134 397-399 F3.0 > V135 400-407 F8.0 > V136 408-410 F3.0 > Trimester Date Enrolled 411-411 F1.0 > V138 412-414 F3.0 > multivitamin consumption prior to pregnancy 415-415 F1.0 > V140 416-418 F3.0 > multivitamin consumption during pregnancy 419-419 F1.0 > V142 420-422 F3.0 > cigarettes/day- 3 months prior to pregnancy 423-424 F2.0 > V144 425-427 F3.0 > cigarettes per day prenatal visit 428-429 F2.0 > V146 430-432 F3.0 > cigarettes per day- last 3 months of pregnancy 433-434 F2.0 > V148 435-437 F3.0 > V149 438-439 F2.0 > V150 440-442 F3.0 > smoking changes prenatal visit 443-443 F1.0 > V152 444-446 F3.0 > smoking changs postpartum visit 447-447 F1.0 > V154 448-450 F3.0 > V155 451-451 F1.0 > V156 452-454 F3.0 > V157 455-455 F1.0 > V158 456-458 F3.0 > V159 459-460 F2.0 > V160 461-463 F3.0 > V161 464-465 F2.0 > V162 466-468 F3.0 > V163 469-470 F2.0 > V164 471-473 F3.0 > V165 474-475 F2.0 > V166 476-478 F3.0 > V167 479-486 F8.0 > V168 487-489 F3.0 > V169 490-495 F6.0 > V170 496-498 F3.0 > Gestational age RECODE 499-501 F3.0 > V172 502-504 F3.0 > Number of Infants 505-505 F1.0 > V174 506-508 F3.0 > Baby Sex 509-509 F1.0 > V176 510-512 F3.0 > Born alive or dead 513-513 F1.0 > V178 514-516 F3.0 > Alive or dead postpartum visit 517-517 F1.0 > V180 518-520 F3.0 > birthweight Metric 521-524 F4.0 > V182 525-527 F3.0 > V183 528-531 F4.0 > V184 532-534 F3.0 > V185 535-538 F4.0 > V186 539-541 F3.0 > V187 542-601 A60 > V188 602-604 F3.0 > V189 605-612 A8 > V190 613-621 A9 > V191 622-624 A3 > V192 625-627 F3.0 > V193 628-630 A3 > V194 631-631 F1.0 > V195 632-634 F3.0 > V196 635-635 F1.0 > V197 636-638 A3 > V198 639-639 F1.0 > V199 640-642 F3.0 > V200 643-643 F1.0 > V201 644-646 F3.0 > V202 647-650 A4 > V203 651-653 F3.0 > V204 654-657 F4.0 > V205 658-660 F3.0 > V206 661-664 F4.0 > V207 665-667 F3.0 > V208 668-668 F1.0 > V209 669-671 F3.0 > V210 672-672 F1.0 > V211 673-675 F3.0 > V212 676-676 F1.0 > V213 677-678 F2.0 > V214 679-679 F1.0 > V215 680-680 F1.0 > V216 681-683 F3.0 > V217 684-691 F8.0 > V218 692-694 F3.0 > V219 695-697 F3.0 > V220 698-700 F3.0 > V221 701-703 F3.0 > V222 704-706 F3.0 > V223 707-709 F3.0 > V224 710-712 F3.0 > V225 713-715 F3.0 > V226 716-716 F1.0 > V227 717-718 F2.0. > CACHE. > EXECUTE. > DATASET NAME DataSet2 WINDOW=FRONT. > > > > Error. Command name: GET DATA > > (2265) Unrecognized or invalid variable definition. > > This command not executed. > > CACHE. > > EXECUTE. > > Error # 105. Command name: EXECUTE > > This command is not valid before a working file has been defined. > > This command not executed. > > DATASET NAME DataSet2 WINDOW=FRONT. > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (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 > > > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
Re: help with 'get data' error
|
|
Variable names can be up to 64 bytes long. In English, 64 bytes is usually 64 characters. I think the limit was raised from 8 to 64 in release 12.
You are correct that variable names cannot contain blanks. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of necia Sent: Wednesday, April 15, 2009 12:00 PM To: [hidden email] Subject: Re: help with 'get data' error That, and I think you are limited to 8 characters in a variable NAME, unless that has changed recently. It does not say that in the Help file, but none of the variables names in the example are greater than 8 characters. It seems like you have variable names and "labels" on the input command set of variables. You go along with the standard V1, V2, V3,... V20, and then instead of the expected V21 there is Womans age. Then this happens with other variables periodically, where V41, V43, V45 etc. might be expected. I'd put in the missing Vxx, variable names and then write Variable Labels to say what they are about if that is desired.. FWIW. Cheers, Necia A. Black, Ph.D. e-mail: [hidden email] 246 Computing Center Web URL:http://www.acsu.buffalo.edu/~black SUNY-Buffalo Buffalo, New York 14260 On Wed, 15 Apr 2009, Gene Maguin wrote: > Eric, > > I assume, perhaps incorrectly, that you wrote the get data syntax rather > than going through the menu setup. I think your problem is that you have > specified invalid variable names. Embedded blanks have not been allowed (but > perhaps 17 is different)--and you have plenty of variable names like that. > Change the embedded blank to underscore '_' and see if you get the same > error. > > Gene Maguin > > >>> I am writing syntax for SPSS to get data from a large txt file, and I > receive the following error message. I'm using SPSS 17. Can anyone help me > understand what I am missing? > > Thank you in advance. > > -Eric > > GET DATA > /TYPE=TXT > /FILE='C:\Users\Tara\Desktop\PNSS.txt' > /FIXCASE=1 > /ARRANGEMENT=FIXED > /FIRSTCASE=1 > /IMPORTCASE=ALL > /VARIABLES= > state 0-1 A2 > V2 2-4 F3.0 > V3 5-5 F1.0 > V4 6-8 F3.0 > V5 9-17 F9.0 > V6 18-20 F3.0 > V7 21-25 F5.0 > V8 26-28 F3.0 > V9 29-29 F1.0 > V10 30-32 F3.0 > V11 33-33 F1.0 > V12 34-36 F3.0 > V13 37-44 F8.0 > V14 45-47 F3.0 > V15 48-55 F8.0 > V16 56-56 F1.0 > V17 57-57 F1.0 > V18 58-58 F1.0 > V19 59-66 F8.0 > V20 67-69 F3.0 > Womens age 70-71 F2.0 > V22 72-74 F3.0 > Womens age RECODE 75-75 F1.0 > V24 76-78 F3.0 > Ethnic Code 79-80 F2.0 > V26 81-83 F3.0 > V27 84-89 F6.0 > V28 90-92 F3.0 > V29 93-95 F3.0 > V30 96-98 F3.0 > V31 99-100 F2.0 > V32 101-103 F3.0 > Marital Status 104-104 F1.0 > V34 105-107 F3.0 > Education 108-109 F2.0 > V36 110-112 F3.0 > Education RECODE 113-113 F1.0 > V38 114-116 F3.0 > Household Size 117-118 F2.0 > V40 119-121 F3.0 > Monthly household income 122-125 F4.0 > V42 126-128 F3.0 > Migrant Status 129-129 F1.0 > V44 130-132 F3.0 > WIC prenatal visit 133-133 F1.0 > V46 134-136 F3.0 > WIC postpartum visit 137-137 F1.0 > V48 138-140 F3.0 > V49 141-141 F1.0 > V50 142-144 F3.0 > V51 145-145 F1.0 > V52 146-148 F3.0 > Medicaid prenatal visit 149-149 F1.0 > V54 150-152 F3.0 > Medicaid Postpartum visit 153-153 F1.0 > V56 154-156 F3.0 > V57 157-157 F1.0 > V58 158-160 F3.0 > V59 161-161 F1.0 > V60 162-164 F3.0 > V61 165-172 F8.0 > V62 173-175 F3.0 > V63 176-184 F9.0 > V64 185-187 F3.0 > Height (inches) decimal 188-190 F3.0 > V66 191-193 F3.0 > V67 194-197 F4.0 > V68 198-200 F3.0 > Height metric (decimal) 201-204 F4.0 > V70 205-207 F3.0 > prepregnancy weight (lbs) 208-210 F3.0 > V72 211-213 F3.0 > prepregnancy weight (metric) RECODE 214-217 F4.0 > V74 218-220 F3.0 > Prepregnancy BMI (decimal) RECODE 1 221-223 F3.0 > V76 224-226 F3.0 > Prepregnancy BMI (RECODE 2) 227-227 F1.0 > V78 228-230 F3.0 > V79 231-234 F4.0 > V80 235-237 F3.0 > V81 238-241 F4.0 > V82 242-244 F3.0 > V83 245-248 F4.0 > V84 249-251 F3.0 > V85 252-254 F3.0 > V86 255-257 F3.0 > V87 258-258 F1.0 > V88 259-261 F3.0 > V89 262-265 F4.0 > V90 266-268 F3.0 > V91 269-272 F4.0 > V92 273-275 F3.0 > V93 276-279 F4.0 > V94 280-282 F3.0 > V95 283-285 F3.0 > V96 286-288 F3.0 > V97 289-289 F1.0 > V98 290-292 F3.0 > weight gain sign 293-293 A1 > V100 294-296 F3.0 > total weight gain 297-298 F2.0 > V102 299-301 F3.0 > Ideal weight gain RECODE 302-302 F1.0 > V104 303-305 F3.0 > V105 306-308 F3.0 > V106 309-311 F3.0 > V107 312-314 F3.0 > V108 315-317 F3.0 > V109 318-325 F8.0 > V110 326-328 F3.0 > V111 329-329 F1.0 > V112 330-332 F3.0 > V113 333-335 F3.0 > V114 336-338 F3.0 > V115 339-341 F3.0 > V116 342-344 F3.0 > V117 345-352 F8.0 > V118 353-355 F3.0 > V119 356-359 F4.0 > V120 360-362 F3.0 > Previous Pregnancies 363-364 F2.0 > V122 365-367 F3.0 > Parity 368-369 F2.0 > V124 370-372 F3.0 > Date last pregnancy ended 373-380 F8.0 > V126 381-383 F3.0 > Gestational diabetes (postpartum) 384-384 F1.0 > V128 385-387 F3.0 > gestational hypertension (postpartum) 388-388 F1.0 > V130 389-391 F3.0 > Medical care began 392-392 F1.0 > V132 393-395 F3.0 > medical care began RECODE 396-396 F1.0 > V134 397-399 F3.0 > V135 400-407 F8.0 > V136 408-410 F3.0 > Trimester Date Enrolled 411-411 F1.0 > V138 412-414 F3.0 > multivitamin consumption prior to pregnancy 415-415 F1.0 > V140 416-418 F3.0 > multivitamin consumption during pregnancy 419-419 F1.0 > V142 420-422 F3.0 > cigarettes/day- 3 months prior to pregnancy 423-424 F2.0 > V144 425-427 F3.0 > cigarettes per day prenatal visit 428-429 F2.0 > V146 430-432 F3.0 > cigarettes per day- last 3 months of pregnancy 433-434 F2.0 > V148 435-437 F3.0 > V149 438-439 F2.0 > V150 440-442 F3.0 > smoking changes prenatal visit 443-443 F1.0 > V152 444-446 F3.0 > smoking changs postpartum visit 447-447 F1.0 > V154 448-450 F3.0 > V155 451-451 F1.0 > V156 452-454 F3.0 > V157 455-455 F1.0 > V158 456-458 F3.0 > V159 459-460 F2.0 > V160 461-463 F3.0 > V161 464-465 F2.0 > V162 466-468 F3.0 > V163 469-470 F2.0 > V164 471-473 F3.0 > V165 474-475 F2.0 > V166 476-478 F3.0 > V167 479-486 F8.0 > V168 487-489 F3.0 > V169 490-495 F6.0 > V170 496-498 F3.0 > Gestational age RECODE 499-501 F3.0 > V172 502-504 F3.0 > Number of Infants 505-505 F1.0 > V174 506-508 F3.0 > Baby Sex 509-509 F1.0 > V176 510-512 F3.0 > Born alive or dead 513-513 F1.0 > V178 514-516 F3.0 > Alive or dead postpartum visit 517-517 F1.0 > V180 518-520 F3.0 > birthweight Metric 521-524 F4.0 > V182 525-527 F3.0 > V183 528-531 F4.0 > V184 532-534 F3.0 > V185 535-538 F4.0 > V186 539-541 F3.0 > V187 542-601 A60 > V188 602-604 F3.0 > V189 605-612 A8 > V190 613-621 A9 > V191 622-624 A3 > V192 625-627 F3.0 > V193 628-630 A3 > V194 631-631 F1.0 > V195 632-634 F3.0 > V196 635-635 F1.0 > V197 636-638 A3 > V198 639-639 F1.0 > V199 640-642 F3.0 > V200 643-643 F1.0 > V201 644-646 F3.0 > V202 647-650 A4 > V203 651-653 F3.0 > V204 654-657 F4.0 > V205 658-660 F3.0 > V206 661-664 F4.0 > V207 665-667 F3.0 > V208 668-668 F1.0 > V209 669-671 F3.0 > V210 672-672 F1.0 > V211 673-675 F3.0 > V212 676-676 F1.0 > V213 677-678 F2.0 > V214 679-679 F1.0 > V215 680-680 F1.0 > V216 681-683 F3.0 > V217 684-691 F8.0 > V218 692-694 F3.0 > V219 695-697 F3.0 > V220 698-700 F3.0 > V221 701-703 F3.0 > V222 704-706 F3.0 > V223 707-709 F3.0 > V224 710-712 F3.0 > V225 713-715 F3.0 > V226 716-716 F1.0 > V227 717-718 F2.0. > CACHE. > EXECUTE. > DATASET NAME DataSet2 WINDOW=FRONT. > > > > Error. Command name: GET DATA > > (2265) Unrecognized or invalid variable definition. > > This command not executed. > > CACHE. > > EXECUTE. > > Error # 105. Command name: EXECUTE > > This command is not valid before a working file has been defined. > > This command not executed. > > DATASET NAME DataSet2 WINDOW=FRONT. > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (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 > > > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (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 |
|
|
In reply to this post by Buhi, Eric
Hello,
Earlier today my professor sent a question to this listserve asking about a 'get data' error. This is actually for a secondary analysis project I am working on. I took the advice that was sent out to
me to change the variable names but unfortunately it hasn't worked. I'm hoping someone can help me out. I am using SPSS 17.0. I did not put this syntax in myself it if a result of the command tree that I went through to sort the data fields. The data came
from a txt. file but the fields were not defined. I had to put lines in to define the fields.
Here is the syntax and the error code I get.
GET DATA
TYPE=TXT. FILE='C:\Users\Tara\Desktop\PNSS.txt'. FIXCASE=1. ARRANGEMENT=FIXED. FIRSTCASE=1. IMPORTCASE=ALL. /VARIABLES= V1 0-1 A2 V2 2-4 F3.0 V3 5-5 F1.0 V4 6-8 F3.0 V5 9-17 F9.0 V6 18-20 F3.0 V7 21-25 F5.0 V8 26-28 F3.0 V9 29-29 F1.0 V10 30-32 F3.0 V11 33-33 F1.0 V12 34-36 F3.0 V13 37-44 F8.0 V14 45-47 F3.0 V15 48-55 F8.0 V16 56-56 F1.0 V17 57-57 F1.0 V18 58-58 F1.0 V19 59-66 F8.0 V20 67-69 F3.0 V21 70-71 F2.0 V22 72-74 F3.0 V23 75-75 F1.0 V24 76-78 F3.0 V25 79-80 F2.0 V26 81-83 F3.0 V27 84-89 F6.0 V28 90-92 F3.0 V29 93-95 F3.0 V30 96-98 F3.0 V31 99-100 F2.0 V32 101-103 F3.0 V33 104-104 F1.0 V34 105-107 F3.0 V35 108-109 F2.0 V36 110-112 F3.0 V37 113-113 F1.0 V38 114-116 F3.0 V39 117-118 F2.0 V40 119-121 F3.0 V41 122-125 F4.0 V42 126-128 F3.0 V43 129-129 F1.0 V44 130-132 F3.0 V45 133-133 F1.0 V46 134-136 F3.0 V47 137-137 F1.0 V48 138-140 F3.0 V49 141-141 F1.0 V50 142-144 F3.0 V51 145-145 F1.0 V52 146-148 F3.0 V53 149-149 F1.0 V54 150-152 F3.0 V55 153-153 F1.0 V56 154-156 F3.0 V57 157-157 F1.0 V58 158-160 F3.0 V59 161-161 F1.0 V60 162-164 F3.0 V61 165-172 F8.0 V62 173-175 F3.0 V63 176-184 F9.0 V64 185-187 F3.0 V65 188-190 F3.0 V66 191-193 F3.0 V67 194-197 F4.0 V68 198-200 F3.0 V69 201-204 F4.0 V70 205-207 F3.0 V71 208-210 F3.0 V72 211-213 F3.0 V73 214-217 F4.0 V74 218-220 F3.0 V75 221-223 F3.0 V76 224-226 F3.0 V77 227-227 F1.0 V78 228-230 F3.0 V79 231-234 F4.0 V80 235-237 F3.0 V81 238-241 F4.0 V82 242-244 F3.0 V83 245-248 F4.0 V84 249-251 F3.0 V85 252-254 F3.0 V86 255-257 F3.0 V87 258-258 F1.0 V88 259-261 F3.0 V89 262-265 F4.0 V90 266-268 F3.0 V91 269-272 F4.0 V92 273-275 F3.0 V93 276-279 F4.0 V94 280-282 F3.0 V95 283-285 F3.0 V96 286-288 F3.0 V97 289-289 F1.0 V98 290-292 F3.0 V99 293-293 A1 V100 294-296 F3.0 V101 297-298 F2.0 V102 299-301 F3.0 V103 302-302 F1.0 V104 303-305 F3.0 V105 306-308 F3.0 V106 309-311 F3.0 V107 312-314 F3.0 V108 315-317 F3.0 V109 318-325 F8.0 V110 326-328 F3.0 V111 329-329 F1.0 V112 330-332 F3.0 V113 333-335 F3.0 V114 336-338 F3.0 V115 339-341 F3.0 V116 342-344 F3.0 V117 345-352 F8.0 V118 353-355 F3.0 V119 356-359 F4.0 V120 360-362 F3.0 V121 363-364 F2.0 V122 365-367 F3.0 V123 368-369 F2.0 V124 370-372 F3.0 V125 373-380 F8.0 V126 381-383 F3.0 V127 384-384 F1.0 V128 385-387 F3.0 V129 388-388 F1.0 V130 389-391 F3.0 V131 392-392 F1.0 V132 393-395 F3.0 V133 396-396 F1.0 V134 397-399 F3.0 V135 400-407 F8.0 V136 408-410 F3.0 V137 411-411 F1.0 V138 412-414 F3.0 V139 415-415 F1.0 V140 416-418 F3.0 V141 419-419 F1.0 V142 420-422 F3.0 V143 423-424 F2.0 V144 425-427 F3.0 V145 428-429 F2.0 V146 430-432 F3.0 V147 433-434 F2.0 V148 435-437 F3.0 V149 438-439 F2.0 V150 440-442 F3.0 V151 443-443 F1.0 V152 444-446 F3.0 V153 447-447 F1.0 V154 448-450 F3.0 V155 451-451 F1.0 V156 452-454 F3.0 V157 455-455 F1.0 V158 456-458 F3.0 V159 459-460 F2.0 V160 461-463 F3.0 V161 464-465 F2.0 V162 466-468 F3.0 V163 469-470 F2.0 V164 471-473 F3.0 V165 474-475 F2.0 V166 476-478 F3.0 V167 479-486 F8.0 V168 487-489 F3.0 V169 490-495 F6.0 V170 496-498 F3.0 V171 499-501 F3.0 V172 502-504 F3.0 V173 505-505 F1.0 V174 506-508 F3.0 V175 509-509 F1.0 V176 510-512 F3.0 V176 513-513 F1.0 V178 514-516 F3.0 V179 517-517 F1.0 V180 518-520 F3.0 V181 521-524 F4.0 V182 525-527 F3.0 V183 528-531 F4.0 V184 532-534 F3.0 V185 535-538 F4.0 V186 539-541 F3.0 V187 542-601 A60 V188 602-604 F3.0 V189 605-612 A8 V190 613-621 A9 V191 622-624 A3 V192 625-627 F3.0 V193 628-630 A3 V194 631-631 F1.0 V195 632-634 F3.0 V196 635-635 F1.0 V197 636-638 A3 V198 639-639 F1.0 V199 640-642 F3.0 V200 643-643 F1.0 V201 644-646 F3.0 V202 647-650 A4 V203 651-653 F3.0 V204 654-657 F4.0 V205 658-660 F3.0 V206 661-664 F4.0 V207 665-667 F3.0 V208 668-668 F1.0 V209 669-671 F3.0 V210 672-672 F1.0 V211 673-675 F3.0 V212 676-676 F1.0 V213 677-678 F2.0 V214 679-679 F1.0 V215 680-680 F1.0 V216 681-683 F3.0 V217 684-691 F8.0 V218 692-694 F3.0 V219 695-697 F3.0 V220 698-700 F3.0 V221 701-703 F3.0 V222 704-706 F3.0 V223 707-709 F3.0 V224 710-712 F3.0 V225 713-715 F3.0 V226 716-716 F1.0 V227 717-718 F2.0. CACHE. EXECUTE. DATASET NAME PNSS WINDOW=FRONT. Error #105. Command name: Execute
This command is not valid before a working file has been defined.
This command not executed.
DATASET NAME PNSS WINDOW=FRONT.
Thank you for your help!
Tara
Tara Trudnak, MPH, CPH
Doctoral Student
Department of Community and Family Health
College of Public Health
University of South Florida
|
Re: help with 'get data' error
|
|
For starters, remove all the periods at the ends of lines in the GET DATA command. A period at the end of a line is interpreted as a command terminator. From: SPSSX(r) Discussion on behalf of Trudnak, Tara Sent: Wed 4/15/2009 9:25 PM To: [hidden email] Subject: help with 'get data' error Hello,
Earlier today my professor sent a question to this listserve asking about a 'get data' error. This is actually for a secondary analysis project I am working on. I took the advice that was sent out to me to change the variable names but unfortunately it hasn't worked. I'm hoping someone can help me out. I am using SPSS 17.0. I did not put this syntax in myself it if a result of the command tree that I went through to sort the data fields. The data came from a txt. file but the fields were not defined. I had to put lines in to define the fields.
Here is the syntax and the error code I get.
GET DATA
TYPE=TXT. FILE='C:\Users\Tara\Desktop\PNSS.txt'. FIXCASE=1. ARRANGEMENT=FIXED. FIRSTCASE=1. IMPORTCASE=ALL. /VARIABLES= V1 0-1 A2 V2 2-4 F3.0 V3 5-5 F1.0 V4 6-8 F3.0 V5 9-17 F9.0 V6 18-20 F3.0 V7 21-25 F5.0 V8 26-28 F3.0 V9 29-29 F1.0 V10 30-32 F3.0 V11 33-33 F1.0 V12 34-36 F3.0 V13 37-44 F8.0 V14 45-47 F3.0 V15 48-55 F8.0 V16 56-56 F1.0 V17 57-57 F1.0 V18 58-58 F1.0 V19 59-66 F8.0 V20 67-69 F3.0 V21 70-71 F2.0 V22 72-74 F3.0 V23 75-75 F1.0 V24 76-78 F3.0 V25 79-80 F2.0 V26 81-83 F3.0 V27 84-89 F6.0 V28 90-92 F3.0 V29 93-95 F3.0 V30 96-98 F3.0 V31 99-100 F2.0 V32 101-103 F3.0 V33 104-104 F1.0 V34 105-107 F3.0 V35 108-109 F2.0 V36 110-112 F3.0 V37 113-113 F1.0 V38 114-116 F3.0 V39 117-118 F2.0 V40 119-121 F3.0 V41 122-125 F4.0 V42 126-128 F3.0 V43 129-129 F1.0 V44 130-132 F3.0 V45 133-133 F1.0 V46 134-136 F3.0 V47 137-137 F1.0 V48 138-140 F3.0 V49 141-141 F1.0 V50 142-144 F3.0 V51 145-145 F1.0 V52 146-148 F3.0 V53 149-149 F1.0 V54 150-152 F3.0 V55 153-153 F1.0 V56 154-156 F3.0 V57 157-157 F1.0 V58 158-160 F3.0 V59 161-161 F1.0 V60 162-164 F3.0 V61 165-172 F8.0 V62 173-175 F3.0 V63 176-184 F9.0 V64 185-187 F3.0 V65 188-190 F3.0 V66 191-193 F3.0 V67 194-197 F4.0 V68 198-200 F3.0 V69 201-204 F4.0 V70 205-207 F3.0 V71 208-210 F3.0 V72 211-213 F3.0 V73 214-217 F4.0 V74 218-220 F3.0 V75 221-223 F3.0 V76 224-226 F3.0 V77 227-227 F1.0 V78 228-230 F3.0 V79 231-234 F4.0 V80 235-237 F3.0 V81 238-241 F4.0 V82 242-244 F3.0 V83 245-248 F4.0 V84 249-251 F3.0 V85 252-254 F3.0 V86 255-257 F3.0 V87 258-258 F1.0 V88 259-261 F3.0 V89 262-265 F4.0 V90 266-268 F3.0 V91 269-272 F4.0 V92 273-275 F3.0 V93 276-279 F4.0 V94 280-282 F3.0 V95 283-285 F3.0 V96 286-288 F3.0 V97 289-289 F1.0 V98 290-292 F3.0 V99 293-293 A1 V100 294-296 F3.0 V101 297-298 F2.0 V102 299-301 F3.0 V103 302-302 F1.0 V104 303-305 F3.0 V105 306-308 F3.0 V106 309-311 F3.0 V107 312-314 F3.0 V108 315-317 F3.0 V109 318-325 F8.0 V110 326-328 F3.0 V111 329-329 F1.0 V112 330-332 F3.0 V113 333-335 F3.0 V114 336-338 F3.0 V115 339-341 F3.0 V116 342-344 F3.0 V117 345-352 F8.0 V118 353-355 F3.0 V119 356-359 F4.0 V120 360-362 F3.0 V121 363-364 F2.0 V122 365-367 F3.0 V123 368-369 F2.0 V124 370-372 F3.0 V125 373-380 F8.0 V126 381-383 F3.0 V127 384-384 F1.0 V128 385-387 F3.0 V129 388-388 F1.0 V130 389-391 F3.0 V131 392-392 F1.0 V132 393-395 F3.0 V133 396-396 F1.0 V134 397-399 F3.0 V135 400-407 F8.0 V136 408-410 F3.0 V137 411-411 F1.0 V138 412-414 F3.0 V139 415-415 F1.0 V140 416-418 F3.0 V141 419-419 F1.0 V142 420-422 F3.0 V143 423-424 F2.0 V144 425-427 F3.0 V145 428-429 F2.0 V146 430-432 F3.0 V147 433-434 F2.0 V148 435-437 F3.0 V149 438-439 F2.0 V150 440-442 F3.0 V151 443-443 F1.0 V152 444-446 F3.0 V153 447-447 F1.0 V154 448-450 F3.0 V155 451-451 F1.0 V156 452-454 F3.0 V157 455-455 F1.0 V158 456-458 F3.0 V159 459-460 F2.0 V160 461-463 F3.0 V161 464-465 F2.0 V162 466-468 F3.0 V163 469-470 F2.0 V164 471-473 F3.0 V165 474-475 F2.0 V166 476-478 F3.0 V167 479-486 F8.0 V168 487-489 F3.0 V169 490-495 F6.0 V170 496-498 F3.0 V171 499-501 F3.0 V172 502-504 F3.0 V173 505-505 F1.0 V174 506-508 F3.0 V175 509-509 F1.0 V176 510-512 F3.0 V176 513-513 F1.0 V178 514-516 F3.0 V179 517-517 F1.0 V180 518-520 F3.0 V181 521-524 F4.0 V182 525-527 F3.0 V183 528-531 F4.0 V184 532-534 F3.0 V185 535-538 F4.0 V186 539-541 F3.0 V187 542-601 A60 V188 602-604 F3.0 V189 605-612 A8 V190 613-621 A9 V191 622-624 A3 V192 625-627 F3.0 V193 628-630 A3 V194 631-631 F1.0 V195 632-634 F3.0 V196 635-635 F1.0 V197 636-638 A3 V198 639-639 F1.0 V199 640-642 F3.0 V200 643-643 F1.0 V201 644-646 F3.0 V202 647-650 A4 V203 651-653 F3.0 V204 654-657 F4.0 V205 658-660 F3.0 V206 661-664 F4.0 V207 665-667 F3.0 V208 668-668 F1.0 V209 669-671 F3.0 V210 672-672 F1.0 V211 673-675 F3.0 V212 676-676 F1.0 V213 677-678 F2.0 V214 679-679 F1.0 V215 680-680 F1.0 V216 681-683 F3.0 V217 684-691 F8.0 V218 692-694 F3.0 V219 695-697 F3.0 V220 698-700 F3.0 V221 701-703 F3.0 V222 704-706 F3.0 V223 707-709 F3.0 V224 710-712 F3.0 V225 713-715 F3.0 V226 716-716 F1.0 V227 717-718 F2.0. CACHE. EXECUTE. DATASET NAME PNSS WINDOW=FRONT. Error #105. Command name: Execute
This command is not valid before a working file has been defined.
This command not executed.
DATASET NAME PNSS WINDOW=FRONT.
Thank you for your help!
Tara
Tara Trudnak, MPH, CPH
Doctoral Student
Department of Community and Family Health
College of Public Health
University of South Florida
|
|
|
I believe you also need to add “/” before the
subcommands. Also, V176 is duplicated and there isn’t a V177.
This is the syntax that I tested and it worked: GET DATA /TYPE=TXT /FILE='C:\temp\PNSS.txt' /FIXCASE=1 /ARRANGEMENT=FIXED /FIRSTCASE=1 /IMPORTCASE=ALL /VARIABLES= V1 0-1 A2 V2 2-4 F3.0 V3 5-5 F1.0 V4 6-8 F3.0 V5 9-17 F9.0 V6 18-20 F3.0 V7 21-25 F5.0 V8 26-28 F3.0 V9 29-29 F1.0 V10 30-32 F3.0 V11 33-33 F1.0 V12 34-36 F3.0 V13 37-44 F8.0 V14 45-47 F3.0 V15 48-55 F8.0 V16 56-56 F1.0 V17 57-57 F1.0 V18 58-58 F1.0 V19 59-66 F8.0 V20 67-69 F3.0 V21 70-71 F2.0 V22 72-74 F3.0 V23 75-75 F1.0 V24 76-78 F3.0 V25 79-80 F2.0 V26 81-83 F3.0 V27 84-89 F6.0 V28 90-92 F3.0 V29 93-95 F3.0 V30 96-98 F3.0 V31 99-100 F2.0 V32 101-103 F3.0 V33 104-104 F1.0 V34 105-107 F3.0 V35 108-109 F2.0 V36 110-112 F3.0 V37 113-113 F1.0 V38 114-116 F3.0 V39 117-118 F2.0 V40 119-121 F3.0 V41 122-125 F4.0 V42 126-128 F3.0 V43 129-129 F1.0 V44 130-132 F3.0 V45 133-133 F1.0 V46 134-136 F3.0 V47 137-137 F1.0 V48 138-140 F3.0 V49 141-141 F1.0 V50 142-144 F3.0 V51 145-145 F1.0 V52 146-148 F3.0 V53 149-149 F1.0 V54 150-152 F3.0 V55 153-153 F1.0 V56 154-156 F3.0 V57 157-157 F1.0 V58 158-160 F3.0 V59 161-161 F1.0 V60 162-164 F3.0 V61 165-172 F8.0 V62 173-175 F3.0 V63 176-184 F9.0 V64 185-187 F3.0 V65 188-190 F3.0 V66 191-193 F3.0 V67 194-197 F4.0 V68 198-200 F3.0 V69 201-204 F4.0 V70 205-207 F3.0 V71 208-210 F3.0 V72 211-213 F3.0 V73 214-217 F4.0 V74 218-220 F3.0 V75 221-223 F3.0 V76 224-226 F3.0 V77 227-227 F1.0 V78 228-230 F3.0 V79 231-234 F4.0 V80 235-237 F3.0 V81 238-241 F4.0 V82 242-244 F3.0 V83 245-248 F4.0 V84 249-251 F3.0 V85 252-254 F3.0 V86 255-257 F3.0 V87 258-258 F1.0 V88 259-261 F3.0 V89 262-265 F4.0 V90 266-268 F3.0 V91 269-272 F4.0 V92 273-275 F3.0 V93 276-279 F4.0 V94 280-282 F3.0 V95 283-285 F3.0 V96 286-288 F3.0 V97 289-289 F1.0 V98 290-292 F3.0 V99 293-293 A1 V100 294-296 F3.0 V101 297-298 F2.0 V102 299-301 F3.0 V103 302-302 F1.0 V104 303-305 F3.0 V105 306-308 F3.0 V106 309-311 F3.0 V107 312-314 F3.0 V108 315-317 F3.0 V109 318-325 F8.0 V110 326-328 F3.0 V111 329-329 F1.0 V112 330-332 F3.0 V113 333-335 F3.0 V114 336-338 F3.0 V115 339-341 F3.0 V116 342-344 F3.0 V117 345-352 F8.0 V118 353-355 F3.0 V119 356-359 F4.0 V120 360-362 F3.0 V121 363-364 F2.0 V122 365-367 F3.0 V123 368-369 F2.0 V124 370-372 F3.0 V125 373-380 F8.0 V126 381-383 F3.0 V127 384-384 F1.0 V128 385-387 F3.0 V129 388-388 F1.0 V130 389-391 F3.0 V131 392-392 F1.0 V132 393-395 F3.0 V133 396-396 F1.0 V134 397-399 F3.0 V135 400-407 F8.0 V136 408-410 F3.0 V137 411-411 F1.0 V138 412-414 F3.0 V139 415-415 F1.0 V140 416-418 F3.0 V141 419-419 F1.0 V142 420-422 F3.0 V143 423-424 F2.0 V144 425-427 F3.0 V145 428-429 F2.0 V146 430-432 F3.0 V147 433-434 F2.0 V148 435-437 F3.0 V149 438-439 F2.0 V150 440-442 F3.0 V151 443-443 F1.0 V152 444-446 F3.0 V153 447-447 F1.0 V154 448-450 F3.0 V155 451-451 F1.0 V156 452-454 F3.0 V157 455-455 F1.0 V158 456-458 F3.0 V159 459-460 F2.0 V160 461-463 F3.0 V161 464-465 F2.0 V162 466-468 F3.0 V163 469-470 F2.0 V164 471-473 F3.0 V165 474-475 F2.0 V166 476-478 F3.0 V167 479-486 F8.0 V168 487-489 F3.0 V169 490-495 F6.0 V170 496-498 F3.0 V171 499-501 F3.0 V172 502-504 F3.0 V173 505-505 F1.0 V174 506-508 F3.0 V175 509-509 F1.0 V176 510-512 F3.0 V177 513-513 F1.0 V178 514-516 F3.0 V179 517-517 F1.0 V180 518-520 F3.0 V181 521-524 F4.0 V182 525-527 F3.0 V183 528-531 F4.0 V184 532-534 F3.0 V185 535-538 F4.0 V186 539-541 F3.0 V187 542-601 A60 V188 602-604 F3.0 V189 605-612 A8 V190 613-621 A9 V191 622-624 A3 V192 625-627 F3.0 V193 628-630 A3 V194 631-631 F1.0 V195 632-634 F3.0 V196 635-635 F1.0 V197 636-638 A3 V198 639-639 F1.0 V199 640-642 F3.0 V200 643-643 F1.0 V201 644-646 F3.0 V202 647-650 A4 V203 651-653 F3.0 V204 654-657 F4.0 V205 658-660 F3.0 V206 661-664 F4.0 V207 665-667 F3.0 V208 668-668 F1.0 V209 669-671 F3.0 V210 672-672 F1.0 V211 673-675 F3.0 V212 676-676 F1.0 V213 677-678 F2.0 V214 679-679 F1.0 V215 680-680 F1.0 V216 681-683 F3.0 V217 684-691 F8.0 V218 692-694 F3.0 V219 695-697 F3.0 V220 698-700 F3.0 V221 701-703 F3.0 V222 704-706 F3.0 V223 707-709 F3.0 V224 710-712 F3.0 V225 713-715 F3.0 V226 716-716 F1.0 V227 717-718 F2.0. CACHE. EXECUTE. From: SPSSX(r) Discussion
[mailto:[hidden email]] On Behalf Of Oliver, Richard For starters, remove all the periods at the ends of lines in the
GET DATA command. A period at the end of a line is interpreted as a command
terminator. From: SPSSX(r) Discussion on behalf of Trudnak,
Tara Hello,
Earlier
today my professor sent a question to this listserve asking about a 'get data'
error. This is actually for a secondary analysis project I am working
on. I took the advice that was sent out to me to change the variable names
but unfortunately it hasn't worked. I'm hoping someone can help me out. I am
using SPSS 17.0. I did not put this syntax in myself it if a result of the command
tree that I went through to sort the data fields. The data came from a txt.
file but the fields were not defined. I had to put lines in to define the
fields. Here
is the syntax and the error code I get. GET
DATA Error #105.
Command name: Execute This command
is not valid before a working file has been defined. This command
not executed. DATASET NAME
PNSS WINDOW=FRONT. Thank
you for your help! Tara Tara Trudnak,
MPH, CPH Doctoral Student
Department of
Community and Family Health College of
Public Health University of
South Florida |
|
|
Thanks so much! I got it to work.
Tara
Tara Trudnak, MPH, CPH
Doctoral Student
Department of Community and Family Health
College of Public Health
University of South Florida
From: SPSSX(r) Discussion [[hidden email]] On Behalf Of Eric Langston [[hidden email]] Sent: Thursday, April 16, 2009 6:40 PM To: [hidden email] Subject: Re: help with 'get data' error I believe you also need to add “/” before the subcommands. Also, V176 is duplicated and there isn’t a V177. This is the syntax that I tested and it worked:
GET DATA /TYPE=TXT /FILE='C:\temp\PNSS.txt' /FIXCASE=1 /ARRANGEMENT=FIXED /FIRSTCASE=1 /IMPORTCASE=ALL /VARIABLES= V1 0-1 A2 V2 2-4 F3.0 V3 5-5 F1.0 V4 6-8 F3.0 V5 9-17 F9.0 V6 18-20 F3.0 V7 21-25 F5.0 V8 26-28 F3.0 V9 29-29 F1.0 V10 30-32 F3.0 V11 33-33 F1.0 V12 34-36 F3.0 V13 37-44 F8.0 V14 45-47 F3.0 V15 48-55 F8.0 V16 56-56 F1.0 V17 57-57 F1.0 V18 58-58 F1.0 V19 59-66 F8.0 V20 67-69 F3.0 V21 70-71 F2.0 V22 72-74 F3.0 V23 75-75 F1.0 V24 76-78 F3.0 V25 79-80 F2.0 V26 81-83 F3.0 V27 84-89 F6.0 V28 90-92 F3.0 V29 93-95 F3.0 V30 96-98 F3.0 V31 99-100 F2.0 V32 101-103 F3.0 V33 104-104 F1.0 V34 105-107 F3.0 V35 108-109 F2.0 V36 110-112 F3.0 V37 113-113 F1.0 V38 114-116 F3.0 V39 117-118 F2.0 V40 119-121 F3.0 V41 122-125 F4.0 V42 126-128 F3.0 V43 129-129 F1.0 V44 130-132 F3.0 V45 133-133 F1.0 V46 134-136 F3.0 V47 137-137 F1.0 V48 138-140 F3.0 V49 141-141 F1.0 V50 142-144 F3.0 V51 145-145 F1.0 V52 146-148 F3.0 V53 149-149 F1.0 V54 150-152 F3.0 V55 153-153 F1.0 V56 154-156 F3.0 V57 157-157 F1.0 V58 158-160 F3.0 V59 161-161 F1.0 V60 162-164 F3.0 V61 165-172 F8.0 V62 173-175 F3.0 V63 176-184 F9.0 V64 185-187 F3.0 V65 188-190 F3.0 V66 191-193 F3.0 V67 194-197 F4.0 V68 198-200 F3.0 V69 201-204 F4.0 V70 205-207 F3.0 V71 208-210 F3.0 V72 211-213 F3.0 V73 214-217 F4.0 V74 218-220 F3.0 V75 221-223 F3.0 V76 224-226 F3.0 V77 227-227 F1.0 V78 228-230 F3.0 V79 231-234 F4.0 V80 235-237 F3.0 V81 238-241 F4.0 V82 242-244 F3.0 V83 245-248 F4.0 V84 249-251 F3.0 V85 252-254 F3.0 V86 255-257 F3.0 V87 258-258 F1.0 V88 259-261 F3.0 V89 262-265 F4.0 V90 266-268 F3.0 V91 269-272 F4.0 V92 273-275 F3.0 V93 276-279 F4.0 V94 280-282 F3.0 V95 283-285 F3.0 V96 286-288 F3.0 V97 289-289 F1.0 V98 290-292 F3.0 V99 293-293 A1 V100 294-296 F3.0 V101 297-298 F2.0 V102 299-301 F3.0 V103 302-302 F1.0 V104 303-305 F3.0 V105 306-308 F3.0 V106 309-311 F3.0 V107 312-314 F3.0 V108 315-317 F3.0 V109 318-325 F8.0 V110 326-328 F3.0 V111 329-329 F1.0 V112 330-332 F3.0 V113 333-335 F3.0 V114 336-338 F3.0 V115 339-341 F3.0 V116 342-344 F3.0 V117 345-352 F8.0 V118 353-355 F3.0 V119 356-359 F4.0 V120 360-362 F3.0 V121 363-364 F2.0 V122 365-367 F3.0 V123 368-369 F2.0 V124 370-372 F3.0 V125 373-380 F8.0 V126 381-383 F3.0 V127 384-384 F1.0 V128 385-387 F3.0 V129 388-388 F1.0 V130 389-391 F3.0 V131 392-392 F1.0 V132 393-395 F3.0 V133 396-396 F1.0 V134 397-399 F3.0 V135 400-407 F8.0 V136 408-410 F3.0 V137 411-411 F1.0 V138 412-414 F3.0 V139 415-415 F1.0 V140 416-418 F3.0 V141 419-419 F1.0 V142 420-422 F3.0 V143 423-424 F2.0 V144 425-427 F3.0 V145 428-429 F2.0 V146 430-432 F3.0 V147 433-434 F2.0 V148 435-437 F3.0 V149 438-439 F2.0 V150 440-442 F3.0 V151 443-443 F1.0 V152 444-446 F3.0 V153 447-447 F1.0 V154 448-450 F3.0 V155 451-451 F1.0 V156 452-454 F3.0 V157 455-455 F1.0 V158 456-458 F3.0 V159 459-460 F2.0 V160 461-463 F3.0 V161 464-465 F2.0 V162 466-468 F3.0 V163 469-470 F2.0 V164 471-473 F3.0 V165 474-475 F2.0 V166 476-478 F3.0 V167 479-486 F8.0 V168 487-489 F3.0 V169 490-495 F6.0 V170 496-498 F3.0 V171 499-501 F3.0 V172 502-504 F3.0 V173 505-505 F1.0 V174 506-508 F3.0 V175 509-509 F1.0 V176 510-512 F3.0 V177 513-513 F1.0 V178 514-516 F3.0 V179 517-517 F1.0 V180 518-520 F3.0 V181 521-524 F4.0 V182 525-527 F3.0 V183 528-531 F4.0 V184 532-534 F3.0 V185 535-538 F4.0 V186 539-541 F3.0 V187 542-601 A60 V188 602-604 F3.0 V189 605-612 A8 V190 613-621 A9 V191 622-624 A3 V192 625-627 F3.0 V193 628-630 A3 V194 631-631 F1.0 V195 632-634 F3.0 V196 635-635 F1.0 V197 636-638 A3 V198 639-639 F1.0 V199 640-642 F3.0 V200 643-643 F1.0 V201 644-646 F3.0 V202 647-650 A4 V203 651-653 F3.0 V204 654-657 F4.0 V205 658-660 F3.0 V206 661-664 F4.0 V207 665-667 F3.0 V208 668-668 F1.0 V209 669-671 F3.0 V210 672-672 F1.0 V211 673-675 F3.0 V212 676-676 F1.0 V213 677-678 F2.0 V214 679-679 F1.0 V215 680-680 F1.0 V216 681-683 F3.0 V217 684-691 F8.0 V218 692-694 F3.0 V219 695-697 F3.0 V220 698-700 F3.0 V221 701-703 F3.0 V222 704-706 F3.0 V223 707-709 F3.0 V224 710-712 F3.0 V225 713-715 F3.0 V226 716-716 F1.0 V227 717-718 F2.0. CACHE. EXECUTE.
From: SPSSX(r) Discussion [mailto:[hidden email]]
On Behalf Of Oliver, Richard
For starters, remove all the periods at the ends of lines in the GET DATA command. A period at the end of a line is interpreted as a command terminator.
From: SPSSX(r) Discussion on behalf of Trudnak, Tara Hello,
Earlier today my professor sent a question to this listserve asking about a 'get data' error. This is actually for a secondary analysis project I am working on. I took the advice that was sent out to me to change the variable names but unfortunately it hasn't worked. I'm hoping someone can help me out. I am using SPSS 17.0. I did not put this syntax in myself it if a result of the command tree that I went through to sort the data fields. The data came from a txt. file but the fields were not defined. I had to put lines in to define the fields.
Here is the syntax and the error code I get.
GET DATA
Error #105. Command name: Execute This command is not valid before a working file has been defined. This command not executed. DATASET NAME PNSS WINDOW=FRONT.
Thank you for your help! Tara
Tara Trudnak, MPH, CPH Doctoral Student Department of Community and Family Health College of Public Health University of South Florida |
| Free forum by Nabble | Edit this page |