Missing values

[Kayomole]

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.

[Kurt_Bremser]

if ticker = 'AAPL' or return ne .;

subsetting if.

[Reeza · Accepted solution]

Proc SQL;

create table want as 

select * from have

Group by ticker

having max(ticker) ne .;

quit;

[Kayomole]

I don't know how I didn't think about that. Thank you.