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 <am...@alanmead.org> Sent: Saturday, March 6, 2021 11:31 PM To: Ricardo Mejias <ricardomej...@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 . 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] 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] -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 <ame...@alanmead.org><mailto:ame...@alanmead.org> Sent: Saturday, March 6, 2021 8:23 PM To: Ricardo Mejias <ricardomej...@hotmail.com><mailto:ricardomej...@hotmail.com>; 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....@gnu.org><mailto:pspp-users-bounces+ricardomejias=hotmail....@gnu.org> on behalf of pspp-users-requ...@gnu.org<mailto:pspp-users-requ...@gnu.org> <pspp-users-requ...@gnu.org><mailto:pspp-users-requ...@gnu.org> Sent: Saturday, March 6, 2021 12:00 PM To: 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> 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-requ...@gnu.org<mailto:pspp-users-requ...@gnu.org> You can reach the person managing the list at pspp-users-ow...@gnu.org<mailto:pspp-users-ow...@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 <pspp4wind...@gmail.com><mailto:pspp4wind...@gmail.com> To: pspp-users <pspp-users@gnu.org><mailto:pspp-users@gnu.org>, Alan Mead <ame...@alanmead.org><mailto:ame...@alanmead.org> Subject: Re: Re: PSPP for windows. Message-ID: <cammrg9t14argayxsauz_mhymtv9nep6ld-+n9aw7o5xu-ut...@mail.gmail.com><mailto:cammrg9t14argayxsauz_mhymtv9nep6ld-+n9aw7o5xu-ut...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" > > Date: Thu, 4 Mar 2021 19:31:19 -0600 > From: Alan Mead <ame...@alanmead.org><mailto:ame...@alanmead.org> > To: Gunnar Horrigmo > <gunnar.horri...@usit.uio.no><mailto:gunnar.horri...@usit.uio.no>, > 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> ------------------------------ Subject: Digest Footer _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org<mailto:Pspp-users@gnu.org> 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 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 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.
