Hi all, when you run MISSING VALUES ALL (-99, -77). you'll get an error if there are numeric as well as string variables in the dataset. This makes no sense in my opinion as -99 cannot be a string anyway. I think it would be helpful to let SPSS know that ALL in this context means all numeric variables. Alternatively, introducing a new keyword ALLNUMERIC would stop this annoying behavior. Does anybody know an easy way without Python to make SPSS define mv for all numeric variables with one command? Thanks for any ideas, Mario. |
Use the SPSSINC SELECT VARIABLES extension command, which is installed with Statistics unless you choose to exclude Python. ( SPSSINC SELECT VARIABLES MACRONAME="!numeric" /PROPERTIES TYPE=NUMERIC. MISSING VALUES !numeric(-99 -77). On Tue, Jun 20, 2017 at 9:34 AM, Mario Giesel <[hidden email]> wrote:
|
In reply to this post by spss.giesel@yahoo.de
This is indeed some inconvenience. I suggested, officially, SPSS to
introduce keywords ALLNUM and ALLSTR as reserved words, like ALL,
back in 2003.
It has never been implemented. 20.06.2017 18:34, Mario Giesel пишет:
===================== 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 Jon Peck
Sorry, incomplete message got away. Use the SPSSINC SELECT VARIABLES extension command, which is installed with Statistics unless you choose to exclude Python. (It is implemented in Python, but you don't need to write any Python.) This creates a macro listing the variables with the selected properties - here numeric. The command has many additional ways to select the variables such as measurement level and patterns in names. It appears on Utilities as Define Variable Macro. SPSSINC SELECT VARIABLES MACRONAME="!numeric" /PROPERTIES TYPE=NUMERIC. MISSING VALUES !numeric(-99 -77). On Tue, Jun 20, 2017 at 9:44 AM, Jon Peck <[hidden email]> wrote:
|
Administrator
|
In reply to this post by Kirill Orlov
I agree that these would be very useful additions to native SPSS.
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
In reply to this post by spss.giesel@yahoo.de
And, FYI, it still hasn't been incorporated with the new V25 beta under test So, let's keep asking Will > On 6/20/2017 2:11:40 PM, Bruce Weaver ([hidden email]) wrote: |
In reply to this post by Bruce Weaver
There are plenty of other classifications of variables that would be useful in selecting variables such as ALLSCALE and ALLCATEGORICAL along with qualifiers in name patterns, e.g., all variable names containing AGE, custom attributes etc. And these can be used together. That's why I created SPSSINC SELECT VARIABLES to provide a general mechanism that can be used anywhere a variable selection is needed. And since it accommodates custom user attributes, it is open to users making up their own categories, e.g., all demographic variables). Adding reserved words breaks jobs, so it is really a last resort. With customers who have thousands of SPSS jobs, this is not a minor matter. Of course, I am just a customer now, so I have no official say in the matter. On Tue, Jun 20, 2017 at 12:11 PM, Bruce Weaver <[hidden email]> wrote: I agree that these would be very useful additions to native SPSS. |
In reply to this post by spss.giesel@yahoo.de
Right after posting this Jon reminded us about one of his extensions that might help W " ---------------------------- On 6/20/2017 3:29:20 PM, Jon Peck ([hidden email]) wrote There are plenty of other classifications of variables that would be useful in selecting variables such as ALLSCALE and ALLCATEGORICAL along with qualifiers in name patterns, e.g., all variable names containing AGE, custom attributes etc. And these can be used together. That's why I created SPSSINC SELECT VARIABLES to provide a general mechanism that can be used anywhere a variable selection is needed. And since it accommodates custom user attributes, it is open to users making up their own categories, e.g., all demographic variables). Adding reserved words breaks jobs, so it is really a last resort. With customers who have thousands of SPSS jobs, this is not a minor matter. Of course, I am just a customer now, so I have no official say in the matter. ------------" > On 6/20/2017 3:12:20 PM, Willbaileyz @ E ([hidden email]) wrote: |
Thanks to all! Jon, SPSSINC SELECT VARIABLES works well. How can I access a documentation for this or other extension commands? Thanks again! Mario "Willbaileyz @ E" <[hidden email]> schrieb am 23:52 Dienstag, 20.Juni 2017: Right after posting this Jon reminded us about one of his extensions that might help W " ---------------------------- On 6/20/2017 3:29:20 PM, Jon Peck ([hidden email]) wrote There are plenty of other classifications of variables that would be useful in selecting variables such as ALLSCALE and ALLCATEGORICAL along with qualifiers in name patterns, e.g., all variable names containing AGE, custom attributes etc. And these can be used together. That's why I created SPSSINC SELECT VARIABLES to provide a general mechanism that can be used anywhere a variable selection is needed. And since it accommodates custom user attributes, it is open to users making up their own categories, e.g., all demographic variables). Adding reserved words breaks jobs, so it is really a last resort. With customers who have thousands of SPSS jobs, this is not a minor matter. Of course, I am just a customer now, so I have no official say in the matter. ------------" > On 6/20/2017 3:12:20 PM, Willbaileyz @ E ([hidden email]) wrote: > > And, FYI, it still hasn't been incorporated with the new V25 beta under test > > > > So, let's keep asking > > Will > > > On 6/20/2017 2:11:40 PM, Bruce Weaver ([hidden email]) wrote: > > > I agree that these would be very useful additions to native SPSS. > > > > > > Kirill Orlov wrote > > > This is indeed some inconvenience. I suggested, officially, SPSS to > > > introduce keywords ALLNUM and ALLSTR as reserved words, like ALL, back > > > in 2003. > > > It has never been implemented. > > > > > > > > > 20.06.2017 18:34, Mario Giesel пишет: > > >> > > >> when you run > > >> > > >> MISSING VALUES ALL (-99, -77). > > >> > > >> you'll get an error if there are numeric as well as string variables > > >> in the dataset. > > >> > > >> This makes no sense in my opinion as -99 cannot be a string anyway. > > >> I think it would be helpful to let SPSS know that ALL in this context > > >> means all numeric variables. > > >> Alternatively, introducing a new keyword ALLNUMERIC would stop this > > >> |
Ah, I found it: SPSSINC SELECT VARIABLES /HELP. Right? Thanks, Mario Mario Giesel <[hidden email]> schrieb am 10:36 Mittwoch, 21.Juni 2017: Thanks to all! Jon, SPSSINC SELECT VARIABLES works well. How can I access a documentation for this or other extension commands? Thanks again! Mario "Willbaileyz @ E" <[hidden email]> schrieb am 23:52 Dienstag, 20.Juni 2017: Right after posting this Jon reminded us about one of his extensions that might help W " ---------------------------- On 6/20/2017 3:29:20 PM, Jon Peck ([hidden email]) wrote There are plenty of other classifications of variables that would be useful in selecting variables such as ALLSCALE and ALLCATEGORICAL along with qualifiers in name patterns, e.g., all variable names containing AGE, custom attributes etc. And these can be used together. That's why I created SPSSINC SELECT VARIABLES to provide a general mechanism that can be used anywhere a variable selection is needed. And since it accommodates custom user attributes, it is open to users making up their own categories, e.g., all demographic variables). Adding reserved words breaks jobs, so it is really a last resort. With customers who have thousands of SPSS jobs, this is not a minor matter. Of course, I am just a customer now, so I have no official say in the matter. ------------" > On 6/20/2017 3:12:20 PM, Willbaileyz @ E ([hidden email]) wrote: > > And, FYI, it still hasn't been incorporated with the new V25 beta under test > > > > So, let's keep asking > > Will > > > On 6/20/2017 2:11:40 PM, Bruce Weaver ([hidden email]) wrote: > > > I agree that these would be very useful additions to native SPSS. > > > > > > Kirill Orlov wrote > > > This is indeed some inconvenience. I suggested, officially, SPSS to > > > introduce keywords ALLNUM and ALLSTR as reserved words, like ALL, back > > > in 2003. > > > It has never been implemented. > > > > > > > > > 20.06.2017 18:34, Mario Giesel пишет: > > >> > > >> when you run > > >> > > >> MISSING VALUES ALL (-99, -77). > > >> > > >> you'll get an error if there are numeric as well as string variables > > >> in the dataset. > > >> > > >> This makes no sense in my opinion as -99 cannot be a string anyway. > > >> I think it would be helpful to let SPSS know that ALL in this context > > >> means all numeric variables. > > >> Alternatively, introducing a new keyword ALLNUMERIC would stop this > > >> |
Also, you can put the cursor on an instance of the command in the Syntax Editor and press F1 for help just as you can for built-in commands. This works in V23 or later. The Extensions menu, V24+ or Utilities > Extension Bundles > Download and Install... in V22-23 will show you a list of all the available extensions. The V24 display is much nicer than the older one. On Wed, Jun 21, 2017 at 3:02 AM, Mario Giesel <[hidden email]> wrote:
|
Free forum by Nabble | Edit this page |