About SLK

SLK · ‎03-30-2017

They only have to be unique per year so a person can drink beer one year and wine the other.

SLK · ‎03-24-2017

Thanks! I didn't quite work. I used the following code (as I also had to group by other variable) proc sql; create table want as select year, variable, count(distinct ID) from data group by year, variable ; quit;

MichelleHomes · ‎03-23-2017

Good to hear your issue is resolved. Please explain for others who may find this post in future your steps you took to resolve. Could you also mark the solution as resolved.

JuanS_OCS · ‎03-08-2017

Hello @SLK, as far as I know, you can only use a table once, or optimize your Star Schema query. Although probably other colleagues might bring better ideas. I suggest you to wait a bit longer, maybe you will get a better answer in this case. Kind regards, Juan

MichelleHomes · ‎03-07-2017

You can using a Text Object with including images and text.

Online Status	Offline
Date Last Visited	‎03-30-2017 02:32 AM

Re: How to count distinct by two variables using proc sql

How to count distinct by two variables using proc sql

Re: How to count the frequency of a value by unique ID's

How to count the frequency of a value by unique ID's

Re: My Visualization filters are missing from my Report Designer

Re: My Visualization filters are missing from my Report Designer

Re: My Visualization filters are missing from my Report Designer

Re: My Visualization filters are missing from my Report Designer

My Visualization filters are missing from my Report Designer

Re: How to show display rules in report

Re: How to count distinct by two variables using proc sql

Re: How to count the frequency of a value by unique ID's

Re: My Visualization filters are missing from my Report Designer

Re: How to use the same input table more than once when making a lasr ...

Re: How to show display rules in report