topic Syntax help for characters removing in SAS Programming

Syntax help for characters removing

cho16 — Thu, 04 Jan 2018 16:30:04 GMT

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.

Re: Syntax help for characters removing

art297 — Thu, 04 Jan 2018 16:35:30 GMT

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

Art, CEO, AnalystFinder.com

Re: Syntax help for characters removing

Reeza — Thu, 04 Jan 2018 16:48:27 GMT

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.