Quantcast

Filtering within cases/variables

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Filtering within cases/variables

Darko_Giac
Hi all,

I'm currently working with a dataset and am looking for a way to filter between two variables, but only list the frequencies of certain cases that are mapped to others. For example, I have a "prog" variable and a "code" variable. There are hundreds of "prog" cases, but only four cases under the "code" variable.

So there is an "art1, art2 and art3" case under "prog", each of which should be mapped to "ADGR" within "code". There is also a "UNI" and "LOCH" code. I was wondering if there was a way (perhaps through syntax) to display where those "art" cases appear, (do they appear in ADGR and UNI, or just ADGR).

As always, any help would be greatly appreciated.

Thanks!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Filtering within cases/variables

David Marso
Administrator

The fact that no one has responded is indicative of the possibility that your question is vague.
Posting an example of some existing cases and the desired outcome is likely a good next step for you.
====
Darko_Giac wrote
Hi all,

I'm currently working with a dataset and am looking for a way to filter between two variables, but only list the frequencies of certain cases that are mapped to others. For example, I have a "prog" variable and a "code" variable. There are hundreds of "prog" cases, but only four cases under the "code" variable.

So there is an "art1, art2 and art3" case under "prog", each of which should be mapped to "ADGR" within "code". There is also a "UNI" and "LOCH" code. I was wondering if there was a way (perhaps through syntax) to display where those "art" cases appear, (do they appear in ADGR and UNI, or just ADGR).

As always, any help would be greatly appreciated.

Thanks!
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
|  
Report Content as Inappropriate

Re: Filtering within cases/variables

Rich Ulrich
In reply to this post by Darko_Giac

The only way that I have found to make sense of this is to read "cases" as "values".


Then:  You want to know if the values [art1, art2, art3] -- just these 3, among hundreds of

possible values for Prog -- are associated with the Code value of ADGR in particular.   And display it.


The simple way for display would seem to be to LIST CASES after sorting the file and selecting cases:


Select if  any(Prog, "art1", "art2","art3").

Sort cases  by CODE, PROG.


  and list, for the display.


FILTER is safer, if you want to continue using the same file and selection.


--

Rich Ulrich



From: SPSSX(r) Discussion <[hidden email]> on behalf of Darko_Giac <[hidden email]>
Sent: Monday, October 17, 2016 3:33 PM
To: [hidden email]
Subject: Filtering within cases/variables
 
Hi all,

I'm currently working with a dataset and am looking for a way to filter
between two variables, but only list the frequencies of certain cases that
are mapped to others. For example, I have a "prog" variable and a "code"
variable. There are hundreds of "prog" cases, but only four cases under the
"code" variable.

So there is an "art1, art2 and art3" case under "prog", each of which should
be mapped to "ADGR" within "code". There is also a "UNI" and "LOCH" code. I
was wondering if there was a way (perhaps through syntax) to display where
those "art" cases appear, (do they appear in ADGR and UNI, or just ADGR).

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