topic Re: Remove observations with . in them in SAS Programming

Remove observations with . in them

anweinbe — Thu, 10 Oct 2019 23:29:41 GMT

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?

Re: Remove observations with . in them

novinosrin — Thu, 10 Oct 2019 23:34:50 GMT

if not index(PERMNO ,'.');

Re: Remove observations with . in them

anweinbe — Thu, 10 Oct 2019 23:36:12 GMT

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

?

Re: Remove observations with . in them

novinosrin — Thu, 10 Oct 2019 23:38:26 GMT

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

Re: Remove observations with . in them

anweinbe — Thu, 10 Oct 2019 23:42:56 GMT

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

Re: Remove observations with . in them

novinosrin — Thu, 10 Oct 2019 23:43:43 GMT

Post your sample data plz

Re: Remove observations with . in them

anweinbe — Thu, 10 Oct 2019 23:47:21 GMT

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;

Transcept Pharmaceuticals Inc.

TSPT

Novacea Inc.

Marketwire

01SEP2008

2589

2008

2.6232908319

Re: Remove observations with . in them

anweinbe — Thu, 10 Oct 2019 23:55:40 GMT

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