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
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
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 . 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 <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> <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> <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-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>
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <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>
------------------------------
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 10
*******************************************
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: 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 . 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 <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> <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> <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-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>
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <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>
------------------------------
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 10
*******************************************
