PROC SQL

[FEFE90]

Hello,

I am having trouble understanding the question below, please check my code. Is it right to use proc sql? if yes what the next step should be? 

*  How many firms having less than 3 rows in Q_COMP_SHORT10_18 and at the same time belonging to EXCHCD of 1 or 3 ;

	proc sql;
	create table Q9
	as select Q_COMP_SHORT10_18.TIC, Ticker_info.EXCHCD
	from Q_COMP_SHORT10_18 left join Ticker_info
	on Q_COMP_SHORT10_18.TIC = Ticker_info.TICKER;
	quit;

Thank you

[PGStats · Accepted solution]

Assuming there is only one row per TICKER value in Ticker_info, try something like:

proc sql;
create table Q9 as 
select 
	a.TIC, 
	b.EXCHCD
from 
	Q_COMP_SHORT10_18 as a left join 
	Ticker_info as b
		on a.TIC = b.TICKER
where b.EXCHCD in (1,3)
group by a.TIC
having count(*) < 3;
quit;