topic Re: Missing values in SAS Data Management

Missing values

Kayomole — Sun, 16 Oct 2016 17:26:12 GMT

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.

Re: Missing values

Kurt_Bremser — Sun, 16 Oct 2016 18:52:00 GMT

if ticker = 'AAPL' or return ne .;

subsetting if.

Re: Missing values

Reeza — Sun, 16 Oct 2016 18:58:01 GMT

Proc SQL;

create table want as

select * from have

Group by ticker

having max(ticker) ne .;

quit;

Re: Missing values

Kayomole — Sun, 16 Oct 2016 19:28:06 GMT

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