PROC SQL

FEFE90 — Sat, 26 Oct 2019 00:03:32 GMT

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

Re: PROC SQL

PGStats — Sat, 26 Oct 2019 01:03:16 GMT

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;

topic Re: PROC SQL in SAS Procedures

PROC SQL

Re: PROC SQL