Hi,
I have to migrate some old R code to sas and found the following:
datarow$varibale[grep(".*a.*",datarow$Original),] <- "new column"
I dont quite get what its doing, guessing it takes everything that starts with .a and put it in a new varialbe Iwonder if someone can help me translating it into sas.
thanks
I think it matches any string that contains an "a". At least that's what my limited testing shows.
4043 data _null_;
4044 input line $20.;
4045 if _n_ eq 1 then rx=prxparse("/.*a.*/");
4046 retain rx;
4047 match = prxmatch(rx,strip(line));
4048 put (_all_)(=);
4049 cards;
line=hello rx=1 match=0
line=helloah rx=1 match=1
line=zzz rx=1 match=0
line= rx=1 match=0
line=ahhello rx=1 match=1
line=678ab rx=1 match=1
line=a rx=1 match=1
line=ta rx=1 match=1
line=u rx=1 match=0
I think it matches any string that contains an "a". At least that's what my limited testing shows.
4043 data _null_;
4044 input line $20.;
4045 if _n_ eq 1 then rx=prxparse("/.*a.*/");
4046 retain rx;
4047 match = prxmatch(rx,strip(line));
4048 put (_all_)(=);
4049 cards;
line=hello rx=1 match=0
line=helloah rx=1 match=1
line=zzz rx=1 match=0
line= rx=1 match=0
line=ahhello rx=1 match=1
line=678ab rx=1 match=1
line=a rx=1 match=1
line=ta rx=1 match=1
line=u rx=1 match=0
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.