Remove observations with . in them

[anweinbe]

Evening all.

I have a data file called "hartland". There are 135 records, but I noticed that 33 of them have a "." in my PERMNO column. How do I remove these items and get my file down to 102 records?

[novinosrin]

if not index(PERMNO ,'.');

[anweinbe]

data temp.hartland;
if not index (permno , '.');
run;

?

[novinosrin · Accepted solution]

data filtered;
set temp.hartland;
if not index(PERMNO ,'.');
run;

[anweinbe]

Still showing 135 records and they are still there. Very odd.

[novinosrin]

Post your sample data plz

[anweinbe]

The last column has the "." in it. This is what I want to remove.

I put in this code:

data filtered;
set temp.hartland;
if not index(PERMNO ,'.');
run;

1

Transcept Pharmaceuticals Inc.

TSPT

Novacea Inc.

Marketwire

01SEP2008

H

2589

2008

2.6232908319

.

[anweinbe]

It worked. I'm sorry Novinosrin! I looked at the wrong output file.