BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
FEFE90
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
PGStats
Opal | Level 21

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;
PG

View solution in original post

1 REPLY 1
PGStats
Opal | Level 21

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;
PG

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 381 views
  • 0 likes
  • 2 in conversation