topic proc tabulate in Statistical Procedures

proc tabulate

clcl — Tue, 31 Jan 2012 19:23:29 GMT

cant seem to get this to work .. tried a few different ways and get get different errors .

452 proc tabulate data=q2;

453 class country;

454 var parcid payment costprice;

455

456 table country all,

457 parcid*n

458 payment*sum

459 costprice*sum

460 payment-costprice*sum;

---------

202

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, (, *, ',',

/, <, =, [, {.

ERROR 202-322: The option or parameter is not recognized and will be ignored.

461

Linlin — Tue, 31 Jan 2012 20:20:40 GMT

Hi,

Is this helpful?

proc tabulate data=sashelp.class;

class sex;

var height weight age;

table (sex all)*(height weight age)*(sum n);

run;

Linlin

clcl — Tue, 31 Jan 2012 20:23:22 GMT

no, i need to subtract: payment-costprice

Reeza — Tue, 31 Jan 2012 20:37:48 GMT

I don't think you can do that in proc tabulate, ie create a new variable, you'll need either proc report or a datastep.

I typically prefer a datastep but it's up to you.

clcl — Tue, 31 Jan 2012 20:47:53 GMT

i also dont think you can . but my prof. taught us today that you can, but his example does not work ....

Reeza — Tue, 31 Jan 2012 21:01:34 GMT

Then ask your prof to clarify or call Tech Support, they'll know the answer immediately.

clcl — Thu, 02 Feb 2012 06:54:09 GMT

FYI- you were correct !

shame that when i said it in class he did not listen to me . have a good day and thanks ! CL