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
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;
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: