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! |
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. ====
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?" |
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). |
Free forum by Nabble | Edit this page |