DATA Step, Macro, Functions and more

Syntax help for characters removing

Reply
Contributor
Posts: 38

Syntax help for characters removing

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.

PROC Star
Posts: 8,115

Re: Syntax help for characters removing

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

Art, CEO, AnalystFinder.com

 

Super User
Posts: 22,874

Re: Syntax help for characters removing

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.


 

Ask a Question
Discussion stats
  • 2 replies
  • 81 views
  • 0 likes
  • 3 in conversation