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.
data want; set have; if length(ID) ne 13 or Type eq 'PCP'; run;
Art, CEO, AnalystFinder.com
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: