Hi everyone, I want to delete rows of TICKERs with all RETURNs missing. For example, say I have a table of the form below and my aim is to delete rows whose TICKER = AST and keep TICKER = AAPL eventhough one of its RETURN observations is missing.
DATE TICKER RETURN
01/01/2016 AAPL .
02/01/2016 AAPL 0,17
01/01/2016 AST .
02/01/2016 AST .
01/01/2016 FOX -0.2
02/01/2016 FOX 0.56
Any help will be appreicated. Cheers all.
Proc SQL;
create table want as
select * from have
Group by ticker
having max(ticker) ne .;
quit;
if ticker = 'AAPL' or return ne .;
subsetting if.
Proc SQL;
create table want as
select * from have
Group by ticker
having max(ticker) ne .;
quit;
I don't know how I didn't think about that. Thank you.
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.