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 save with the early bird rate—just $795!
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.