string length limitation

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

string length limitation

Mumdzhiev
Hi all,

My question is about going beyond the spss string length limitation to 32 k
i worked nicely within, but unfortunately couldn’t go over the 32 kb limit size for strings in spss, fe for really long var lists as a macro and other stuff; its not only referring to loops fe for frequencies (1000 var maximum), so please consider this more generally,
Is it likely to cover this easy in python, and can you recommend some further strategies for handling such a limit?
Do they apply to the server version also?
Ill be thankful for any comments/replies.
Milko
Reply | Threaded
Open this post in threaded view
|

Re: string length limitation

Jon K Peck
Please provide more detail on what you are trying to do.  The 32K limit applies specifically to the maximum width of a string variable.  I have seen some really long commands, but I doubt that I have ever seen one command that was more than 32K.  I don't know of any limit on the length of a command, although there is a line length limit of 251 beyond which wrapping is required.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621




From:        Mumdzhiev <[hidden email]>
To:        [hidden email],
Date:        01/22/2014 09:58 AM
Subject:        [SPSSX-L] string length limitation
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Hi all,

My question is about going beyond the spss string length limitation to 32 k
i worked nicely within, but unfortunately couldn’t go over the 32 kb limit
size for strings in spss, fe for really long var lists as a macro and other
stuff; its not only referring to loops fe for frequencies (1000 var
maximum), so please consider this more generally,
Is it likely to cover this easy in python, and can you recommend some
further strategies for handling such a limit?
Do they apply to the server version also?
Ill be thankful for any comments/replies.
Milko




--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/string-length-limitation-tp5724065.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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


Reply | Threaded
Open this post in threaded view
|

Re: string length limitation

David Marso
Administrator
In reply to this post by Mumdzhiev
You should be very happy that strings are supported to that length.
The limit used to be 255 characters.
Have you thought perhaps to use 2 strings?
I can't imagine what you are trying to do in my wildest imagination.
Many here can attest to the extent to which my imagination runs wild.
Be describe and be specific what you are attempting to do.
The manner in which you are trying to do it is likely ridiculous.

Mumdzhiev wrote
Hi all,

My question is about going beyond the spss string length limitation to 32 k
i worked nicely within, but unfortunately couldn’t go over the 32 kb limit size for strings in spss, fe for really long var lists as a macro and other stuff; its not only referring to loops fe for frequencies (1000 var maximum), so please consider this more generally,
Is it likely to cover this easy in python, and can you recommend some further strategies for handling such a limit?
Do they apply to the server version also?
Ill be thankful for any comments/replies.
Milko
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: string length limitation

Mumdzhiev
Thanks Jon, David,

we were testing the SPSSINC SELECT VARIABLES extension on recent spss versions, while exporting many many varlists, and this is really a very fine way to capture them all in a macro, but on long varlists (more than 10000 items) got always the error massage for the string length limit;
the question was to improve the classical oms export to sav, with some given constraints as fe not being able to flip aso because of memory issues, not all spss modules are available, given different spss versions, and how to  organize the whole thing; there may be lot of options as split datasets or varlists in product categories and sort of, handling the error massage on the extension tool was another; i was wondering if the string list from the SELECT VARIABLES macro could make it

Milko

Reply | Threaded
Open this post in threaded view
|

Re: string length limitation

Mumdzhiev
Hi Jon,

thanks for replying.
Heres the syntax for the extension run which runs on shorter lists.

SPSSINC SELECT VARIABLES MACRONAME="!allvars"
/PROPERTIES LEVEL=NOMINAL
ROLE=ANY
/OPTIONS ORDER=FILE PRINT=YES IFNONE=ERROR SEPARATOR=" ".

the note:

Variables Listed in Macro !allvars
***A string goes here that exceeds 32,767 bytes***

then, the macro !allvars istn available.

It would be great if you solve this!!!

Milko

Reply | Threaded
Open this post in threaded view
|

Re: string length limitation

Jon K Peck
I am still not quite clear on when the error appears.  Do you get an error when the SELECT VARIABLES code is run, i.,e., when the macro is defined, or do you get it when you attempt to use the macro.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621




From:        Mumdzhiev <[hidden email]>
To:        [hidden email],
Date:        01/23/2014 02:08 AM
Subject:        Re: [SPSSX-L] string length limitation
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Hi Jon,

thanks for replying.
Heres the syntax for the extension run which runs on shorter lists.

SPSSINC SELECT VARIABLES MACRONAME="!allvars"
/PROPERTIES LEVEL=NOMINAL
ROLE=ANY
/OPTIONS ORDER=FILE PRINT=YES IFNONE=ERROR SEPARATOR=" ".

the note:

Variables Listed in Macro !allvars
***A string goes here that exceeds 32,767 bytes***

then, the macro !allvars istn available.

It would be great if you solve this!!!

Milko





--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/string-length-limitation-tp5724065p5724092.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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