macro to create CTABLE

[nuptse]

 

I am trying to write a macro to create a series of custom tables in SPSS. I used the following macro but it does not work. Any suggestions are highly appreciated.

 

Thanks

 

DEFINE !CustomTabs(!POSITIONAL !TOKENS(1))

 

*DATASET ACTIVATE PrePostMeasures.

CTABLES

  /VLABELS VARIABLES=location prepost 1! DISPLAY=LABEL

  /TABLE BY location [C] > prepost [C] BY 1! [S][MEAN F40.2, STDDEV F40.2, COUNT F40.0]

  /SLABELS POSITION=ROW

  /CATEGORIES VARIABLES=location prepost ORDER=A KEY=VALUE EMPTY=INCLUDE

  /TITLES

    TITLE='Mean and Standard Deviation of var1 by Location and Pre-Post Status'.

!ENDDEFINE.

 

!CustomTabs var1.

 

 

Error Message:

 

Error # 6846 in column 39.  Text: !

A macro expression includes an undefined macro variable or a macro operator

which is not valid within an expression.

Execution of this command stops.

 

Error # 6846 in column 43.  Text: !

A macro expression includes an undefined macro variable or a macro operator

which is not valid within an expression.

 

 

-- 
Dinesh Sharma, Ph.D.
Department of Mathematics and Statistics
321 Roop Hall, MSC 1911
James Madison University
Harrisonburg, VA 22807

Ph: [phone]
Fax: [phone]

 

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

[Bruce Weaver]

Have you tried this?

SET MPRINT ON.
!CustomTabs var1.
SET MPRINT OFF.

Sharma, Dinesh Raj - sharmadr wrote

I am trying to write a macro to create a series of custom tables in SPSS. I used the following macro but it does not work. Any suggestions are highly appreciated.

Thanks

DEFINE !CustomTabs(!POSITIONAL !TOKENS(1))

*DATASET ACTIVATE PrePostMeasures.
CTABLES
  /VLABELS VARIABLES=location prepost 1! DISPLAY=LABEL
  /TABLE BY location [C] > prepost [C] BY 1! [S][MEAN F40.2, STDDEV F40.2, COUNT F40.0]
  /SLABELS POSITION=ROW
  /CATEGORIES VARIABLES=location prepost ORDER=A KEY=VALUE EMPTY=INCLUDE
  /TITLES
    TITLE='Mean and Standard Deviation of var1 by Location and Pre-Post Status'.
!ENDDEFINE.

!CustomTabs var1.


Error Message:

Error # 6846 in column 39.  Text: !
A macro expression includes an undefined macro variable or a macro operator
which is not valid within an expression.
Execution of this command stops.

Error # 6846 in column 43.  Text: !
A macro expression includes an undefined macro variable or a macro operator
which is not valid within an expression.


--
Dinesh Sharma, Ph.D.
Department of Mathematics and Statistics
321 Roop Hall, MSC 1911
James Madison University
Harrisonburg, VA 22807

Ph: [phone]
Fax: [phone]


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

[David Marso]

Houston we have a problem ;-)
Correct usage is NOT 1! it would be !1 .
Please refer to the documentation for additional examples.

[Bruce Weaver]

Well spotted, Hawkeye!  ;-)

David Marso wrote

Houston we have a problem ;-)
Correct usage is NOT 1! it would be !1 .
Please refer to the documentation for additional examples.

[Jignesh Sutar]

If you are going to create a macro to parameterise the input variable name then you may want to also do so in the CTABLE TITLE, so if the macro is re-used for anything else other than Var1  then the appropriate variable will be indicated in the title.

 For which you would use something like this:


/TITLES TITLE=!QUOTE(!CONCAT('Mean and Standard Deviation of ', !1, 'by Location and Pre-Post Status')).