08-22-2017 08:51 AM
So in other words,
have a descriptive subject (other than the name of the SW we all are using), and and formulate the question so that your grand parents can understand it. Including sample have and want data.
08-22-2017 08:53 AM - edited 08-22-2017 08:54 AM
First of all, using "sas" as the subject for a question on the SAS forum is, ahem, not very informative.
Second, you seem to misunderstand the use of proc freq. There will only be one line of output (or one observation in the output dataset) for every single value in a given variable counted witrh proc freq, so nodupkey is useless.
If you only want to get a count (or list) of distinct values, do that in SQL:
proc sql; select distinct sex from sashelp.class; select count(distinct sex) from sashelp.class; quit;
08-22-2017 11:16 AM
Use two PROC FREQs or use DISTINCT in SQL.
/*This demonstrates how to count the number of unique occurences of a variable across groups. It uses the SASHELP.CARS dataset which is available with any SAS installation. The objective is to determine the number of unique car makers by origin/ Note: The SQL solution can be off if you have a large data set and these are not the only two ways to calculate distinct counts. If you're dealing with a large data set other methods may be appropriate.*/ *Count distinct IDs; proc sql; create table distinct_sql as select origin, count(distinct make) as n_make from sashelp.cars group by origin; quit; *Double PROC FREQ; proc freq data=sashelp.cars noprint; table origin * make / out=origin_make; run; proc freq data=origin_make noprint; table origin / out= distinct_freq; run; title 'PROC FREQ'; proc print data=distinct_freq; run; title 'PROC SQL'; proc print data=distinct_sql; run;