I am writing a piece of code in the Syntax of SPSSstatistics. The code is the following.
GET DATA /TYPE=XLSX
/FILE='file'
/SHEET=name 'Sheet2'
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
EXECUTE.
DATASET NAME DataSet1 WINDOW=FRONT.
RANK VARIABLES= WA CI (D) /RANK /PRINT=YES /TIES=MEAN.
SELECT IF( RWA EQ '1' AND RCI EQ '1').
The problem is at the last line of the above code. SPSS selects the right data and then, SPSS creates two variables called RWA and RCI. SO far, things are fine. Then, SPSS should select cases only when the two variables assume value 1 and 1 simultaneously. Unfortunately it doesn't work. Am I wrong somewhere?
Thanks. Francesco
Francesco Ciardiello, sorry to hear about your problem. Perhaps it would help if you indicated why you think that SPSS isn't working. What happens, for example?
Francesco Ciardiello
If you are expecting to find several cases with rank 1 in at least one of your variables, the RWA EQ '1' AND RCI EQ '1 condition is not possible because the RANK instruction with the TIES = MEAN option will not allow you to have the value 1 Try the RANK statement with the TIES = LOW option.
Jorge Ortiz Pinilla, I am looking for a single case such that the two variables RWA and RCI assumes (both of them) value 1. Because RWA and RCI are rankings, such occurence should be unique (if lucky). Therefore the code SELECT IF( RWA EQ '1' AND RCI EQ '1'). should select NO cases or (if lucky) 1 case. Mainly it is the classical TOP rank correlation between two ordinal variables. Actually, when I try to run the code, nothing is selected in the output file; I have tried with a file where the case with values (1,1) exists. I have tried your option but the outcome is the same.
Robert Trevethan The code selects the right columns from the EXCEL file. The code forms two variables RWA and RCI in the output file. At that point, I should find the selection of one single case but nothing happens. It seems like the command SELECT IF (see the code above) is completely neglected by the SYNTAX of SPSS. For sure i have made some errors somewhere in the code. I have tried also this version SELECT IF( RWA EQ '1.000' AND RCI EQ '1.000'). Considering the structure of the VARIABLES RWA and RCI. Again nothing happens!
Francesco Ciardiello, I'm sorry if it seems I'm abandoning you, but I can't get a clear indication about what your problem is in relation to SPSS. I hope others can help you.
All the best for success!
Francesco Ciardiello maybe you need to use SELECT IF( RWA EQ 1 AND RCI EQ 1) without the quotes
Jorge Ortiz Pinilla nisba! :-( The outcome is always the same.
Francesco Ciardiello
Please give me some of your data to examine the problem more closely.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS