topic Re: Number of one Variable with a condition in SAS Programming

Number of one Variable with a condition

smadlindl0 — Mon, 23 May 2016 15:39:51 GMT

Hey!

This is my code up to now:

proc freq data=123;
table issr_id;
where def=1;
run;

I want to know the total number of issr_id with the condition def=1.

But the Problem is, there are some issr_id with have more then one def=1.

How can I get the total number of issr_id with def=1, without issr_id with the same number are counted muliple times?

Hope you get my question.

Thanks!

Re: Number of one Variable with a condition

LinusH — Mon, 23 May 2016 15:57:47 GMT

Not sure what you actually will count the frequency on.
What does uniquely identifies row in the input table?

Re: Number of one Variable with a condition

JediApprentice — Mon, 23 May 2016 16:05:41 GMT

It sounds like you're trying to get a frequency of unique issr_ids. Am I correct in assuming this? If so, before you do the proc freq, you could use PROC SQL and select distinct issr_ids, or a datastep and use by group processing to filter out issr_ids that are identical. Hope this helps.

Re: Number of one Variable with a condition

Astounding — Mon, 23 May 2016 16:06:34 GMT

It sounds like you are looking for just a single number as the output. If so, this might do it:

proc sql;

select count(distinct(issr_id)) from have where def=1;

quit;

Re: Number of one Variable with a condition

Ksharp — Tue, 24 May 2016 02:22:13 GMT

Then pick up the first obs wthin each group firstly.

proc sort data=123 out=_123 nodupkey;
 by def;
run;

proc freq data=_123;
table issr_id;
where def=1;
run;