02-27-2015 02:02 PM
Not sure what your asking but, if the answer is 3 and your dataset is called have, then the following would work:
select count(distinct guestnumber)
02-27-2015 02:51 PM
Please look at fourth line. This is what I want to do. Under the heading 'Count Distinct_of_GuestNumber'n*, I want to show the count of distinct. And I know that code does not work for Proc Tabulate.
02-27-2015 03:17 PM
You didn't show any date-related field in your example data. What is the field called and what does it contain?
If it is a date, and your field is called date, you might be able to use something like:
create table want as
select count(distinct guestnumber) as number,
month(date) as month
group by month(date)
02-27-2015 04:32 PM
Hi, your advice is helpful. The report requires to look like a table using EG tool, Summary Tables. Under the column Count Distinct_of_GuestNumber, it actually has number of counts. I want distinct counts of GuestNumber. Is it possible using Summary Tables?
02-27-2015 04:38 PM
Run the summary table task twice, the first time save the output to a dataset and the second time use the output from the first run as your input.
The first one generates a unique guest/day record, the second will count the number of unique guests.
02-27-2015 05:03 PM
I tried that but could not seem to make it work. How would I exactly do it?
I saved it as a dataset.
Then redo the Summary Tables again. It does not gave a count of distinct GuestNumber.
Can I have Distinct available in Available Statistics in Summary Tables;