There are also codes with the prefix pnp, 1icc, 2icc, etc. and up to 4-5 letters
It would help if you could provide more details on the rules for the "codes".
Do the digits after the prefix vary? How? Your examples seem to all have pn followed by a three digit string. In fact all of your examples have pn41 followed by one digit.
Also since some of the prefixes might start with a digit (1icc and 2icc) you could have trouble if the number of digits after a prefix varies. It might be impossible to figure out what was intended from some run-on strings.
Do you have a full list of the prefixes? Perhaps in a dataset? You might want to use the list to generate some code that can be used to convert the string into something that is easier to parse.
For example you might want to use regular expressions. So perhaps something like:
y_fixed=prxchange('s/(pn\d\d\d)/,$1/',-1,y_fixed);
y_fixed=prxchange('s/(1icc\d\d)/,$1/',-1,y_fixed);
Example:
data sample;
row+1;
input y $80.;
cards;
pn415pn418 pn415pn418 pn414 pn415pn417pn413p n415pn418 pn417pn417 pn415
pn4151icc25
;
data sample_fixed;
set sample;
length y_fixed $200;
y_fixed=compress(lowcase(y));
y_fixed=prxchange('s/(pn\d\d\d)/,$1/',-1,y_fixed);
y_fixed=prxchange('s/(1icc\d\d)/,$1/',-1,y_fixed);
run;
proc print;
run;
data want;
set sample_fixed;
do i=1 to max(1,countw(y_fixed,','));
length code $10;
code = scan(y_fixed,i,',');
output;
end;
keep row i code ;
run;
proc print;
run;Result:
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.
-
1728 views
-
2 likes
-
-
