Hi there, I would like to use compress function to take away any substring of “1/2”, but I found that it also removes any “1” or “2” from the string. E.g I have “20 1/2 Apple” and I want it to be “20 Apple”, but when I tried to use the compress function it gives me “0 Apple”.. is there anyway to use compress function to achieve this? This is my data: Data have; input var 100$.; Cards; 20 1/2 Apple ; Run; The code I tried is the following var=compress(var, “1/2”) but it does not work. This is what I want: Data want; input var 100$.; Cards; 20 Apple ; Run; ... View more

How can I use prxchange to replace special characters like “/,&-“ with space? For example I have a variable look like “102/103-Apple&Orange” and I want to make it looks “102 103 Apple Orange”, how can I use prxchange to achieve this? I was trying something like prxchange(‘s/[/-&,]/ /‘,-1, var); but cannot get the variable I want. Thanks for your help in advance! ... View more

Let’s say I wanna use prxchange to replace the string that starts with “The” or contain the word “world”. How can I use prxchange to achieve the multiple condition? I only know that to replace the string starts with “the” would be prxchange(“s/\b^(The)\b/ /,-1,variable) And to replace the string contains “world” would be prxchange(“s/\b(world)\b/ /,-1,variable) Is there a way to combine the 2? Thanks! ... View more

Hi I would like to ask that how can I create multiple rows from single row data: Let’s say I have the following data: Data have; Input name$ score1 score2 score3 score4 score5; Cards; Leo 1 1 3 3 5 Sean 3 4 . . . Nathan 4 5 7 . . ; run; This is what I want; Data want; Input name$ score; Leo 1 Leo 1 Leo 3 Leo 3 Leo 5 Sean 3 Sean 4 Nathan 4 Nathan 5 Nathan 7 ;run; I was trying to use loop function but couldn’t figure it out.. thanks for your help in advance ... View more