Hi everyone,

I've been using SPSS for years by writing raw commands in the syntax editor, and would like to improve my output formatting. Could anyone help with the questions below?

For the sample commands below, how do I?

Q1) Include commas for all N output in Descriptives, Summarize, or Crosstab commands?

Q2) Format Currency amounts with $, commas, and 2

rounded decimal places?

I think this command is close, but will truncate instead of rounding.

PRINT FORMATS FirstVariable TO LastVARIABLE (DOLLAR12.2)

I want to apply this format to all Min, Max, Mean, and Sum amounts for the three commands above.

Q3) Is there a better way to produce simpler output statements than our standard syntax below?

We repeat this same format for around 20 different criteria variations, and never want these statements to permanently transform the data.

We always pull 3 columns of data

1) All full-time students

2) All part-time students.

3) Full-time Freshman

We only pull student counts or amounts (Mean or SUM).

Example syntax:

*******************************************

COUNTS

*******************************************

TITLE Counts - All Students by Full/Part Time Status.

SELECT IF (APPLIED EQ 1).

CROSSTABS TABLES=APPLIED BY FTPT.

TITLE Counts - Full-time Freshman.

TEMPORARY.

SELECT IF (APPLIED EQ 1).

SELECT IF (GradLevel = 'Freshman').

SELECT IF (FTPT EQ 'Full-time').

FREQUENCIES VARIABLES=FTPT.

**********************************

AMOUNTS

**********************************

*$ All students by Full/Part Time Status.

TITLE All Students.

TEMPORARY.

SELECT IF (APPLIED EQ 1).

SELECT IF (AidAmounts GT 0).

SUMMARIZE TABLES= AidAmounts BY FTPT

/CELLS=MEAN COUNT MIN MAX.

*$ for full-time Freshman.

TITLE Freshman Data.

TEMPORARY.

SELECT IF (APPLIED EQ 1).

SELECT IF (GradLevel = 'Freshman').

SELECT IF (FTPT EQ 'Full-time').

SUMMARIZE TABLES= AidAmounts

/CELLS=MEAN COUNT MIN MAX.

Dave

------------------------------

David Horne

------------------------------