topic Re: i want to remove data comes before first comma in SAS Programming

i want to remove data comes before first comma

Soham0707 — Mon, 25 Nov 2019 09:24:47 GMT

Hi Guys,

I need one minor help.

Below is my input data;

802,803
803,804
60,61
817,818
817,818,819
810,811,812
55,56
55,56,57

I want output like below;

803
804
61
818
818,819
811,812
56
56,57

I want to remove data comes before first comma.

How can I do this.

Re: i want to remove data comes before first comma

PeterClemmensen — Mon, 25 Nov 2019 09:26:03 GMT

Your data is character, right?

Re: i want to remove data comes before first comma

Soham0707 — Mon, 25 Nov 2019 09:32:16 GMT

yes

Re: i want to remove data comes before first comma

PeterClemmensen — Mon, 25 Nov 2019 09:33:18 GMT

Do something like this

data have;
input value $ 1-20;
datalines;
802,803
803,804
60,61
817,818
817,818,819
810,811,812
55,56
55,56,57
;

data want;
  set have;
  value = prxchange("s/([^,]+),//", 1, value);
run;

Result:

Re: i want to remove data comes before first comma

Amir — Mon, 25 Nov 2019 09:39:03 GMT

The following finds the first comma and then uses substr() to get the text after that:

data have;
   input text : $char50.;

   datalines;
802,803
803,804
60,61
817,818
817,818,819
810,811,812
55,56
55,56,57
;

data want;
   set have;
   text2 = substr(text,findc(text,',')+1);
run;

Kind regards,

Amir.

Re: i want to remove data comes before first comma

Soham0707 — Mon, 25 Nov 2019 09:42:40 GMT

Thank you so much ...