DATA Step, Macro, Functions and more

Number of one Variable with a condition

Reply
New Contributor
Posts: 4

Number of one Variable with a condition

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!

Super User
Posts: 5,429

Re: Number of one Variable with a condition

Posted in reply to smadlindl0
Not sure what you actually will count the frequency on.
What does uniquely identifies row in the input table?
Data never sleeps
Frequent Contributor
Posts: 123

Re: Number of one Variable with a condition

Posted in reply to smadlindl0

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.

 

Super User
Posts: 5,509

Re: Number of one Variable with a condition

Posted in reply to smadlindl0

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;

 

 

Super User
Posts: 10,028

Re: Number of one Variable with a condition

Posted in reply to smadlindl0

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;
Ask a Question
Discussion stats
  • 4 replies
  • 237 views
  • 0 likes
  • 5 in conversation