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 ... View more

Hi, Can anyone help me solve this question? I am not sure where I am mistaken.   Q : HOW MANY FIRM HAVING AVERAGE COMMON EQUITY/TOTAL ASSET RATIO GREATER THAN 50%?      data TOPCOM_TIC; set Q_COMP_SHORT10_18; keep TIC CEQQ ATQ COM_EQ; COM_EQ = CEQQ/ATQ; run; proc sort data=TOPCOM_TIC ;   BY descending TIC COM_EQ; RUN;  proc means data=TOPCOM_TIC; var COM_EQ ; BY TIC ; output out=avg_CE mean=avg_CE_TIC; run; Proc freq data=TOPCOM_TIC; by COM_EQ ; table TIC /out=Q6; run; data Q6; set Q6; if COM_EQ>=50 ; run; Thank you ... View more

Hello,   I am new in SAS and having hard time figuring out freq and sort procedures. Please assist me with the following questions:   Which industry code has the most records in file Q_COMP_SHORT10_18?     Which State has the most records in file Q_COMP_SHORT10_18?   Find the Top100 records with the highest average inventory turnover?   I am not sure if the industry code is SIC or TIC ?   Thank you ... View more