CODEWITHSUNDEEP
spss
Tony
Tony

Reputation: 69

Listing two or more variables alongside each other

I want an alternative to running frequency for string variables because I also want to get a case number for each of the string value (I have a separate variable for case ID).

After reviewing the string values I will need to find them to recode which is the reason I need to know the case number.

I know that PRINT command should do what I want but I get an error - is there any alternative?

PRINT /  id var2 .
EXECUTE.


>Error # 4743.  Command name: PRINT
>The line width specified exceeds the output page width or the record length or
>the maximum record length of 2147483647.  Reduce the number of variables or
>split the output line into several records.
>Execution of this command stops.

Upvotes: 3

Views: 79

Answers (1)

Jignesh Sutar
Jignesh Sutar

Reputation: 2929

Try the LIST command.

I often use the TEMPORARY commond prior to the LIST command, as often there is only a small select of record of interest I may want to "list"/investigate.

For example, in the below, only to list the records where VAR2 is not a blank string.

TEMP.
SELECT IF (len(VAR2)>0).
LIST ID VAR2.

Alternatively, you could also (but dependent on having CUSTOM TABLES add-on module), do something like below which would get the results into a tabular format also (which may be preferable if then exporting to Excel, for example.

CTABLES /TABLE CTABLES /VLABELS VARIABLES=ALL DISPLAY=NONE
  /TABLE A[C]>B[C]
  /CATEGORIES VARIABLES=ALL EMPTY=EXCLUDE.

Upvotes: 2

Related Questions