Syntax help for characters removing

[cho16]

Hi,

I need to remove the provider ID with 13 characters except for the provider type ‘PCP’

ID                                         Type

123456789_123                  PCP

123456345_124                 BCP

123456541_123                   RCP

124534789_12                     YUP

Wanted Data:

ID                                         Type

123456789_123                  PCP

124534789_12                     YUP

The ‘-‘ should be counted as a character.

Thanks in advance.

[art297]

data want;
  set have;
  if length(ID) ne 13 or Type eq 'PCP';
run;

Art, CEO, AnalystFinder.com

[Reeza]

Use the LENGTH() function to determine the length of a string and then you can use an IF statement to keep/delete records as necessary.  You can use DELETE to delete records.

*quick example of DELETE;
data demo;
set sashelp.class;

if age=13 then delete;
run;

If you're having trouble building that statement please post your code.

---

@cho16 wrote:

Hi,

I need to remove the provider ID with 13 characters except for the provider type ‘PCP’

ID                                         Type

123456789_123                  PCP

123456345_124                 BCP

123456541_123                   RCP

124534789_12                     YUP

Wanted Data:

ID                                         Type

123456789_123                  PCP

124534789_12                     YUP

The ‘-‘ should be counted as a character.

Thanks in advance.

---