Unique Count

[JoaoPinto]

Is there anyway to count unique instances?

Other than doing

DEFINE FILE WEEK1
COUNTNUM/I9 = IF LAST ROLOC NE ROLOC THEN 1 ELSE 0;
END

And summing COUNTNUM?

 

[GrSw]

Use DST. prefix operator, e.g.:

TABLE FILE MOVIES
COUNT DST.CATEGORY
END

Grzegorz

 

[JoaoPinto]

Thanks a lot. Is there anyway to add a label to that?
eg.
COUNT DST.CATEGORY AS 'My Label is this'

The above doesn't seem to work?

 

[GrSw]

Probably a typo - it works for me:

TABLE FILE MOVIES
COUNT DST.CATEGORY AS 'My Label is this'
END