|
| From: | Ricardo Mejias |
| Subject: | Delted the DELETE VARIABLES ResidenceZipcode |
| Date: | Sun, 7 Mar 2021 20:22:31 +0000 |
|
I deleted the DELETE VARIABLES ResidenceZipcode and ran the complete Florida voter file and it was completed just fine. But then I thought what if I just make
Thanks to everyone who worked on this.
And, when this delete variables bug is fixed, will the users be notified?
From: Pspp-users <pspp-users-bounces+ricardomejias=hotmail.com@gnu.org> on behalf of pspp-users-request@gnu.org <pspp-users-request@gnu.org>
Sent: Sunday, March 7, 2021 2:40 PM To: pspp-users@gnu.org <pspp-users@gnu.org> Subject: Pspp-users Digest, Vol 177, Issue 17 Send Pspp-users mailing list submissions to
pspp-users@gnu.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnu.org/mailman/listinfo/pspp-users or, via email, send a message with subject or body 'help' to pspp-users-request@gnu.org You can reach the person managing the list at pspp-users-owner@gnu.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Pspp-users digest..." Today's Topics: 1. Re: Pspp-users Digest, Vol 177, Issue 2 (Ben Pfaff) 2. Re: Pspp-users Digest, Vol 177, Issue 14 (Ben Pfaff) ---------------------------------------------------------------------- Message: 1 Date: Sun, 7 Mar 2021 11:34:22 -0800 From: Ben Pfaff <blp@cs.stanford.edu> To: Ricardo Mejias <ricardomejias@hotmail.com> Cc: "pspp-users@gnu.org" <pspp-users@gnu.org> Subject: Re: Pspp-users Digest, Vol 177, Issue 2 Message-ID: <CAA_G9+gS+BnP-RzO_fL+U_u8e12ZcVCvQYnR2eYhDmNu911LMQ@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I pushed an improvement to the error message. Now it should say something like this: parse.sps:2: error: COMPUTE: This command tries to create a new variable myvar by assigning a string value to it, but this is not supported. Use the STRING command to create the new variable with the correct width before assigning to it, e.g. STRING myvar(A20). On Thu, Mar 4, 2021 at 4:32 PM Ben Pfaff <blp@cs.stanford.edu> wrote: > > It would be easy enough for PSPP to see that the _expression_ has string type, and therefore give the new variable string type too. The reason it doesn't work that way is that it's not always possible to know the maximum width of an _expression_ that has string type, but SPSS and PSPP require string variables to have a fixed width. > > It's a poor error message. I'll make a note to improve it. > > On Thu, Mar 4, 2021 at 1:49 PM Ricardo Mejias <ricardomejias@hotmail.com> wrote: >> >> I inserted STRING ResidenceZipcodes (A5). in the code and the error message went away and this new variable did get all the digits beyond 5 truncated. >> What confused me is that the original ResidenceZipcode showed on the variables table to be a string variable. I assumed that the source variable, not the resulting variable is what had to be a string variable and that it would make the resulting variable automatically a string variable too. I am a former SAS programmer, and that is how it was in SAS. >> >> Thank you very much for the help. >> >> ________________________________ >> From: Pspp-users <pspp-users-bounces+ricardomejias=hotmail.com@gnu.org> on behalf of pspp-users-request@gnu.org <pspp-users-request@gnu.org> >> Sent: Thursday, March 4, 2021 4:07 PM >> To: pspp-users@gnu.org <pspp-users@gnu.org> >> Subject: Pspp-users Digest, Vol 177, Issue 2 >> >> Send Pspp-users mailing list submissions to >> pspp-users@gnu.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.gnu.org/mailman/listinfo/pspp-users >> or, via email, send a message with subject or body 'help' to >> pspp-users-request@gnu.org >> >> You can reach the person managing the list at >> pspp-users-owner@gnu.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Pspp-users digest..." >> >> >> Today's Topics: >> >> 1. Re: Error Message on SUBSTRG String Function (Frans Houweling) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Thu, 4 Mar 2021 22:07:43 +0100 >> From: Frans Houweling <fhouweling@email.it> >> To: pspp-users@gnu.org >> Subject: Re: Error Message on SUBSTRG String Function >> Message-ID: <90adf4df-5ba0-15c9-be6f-92032b606e68@email.it> >> Content-Type: text/plain; charset="windows-1252"; Format="flowed" >> >> Hi Ricardo, >> >> ResidenceZipcodes is a new variable here, and is therefore assumed to >> be numeric. >> >> Unless it was your intention re-assign to ResidenceZipCode, you need to >> declare the variable as a string: >> >> STRING ResidenceZipcodes (A5). >> >> HTH >> >> frans >> >> >> On 3/4/21 9:43 PM, Ricardo Mejias wrote: >> > Using a Substr string function on a string variable (see the screen >> > shots below) I get an error message saying: "the _expression_ has string >> > type, but a numeric value is required here."Did I do something wrong >> > or is this a bug? >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > I am using GNU pspp 1.4.1-g79ad47 with Windows 10 >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: <https://lists.gnu.org/archive/html/pspp-users/attachments/20210304/cd625184/attachment.html> >> -------------- next part -------------- >> A non-text attachment was scrubbed... >> Name: image.png >> Type: image/png >> Size: 11501 bytes >> Desc: not available >> URL: <https://lists.gnu.org/archive/html/pspp-users/attachments/20210304/cd625184/attachment.png> >> -------------- next part -------------- >> A non-text attachment was scrubbed... >> Name: image.png >> Type: image/png >> Size: 23746 bytes >> Desc: not available >> URL: <https://lists.gnu.org/archive/html/pspp-users/attachments/20210304/cd625184/attachment-0001.png> >> -------------- next part -------------- >> A non-text attachment was scrubbed... >> Name: image.png >> Type: image/png >> Size: 27511 bytes >> Desc: not available >> URL: <https://lists.gnu.org/archive/html/pspp-users/attachments/20210304/cd625184/attachment-0002.png> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> Pspp-users mailing list >> Pspp-users@gnu.org >> https://lists.gnu.org/mailman/listinfo/pspp-users >> >> >> ------------------------------ >> >> End of Pspp-users Digest, Vol 177, Issue 2 >> ****************************************** ------------------------------ Message: 2 Date: Sun, 7 Mar 2021 11:39:55 -0800 From: Ben Pfaff <blp@cs.stanford.edu> To: John Darrington <john@darrington.wattle.id.au> Cc: Ricardo Mejias <ricardomejias@hotmail.com>, "pspp-users@gnu.org" <pspp-users@gnu.org> Subject: Re: Pspp-users Digest, Vol 177, Issue 14 Message-ID: <CAA_G9+j8u5cB0vh_akw3dDXXTSux6pLVj6sSrJSwR95NdrvQDA@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" DELETE VARIABLES is really tricky in the context of the GUI. I am not too surprised that it has bugs. I imagine that this works just fine from the command line. On Sun, Mar 7, 2021 at 11:00 AM John Darrington <john@darrington.wattle.id.au> wrote: > > It seems that the DELETE VARIABLES line is causing this problem. > > Until a fix for that is forthcoming, I suggest leaving out that line. > > J' > > On Sun, Mar 07, 2021 at 05:27:22PM +0000, Ricardo Mejias wrote: > To John Darrington <john@darrington.wattle.id.au>: > > I think that the content of this earlier email may answer your questions. > > The file I was working with is a merge of voter registration data from all of the counties in Florida (which is public information). Since I could not make the N 100 work, I decided to do to the file of the smallest county what I did to the Florida totals, so that I could have one small enough to email it to you. First, I ran this smaller file on the same code. It crashed one line before where the larger one used to crash, on NUMERIC EndDate (F10). Then I re-ran the larger one and it also crashed one the line before where it used to crash. > > But this time, the crashed happened when the Variables window showed up and I tried to go to View Data. First an error message window popped up saying "Assertion Failed". Retry and Ignore would not do anything, so I clicked on Abort and had a crash. > > Then I ran the code on the smaller file through COMPUTE EndDate = YRMODA(2021, 01, 31) and it also crashed. So, the file I have attached should be good for testing whether or not you get the same results. > > Please let me know what you find and what solutions you suggest. > > GET /FILE = "E:\GNU_PSPP\FloridaTotalsFiles\SelectedFieldsLIB_20210209.sav". > FILTER OFF. > USE ALL. > SELECT IF(NOT MISSING(BirthDate)). > STRING ResidenceZipcodes (A5). > COMPUTE ResidenceZipcodes=SUBSTR(ResidenceZipcode,1,5). > DELETE VARIABLES ResidenceZipcode. /*Worked up to here. Crashes after that*/ > NUMERIC EndDate (F10). /*Crashed here*/ > COMPUTE EndDate = YRMODA(2021, 01, 31). > EXECUTE. > FORMAT EndDate (ADATE10). > COMPUTE AgeInMonths = DATEDIFF(EndDate,BirthDate,'days') / (365.25*12). > > [cid:fff1dfae-d921-4ce8-8335-866980b345d9] > From: Pspp-users <pspp-users-bounces+ricardomejias=hotmail.com@gnu.org> on behalf of pspp-users-request@gnu.org <pspp-users-request@gnu.org> > Sent: Sunday, March 7, 2021 12:00 PM > To: pspp-users@gnu.org <pspp-users@gnu.org> > Subject: Pspp-users Digest, Vol 177, Issue 14 > > Send Pspp-users mailing list submissions to > pspp-users@gnu.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnu.org/mailman/listinfo/pspp-users > or, via email, send a message with subject or body 'help' to > pspp-users-request@gnu.org > > You can reach the person managing the list at > pspp-users-owner@gnu.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Pspp-users digest..." > > > Today's Topics: > > 1. Re: Attached Crashing File (John Darrington) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 7 Mar 2021 17:27:44 +0100 > From: John Darrington <john@darrington.wattle.id.au> > To: amead@alanmead.org > Cc: Ricardo Mejias <ricardomejias@hotmail.com>, "pspp-users@gnu.org" > <pspp-users@gnu.org> > Subject: Re: Attached Crashing File > Message-ID: <20210307162744.GA17362@jocasta.intra> > Content-Type: text/plain; charset=iso-8859-1 > > I haven't been following this discussion too closely I'm afraid. > > Do we have a reliable test case for this assertion failure? If so, > should be relatively easy to fix. > > And what is the file/line number of the failed assertion? That might > give us a clue. > > J' > > On Sun, Mar 07, 2021 at 09:53:57AM -0600, Alan Mead wrote: > Ben or John, > > What do you suggest? I think there's clearly a problem as shown by the > assertion that failed? > > However, if you have a fix, I don't know how we will test it... > > -Alan > > On 3/7/2021 9:43 AM, Ricardo Mejias wrote: > > > > The file I was working with is a merge of voter registration data from > > all of the counties in Florida (which is public information). > > Since I could not make the N 100 work, I decided to do to the file of > > the smallest county what I did to the Florida totals, so that I could > > have one small enough to email it to you. First, I ran this smaller > > file on the same code. It crashed one line before where the larger > > one used to crash, on NUMERIC EndDate (F10). Then I re-ran the larger > > one and it also crashed one the line before where it used to crash. > > > > But this time, the crashed happened when the Variables window showed > > up and I tried to go to View Data. First an error message window > > popped up saying "Assertion Failed". Retry and Ignore would not do > > anything, so I clicked on Abort and had a crash. > > > > Then I ran the code on the smaller file through COMPUTE EndDate = > > YRMODA(2021, 01, 31) and it also crashed. So, the file I have > > attached should be good for testing whether or not you get the same > > results. > > > > Please let me know what you find and what solutions you suggest. > > > > > > > > GET /FILE = > > "E:\GNU_PSPP\FloridaTotalsFiles\SelectedFieldsLIB_20210209.sav". > > > > > > > > > > > > > > > > > > > > > > FILTER OFF. > > > > > > > > > > > > > > > > USE ALL. > > > > > > > > > > > > > > > > SELECT IF(NOT MISSING(BirthDate)). > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > STRING ResidenceZipcodes (A5). > > > > > > > > > > > > > > COMPUTE ResidenceZipcodes=SUBSTR(ResidenceZipcode,1,5). > > > > DELETE VARIABLES ResidenceZipcode. /*Worked up to here. Crashes > > after that*/ > > > > > > > > > > > > > > > > > > > > > > NUMERIC EndDate (F10). > > > > > > /*Crashed here*/ > > > > COMPUTE EndDate = YRMODA(2021, 01, 31). > > > > > > > > > > EXECUTE. > > > > > > > > > > > > > > > > FORMAT EndDate (ADATE10). > > > > > > > > > > > > > > COMPUTE AgeInMonths = DATEDIFF(EndDate,BirthDate,'days') / (365.25*12). > > > > > > > > > > ------------------------------------------------------------------------ > > *From:* Pspp-users > > <pspp-users-bounces+ricardomejias=hotmail.com@gnu.org> on behalf of > > pspp-users-request@gnu.org <pspp-users-request@gnu.org> > > *Sent:* Sunday, March 7, 2021 7:52 AM > > *To:* pspp-users@gnu.org <pspp-users@gnu.org> > > *Subject:* Pspp-users Digest, Vol 177, Issue 10 > > > > Send Pspp-users mailing list submissions to > > pspp-users@gnu.org > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://lists.gnu.org/mailman/listinfo/pspp-users > > <https://lists.gnu.org/mailman/listinfo/pspp-users> > > or, via email, send a message with subject or body 'help' to > > pspp-users-request@gnu.org > > > > You can reach the person managing the list at > > pspp-users-owner@gnu.org > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of Pspp-users digest..." > > > > > > Today's Topics: > > > > 1. Re: PROBLEM CREATING A DATE VARIABLE (Ricardo Mejias) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Sun, 7 Mar 2021 12:51:52 +0000 > > From: Ricardo Mejias <ricardomejias@hotmail.com> > > To: "amead@alanmead.org" <amead@alanmead.org>, "pspp-users@gnu.org" > > <pspp-users@gnu.org> > > Subject: Re: PROBLEM CREATING A DATE VARIABLE > > Message-ID: > > > > <BN6PR19MB32344CE2E82928FA5C60F657B6949@BN6PR19MB3234.namprd19.prod.outlook.com> > > > > Content-Type: text/plain; charset="iso-8859-1" > > > > My version of PSPP is GNU pspp 1.4.1-g79ad47 and I am on Windows 10. > > BirthDate is Date and ResidenceZipcode is String. > > > > [cid:d56e0513-f13a-44e6-8635-28c40a1f3aaf] > > > > I used this code and I still got the total number of records of > > 15,782,637. > > GET /FILE = > > "E:\GNU_PSPP\FloridaTotalsFiles\SelectedAndAddedFields_20210209.sav". > > N 100. > > > > I reran the code up to the line where it crashes and it crashed again. > > GET /FILE = > > "E:\GNU_PSPP\FloridaTotalsFiles\SelectedAndAddedFields_20210209.sav". > > FILTER OFF. > > USE ALL. > > SELECT IF(NOT MISSING(BirthDate)). > > STRING ResidenceZipcodes (A5). > > COMPUTE ResidenceZipcodes=SUBSTR(ResidenceZipcode,1,5). > > DELETE VARIABLES ResidenceZipcode. > > NUMERIC EndDate (F10). /*Worked up to here. Crashes after that*/ > > COMPUTE EndDate = YRMODA(2021, 01, 31). > > EXECUTE. > > > > > > From: Alan Mead <amead@alanmead.org> > > Sent: Saturday, March 6, 2021 11:31 PM > > To: Ricardo Mejias <ricardomejias@hotmail.com> > > Subject: Re: PROBLEM CREATING A DATE VARIABLE > > > > This page describes selecting cases: > > https://www.ibm.com/support/knowledgecenter/SSLVMB_sub/statistics_reference_project_ddita/spss/base/syn_n_of_cases_overview.html > > <https://www.ibm.com/support/knowledgecenter/SSLVMB_sub/statistics_reference_project_ddita/spss/base/syn_n_of_cases_overview.html> > > . Suposedly, this will only read 100 cases: > > > > GET FILE='/data/city.sav'. > > N 100. > > > > What version of PSPP are you using? YOu can see it if you select Help > > > About: > > > > [https://attachment.outlook.live.net/owa/MSA%3Aricardomejias%40hotmail.com/service.svc/s/GetAttachmentThumbnail?id=AQMkADAwATE0YTEwLTZkZjYtMjM3MC0wMAItMDAKAEYAAAOtrkdxJRp3Qq1snxjuC61FBwBLzRTn7SoZQIS7CwsANCuvwgAAAgEPAAAAS80U5%2B0qGUCEuwsLADQrr8IABC66W%2FQAAAABEgAQAHU5uSKC05ZBjPrzpck8ps0%3D&thumbnailType=2&isc=1&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjMwODE3OUNFNUY0QjUyRTc4QjJEQjg5NjZCQUY0RUNDMzcyN0FFRUUiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJNSUY1emw5TFV1ZUxMYmlXYTY5T3pEY25ydTQifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2subGl2ZS5jb20iLCJ1YyI6ImYxOGQ5NWIxNDE4YTRhYzFhOGU1MWVjYmJhNjE0NDQ4IiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInB1aWRcIjpcIjM2MjkwOTQwMTQ5MDI4OFwiLFwic2NvcGVcIjpcIk93YURvd25sb2FkXCIsXCJvaWRcIjpcIjAwMDE0YTEwLTZkZjYtMjM3MC0wMDAwLTAwMDAwMDAwMDAwMFwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTI4MjctODQ0OTYtMTg0NDg0NzQ3MlwifSIsIm5iZiI6MTYxNTEyMTMwNiwiZXhwIjoxNjE1MTIxOTA2LCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAODRkZjllN2YtZTlmNi00MGFmLWI0MzUtYWFhYWFhYWFhYWFhIiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnQub3V0bG9vay5saXZlLm5ldEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJoYXBwIjoib3dhIn0.hCyDTUfXZPrhAgGu1xd9HdA6YZSMQVVD2yGyTE1f10XmrGbORyN1zbNBmA4IVlGJ0CIKcUuYby9aAPY1ykdrdu31CYy88ubku_kSYXs4yopOXa7iC1RkOP5QTle3nBXw3GXqT08dMpDtQP3OkLKp2UEolMyXOm6EvYq7hAo2bYnkGGOOWDaFfeRR4HEQOMgAa5BogPc65gTlqteES1fKVmRdNZxasJU_KjcUkea9OSBR2SG5Hs4FZT_zH19L4zQWFni4yHONePfGYbT6feX-jufdrKUZEt3-07WUv3MhkW21kPv9qExW2rZjh3eXKmidZmzvAEcGOh27GetwleJKuw&X-OWA-CANARY=34Gsb7X9ckKot9lUQ__jydDHpVVn4dgYVP829jIVc07_voQa9rOuJSbDeIUnFosi5EuBkxkQGLY.&owa=outlook.live.com&scriptVer=20210301002.02&animation=true > > <https://attachment.outlook.live.net/owa/MSA%3Aricardomejias%40hotmail.com/service.svc/s/GetAttachmentThumbnail?id=AQMkADAwATE0YTEwLTZkZjYtMjM3MC0wMAItMDAKAEYAAAOtrkdxJRp3Qq1snxjuC61FBwBLzRTn7SoZQIS7CwsANCuvwgAAAgEPAAAAS80U5%2B0qGUCEuwsLADQrr8IABC66W%2FQAAAABEgAQAHU5uSKC05ZBjPrzpck8ps0%3D&thumbnailType=2&isc=1&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjMwODE3OUNFNUY0QjUyRTc4QjJEQjg5NjZCQUY0RUNDMzcyN0FFRUUiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJNSUY1emw5TFV1ZUxMYmlXYTY5T3pEY25ydTQifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2subGl2ZS5jb20iLCJ1YyI6ImYxOGQ5NWIxNDE4YTRhYzFhOGU1MWVjYmJhNjE0NDQ4IiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInB1aWRcIjpcIjM2MjkwOTQwMTQ5MDI4OFwiLFwic2NvcGVcIjpcIk93YURvd25sb2FkXCIsXCJvaWRcIjpcIjAwMDE0YTEwLTZkZjYtMjM3MC0wMDAwLTAwMDAwMDAwMDAwMFwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTI4MjctODQ0OTYtMTg0NDg0NzQ3MlwifSIsIm5iZiI6MTYxNTEyMTMwNiwiZXhwIjoxNjE1MTIxOTA2LCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAODRkZjllN2YtZTlmNi00MGFmLWI0MzUtYWFhYWFhYWFhYWFhIiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnQub3V0bG9vay5saXZlLm5ldEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJoYXBwIjoib3dhIn0.hCyDTUfXZPrhAgGu1xd9HdA6YZSMQVVD2yGyTE1f10XmrGbORyN1zbNBmA4IVlGJ0CIKcUuYby9aAPY1ykdrdu31CYy88ubku_kSYXs4yopOXa7iC1RkOP5QTle3nBXw3GXqT08dMpDtQP3OkLKp2UEolMyXOm6EvYq7hAo2bYnkGGOOWDaFfeRR4HEQOMgAa5BogPc65gTlqteES1fKVmRdNZxasJU_KjcUkea9OSBR2SG5Hs4FZT_zH19L4zQWFni4yHONePfGYbT6feX-jufdrKUZEt3-07WUv3MhkW21kPv9qExW2rZjh3eXKmidZmzvAEcGOh27GetwleJKuw&X-OWA-CANARY=34Gsb7X9ckKot9lUQ__jydDHpVVn4dgYVP829jIVc07_voQa9rOuJSbDeIUnFosi5EuBkxkQGLY.&owa=outlook.live.com&scriptVer=20210301002.02&animation=true>] > > > > What types are BirthDate and ResidenceZipcode? I ran your script and > > it ran fine, but it had errors that prevented some of the lines from > > executing. But the lines that you think are causing trouble seemed to > > execute correctly: > > > > [https://attachment.outlook.live.net/owa/MSA%3Aricardomejias%40hotmail.com/service.svc/s/GetAttachmentThumbnail?id=AQMkADAwATE0YTEwLTZkZjYtMjM3MC0wMAItMDAKAEYAAAOtrkdxJRp3Qq1snxjuC61FBwBLzRTn7SoZQIS7CwsANCuvwgAAAgEPAAAAS80U5%2B0qGUCEuwsLADQrr8IABC66W%2FQAAAABEgAQAI4KT9VQnKJAhjM84T6OMHU%3D&thumbnailType=2&isc=1&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjMwODE3OUNFNUY0QjUyRTc4QjJEQjg5NjZCQUY0RUNDMzcyN0FFRUUiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJNSUY1emw5TFV1ZUxMYmlXYTY5T3pEY25ydTQifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2subGl2ZS5jb20iLCJ1YyI6ImYxOGQ5NWIxNDE4YTRhYzFhOGU1MWVjYmJhNjE0NDQ4IiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInB1aWRcIjpcIjM2MjkwOTQwMTQ5MDI4OFwiLFwic2NvcGVcIjpcIk93YURvd25sb2FkXCIsXCJvaWRcIjpcIjAwMDE0YTEwLTZkZjYtMjM3MC0wMDAwLTAwMDAwMDAwMDAwMFwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTI4MjctODQ0OTYtMTg0NDg0NzQ3MlwifSIsIm5iZiI6MTYxNTEyMTMwNiwiZXhwIjoxNjE1MTIxOTA2LCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAODRkZjllN2YtZTlmNi00MGFmLWI0MzUtYWFhYWFhYWFhYWFhIiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnQub3V0bG9vay5saXZlLm5ldEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJoYXBwIjoib3dhIn0.hCyDTUfXZPrhAgGu1xd9HdA6YZSMQVVD2yGyTE1f10XmrGbORyN1zbNBmA4IVlGJ0CIKcUuYby9aAPY1ykdrdu31CYy88ubku_kSYXs4yopOXa7iC1RkOP5QTle3nBXw3GXqT08dMpDtQP3OkLKp2UEolMyXOm6EvYq7hAo2bYnkGGOOWDaFfeRR4HEQOMgAa5BogPc65gTlqteES1fKVmRdNZxasJU_KjcUkea9OSBR2SG5Hs4FZT_zH19L4zQWFni4yHONePfGYbT6feX-jufdrKUZEt3-07WUv3MhkW21kPv9qExW2rZjh3eXKmidZmzvAEcGOh27GetwleJKuw&X-OWA-CANARY=34Gsb7X9ckKot9lUQ__jydDHpVVn4dgYVP829jIVc07_voQa9rOuJSbDeIUnFosi5EuBkxkQGLY.&owa=outlook.live.com&scriptVer=20210301002.02&animation=true > > <https://attachment.outlook.live.net/owa/MSA%3Aricardomejias%40hotmail.com/service.svc/s/GetAttachmentThumbnail?id=AQMkADAwATE0YTEwLTZkZjYtMjM3MC0wMAItMDAKAEYAAAOtrkdxJRp3Qq1snxjuC61FBwBLzRTn7SoZQIS7CwsANCuvwgAAAgEPAAAAS80U5%2B0qGUCEuwsLADQrr8IABC66W%2FQAAAABEgAQAI4KT9VQnKJAhjM84T6OMHU%3D&thumbnailType=2&isc=1&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjMwODE3OUNFNUY0QjUyRTc4QjJEQjg5NjZCQUY0RUNDMzcyN0FFRUUiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJNSUY1emw5TFV1ZUxMYmlXYTY5T3pEY25ydTQifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2subGl2ZS5jb20iLCJ1YyI6ImYxOGQ5NWIxNDE4YTRhYzFhOGU1MWVjYmJhNjE0NDQ4IiwidmVyIjoiRXhjaGFuZ2UuQ2FsbGJhY2suVjEiLCJhcHBjdHhzZW5kZXIiOiJPd2FEb3dubG9hZEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJpc3NyaW5nIjoiV1ciLCJhcHBjdHgiOiJ7XCJtc2V4Y2hwcm90XCI6XCJvd2FcIixcInB1aWRcIjpcIjM2MjkwOTQwMTQ5MDI4OFwiLFwic2NvcGVcIjpcIk93YURvd25sb2FkXCIsXCJvaWRcIjpcIjAwMDE0YTEwLTZkZjYtMjM3MC0wMDAwLTAwMDAwMDAwMDAwMFwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTI4MjctODQ0OTYtMTg0NDg0NzQ3MlwifSIsIm5iZiI6MTYxNTEyMTMwNiwiZXhwIjoxNjE1MTIxOTA2LCJpc3MiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2UwMC0wMDAwMDAwMDAwMDBAODRkZjllN2YtZTlmNi00MGFmLWI0MzUtYWFhYWFhYWFhYWFhIiwiYXVkIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2F0dGFjaG1lbnQub3V0bG9vay5saXZlLm5ldEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJoYXBwIjoib3dhIn0.hCyDTUfXZPrhAgGu1xd9HdA6YZSMQVVD2yGyTE1f10XmrGbORyN1zbNBmA4IVlGJ0CIKcUuYby9aAPY1ykdrdu31CYy88ubku_kSYXs4yopOXa7iC1RkOP5QTle3nBXw3GXqT08dMpDtQP3OkLKp2UEolMyXOm6EvYq7hAo2bYnkGGOOWDaFfeRR4HEQOMgAa5BogPc65gTlqteES1fKVmRdNZxasJU_KjcUkea9OSBR2SG5Hs4FZT_zH19L4zQWFni4yHONePfGYbT6feX-jufdrKUZEt3-07WUv3MhkW21kPv9qExW2rZjh3eXKmidZmzvAEcGOh27GetwleJKuw&X-OWA-CANARY=34Gsb7X9ckKot9lUQ__jydDHpVVn4dgYVP829jIVc07_voQa9rOuJSbDeIUnFosi5EuBkxkQGLY.&owa=outlook.live.com&scriptVer=20210301002.02&animation=true>] > > > > -Alan > > > > > > On 3/6/2021 8:33 PM, Ricardo Mejias wrote: > > I restarted the computer and re-ran this code and it crashed in the > > same place again. If you can show me what code I need to use to > > select the first 100 records of a file, I will do that for you to try > > this with my file. I already looked that up and tried it but it also > > crashed. > > > > GET /FILE = > > "E:\GNU_PSPP\FloridaTotalsFiles\SelectedAndAddedFields_20210209.sav" > > FILTER OFF. > > USE ALL. > > SELECT IF(NOT MISSING(BirthDate)). > > STRING ResidenceZipcodes (A5). > > COMPUTE ResidenceZipcodes=SUBSTR(ResidenceZipcode,1,5). > > DELETE VARIABLES ResidenceZipcode. > > NUMERIC EndDate (F10). /*Worked up to here. Crashes after that*/ > > COMPUTE EndDate = YRMODA(2021, 01, 31). > > EXECUTE. > > > > > > ________________________________ > > From: Alan Mead <amead2@alanmead.org><mailto:amead2@alanmead.org> > > Sent: Saturday, March 6, 2021 8:23 PM > > To: Ricardo Mejias > > <ricardomejias@hotmail.com><mailto:ricardomejias@hotmail.com>; > > pspp-users@gnu.org<mailto:pspp-users@gnu.org > > <mailto:pspp-users@gnu.org>> > > <pspp-users@gnu.org><mailto:pspp-users@gnu.org> > > Subject: Re: PROBLEM CREATING A DATE VARIABLE > > > > Sounds like PSPP or psppire is crashing, which shouldn't be happening. > > > > But I cannot replicate the issue. I opened a dataset in PSPP version > > GNU pspp 1.4.0-gc3c044 on Windows and I executed these lines: > > > > NUMERIC EndDate (F10). /*Worked up to here. > > Crashes on the next line*/ > > COMPUTE EndDate = YRMODA(2021, 01, 31). > > execute. > > > > And PSPP operated as expected. I see a new variable, EndDate, with a > > value of 160086 for all cases. > > > > How sure are you that your copy crashes with YRMODA()? > > > > It's also possible that your PSPP entered an unstable state for > > whatever reason. Maybe if you reboot your computer and restart PSPP it > > will not re-occur? > > > > I guess if it does continue to occur and you cannot send information > > to replicate the problem, I'd try running PSPP in batch mode from the > > command line, because if it is crashing, you will probably see an > > error message that you can report and which may allow the problem to > > be identified. Here's what I had to type: > > > > "C:\Program Files (x86)\PSPP\bin\pspp.exe" error.sps > > > > (WITH the double quotes). > > > > -Alan > > > > > > On 3/6/2021 6:06 PM, Ricardo Mejias wrote: > > The code below is applied to a file that already contains several > > variables, to which I want to add two more that I create (but it is > > too large to go through email and my attempts to select the first 100 > > records is not working either). When the code gets to COMPUTE EndDate > > = YRMODA(2021, 01, 31)., the program crashes with all of its windows > > disappearing from the screen. > > > > What am I doing wrong and what do I have to do to correct it? > > > > GET /FILE = > > "E:\GNU_PSPP\FloridaTotalsFiles\SelectedAndAddedFields_20210209.sav" > > FILTER OFF. > > USE ALL. > > SELECT IF(NOT MISSING(BirthDate)). > > > > STRING ResidenceZipcodes (A5). > > COMPUTE ResidenceZipcodes=SUBSTR(ResidenceZipcode,1,5). > > DELETE VARIABLES ResidenceZipcode. > > > > NUMERIC EndDate (F10). /*Worked up to here. > > Crashes on the next line*/ > > COMPUTE EndDate = YRMODA(2021, 01, 31). > > FORMAT EndDate (ADATE10). > > COMPUTE AgeInMonths = DATEDIFF(EndDate,BirthDate,'days') / (365.25*12). > > > > > > ________________________________ > > From: Pspp-users > > <pspp-users-bounces+ricardomejias=hotmail.com@gnu.org><mailto:pspp-users-bounces+ricardomejias=hotmail.com@gnu.org> > > on behalf of > > pspp-users-request@gnu.org<mailto:pspp-users-request@gnu.org> > > <pspp-users-request@gnu.org><mailto:pspp-users-request@gnu.org> > > Sent: Saturday, March 6, 2021 12:00 PM > > To: pspp-users@gnu.org<mailto:pspp-users@gnu.org > > <mailto:pspp-users@gnu.org>> > > <pspp-users@gnu.org><mailto:pspp-users@gnu.org> > > Subject: Pspp-users Digest, Vol 177, Issue 6 > > > > Send Pspp-users mailing list submissions to > > pspp-users@gnu.org<mailto:pspp-users@gnu.org > > <mailto:pspp-users@gnu.org>> > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://lists.gnu.org/mailman/listinfo/pspp-users > > <https://lists.gnu.org/mailman/listinfo/pspp-users> > > or, via email, send a message with subject or body 'help' to > > pspp-users-request@gnu.org<mailto:pspp-users-request@gnu.org> > > > > You can reach the person managing the list at > > pspp-users-owner@gnu.org<mailto:pspp-users-owner@gnu.org> > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of Pspp-users digest..." > > > > > > Today's Topics: > > > > 1. Re: Re: PSPP for windows. (Harry Thijssen) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Fri, 5 Mar 2021 21:25:20 +0100 > > From: Harry Thijssen > > <pspp4windows@gmail.com><mailto:pspp4windows@gmail.com> > > To: pspp-users <pspp-users@gnu.org><mailto:pspp-users@gnu.org>, Alan > > Mead <amead2@alanmead.org><mailto:amead2@alanmead.org> > > Subject: Re: Re: PSPP for windows. > > Message-ID: > > > > <CAMMrg9T14ARGayXSauZ_MhyMTv9NeP6Ld-+N9AW7O5XU-UtT4w@mail.gmail.com><mailto:CAMMrg9T14ARGayXSauZ_MhyMTv9NeP6Ld-+N9AW7O5XU-UtT4w@mail.gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > > > > > Date: Thu, 4 Mar 2021 19:31:19 -0600 > > > From: Alan Mead <amead2@alanmead.org><mailto:amead2@alanmead.org> > > > To: Gunnar Horrigmo > > <gunnar.horrigmo@usit.uio.no><mailto:gunnar.horrigmo@usit.uio.no>, > > pspp-users@gnu.org<mailto:pspp-users@gnu.org <mailto:pspp-users@gnu.org>> > > > Subject: Re: PSPP for windows. > > > > > [...] > > > > > Harry Thijssen had set up a process to cross-compile PSPP on Linux to > > > produce a windows package (and I think he also wrote the nullsoft > > > installer). > > > > > > Thanks Alan, but I don't earn the credits for the Nullsoft installer. I am > > just a user of it. :-) > > > > Stay safe > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210305/896bdab0/attachment.html > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210305/896bdab0/attachment.html>> > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > Pspp-users mailing list > > Pspp-users@gnu.org<mailto:Pspp-users@gnu.org <mailto:Pspp-users@gnu.org>> > > https://lists.gnu.org/mailman/listinfo/pspp-users > > <https://lists.gnu.org/mailman/listinfo/pspp-users> > > > > > > ------------------------------ > > > > End of Pspp-users Digest, Vol 177, Issue 6 > > ****************************************** > > > > > > -- > > > > Alan D. Mead, Ph.D. > > President, Talent Algorithms Inc. > > > > science + technology = better workers > > > > http://www.alanmead.org <http://www.alanmead.org> > > > > The irony of this ... is that the Internet is > > both almost-infinitely expandable, while at the > > same time constrained within its own pre-defined > > box. And if that makes no sense to you, just > > reflect on the existence of Facebook. We have > > the vastness of the internet and yet billions > > of people decided to spend most of them time > > within a horribly designed, fake-news emporium > > of a website that sucks every possible piece of > > personal information out of you so it can sell it > > to others. And they see nothing wrong with that. > > > > -- Kieren McCarthy, commenting on why we are not > > all using IPv6 > > > > > > > > -- > > > > Alan D. Mead, Ph.D. > > President, Talent Algorithms Inc. > > > > science + technology = better workers > > > > https://talalg.com <https://talalg.com> > > > > > > Ginsberg's Theorem: > > > > 0. There is a game. > > 1. You can't win. > > 2. You can't break even. > > 3. You can't even get out of the game. > > > > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210307/d7635ceb/attachment.html > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210307/d7635ceb/attachment.html>> > > -------------- next part -------------- > > A non-text attachment was scrubbed... > > Name: image.png > > Type: image/png > > Size: 64740 bytes > > Desc: image.png > > URL: > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210307/d7635ceb/attachment.png > > <https://lists.gnu.org/archive/html/pspp-users/attachments/20210307/d7635ceb/attachment.png>> > > > > ------------------------------ > > > > Subject: Digest Footer > > > > _______________________________________________ > > Pspp-users mailing list > > Pspp-users@gnu.org > > https://lists.gnu.org/mailman/listinfo/pspp-users > > <https://lists.gnu.org/mailman/listinfo/pspp-users> > > > > > > ------------------------------ > > > > End of Pspp-users Digest, Vol 177, Issue 10 > > ******************************************* > > -- > > Alan D. Mead, Ph.D. > President, Talent Algorithms Inc. > > science + technology = better workers > > http://www.alanmead.org > > The irony of this ... is that the Internet is > both almost-infinitely expandable, while at the > same time constrained within its own pre-defined > box. And if that makes no sense to you, just > reflect on the existence of Facebook. We have > the vastness of the internet and yet billions > of people decided to spend most of them time > within a horribly designed, fake-news emporium > of a website that sucks every possible piece of > personal information out of you so it can sell it > to others. And they see nothing wrong with that. > > -- Kieren McCarthy, commenting on why we are not > all using IPv6 > > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Pspp-users mailing list > Pspp-users@gnu.org > https://lists.gnu.org/mailman/listinfo/pspp-users > > > ------------------------------ > > End of Pspp-users Digest, Vol 177, Issue 14 > ******************************************* > > > > > > ------------------------------ Subject: Digest Footer _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org https://lists.gnu.org/mailman/listinfo/pspp-users ------------------------------ End of Pspp-users Digest, Vol 177, Issue 17 ******************************************* | ||||||||||||||
| [Prev in Thread] | Current Thread | [Next in Thread] |
