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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.