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
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.