About FriedEgg

FriedEgg · ‎03-10-2017

FriedEgg · ‎03-06-2017

[^] creates a negated set, it is specific to the characters within the set, no strings.

FriedEgg · ‎03-03-2017

data a; input name $; cards; abby bobby chris ; run; data b; length training $ 11; input training &; cards; training #1 training #2 ; run; data c; set a; do _n_=1 to nobs; set b nobs=nobs point=_n_; output; end; run;

FriedEgg · ‎03-03-2017

it can be a bit simplified: /\bsubject\b.*\bcomplete\b.*\b(study|treatment|protocol)\b/i the reason I chose not to do this was to avoid the assumed logic that the words would always be in this order.

FriedEgg · ‎03-03-2017

Updated my post

FriedEgg · ‎03-03-2017

data f; length str $ 64; array x[2] $ 8 _temporary_ ('subject' 'complete'); array y[3] $ 9 _temporary_ ('study' 'treatment' 'protocol'); input str &; j=0; do i=1 to dim(x); j+findw(str,x[i],,'tsmi')>0; end; if j=dim(x) and prxmatch('/\b('||catx('|',of y[*])||')\b/i',str)>0; cards; did the subject complete the entire course of study did the subject complete the treatment period did subject complete full study protocol did subject complete hospital visit did subject complete application form ; run;

FriedEgg · ‎03-03-2017

http://www.sascommunity.org/wiki/TeX_and_LaTeX

FriedEgg · ‎03-03-2017

filename _bcin ftp 'tl_2010_24_zcta510.zip' cd='/geo/tiger/TIGER2010/ZCTA5/2010' host='ftp2.census.gov' user='anonymous' passive binary recfm=s; and, if fcopy doesn't work you can use a very simple data step instead data _null_; infile _bcin; file _bcout; input; put _infile_; run;

FriedEgg · ‎02-17-2017

the 's' before the regular expression is referred to as a pattern-matching modifier, and denotes that the expression is a substition/replacement expression. the '#' is just acting as a delimiter. common delimiters are "/" or "#" or "{}" or "[]" typically s#/+#/# = s/\/+/\// When you use # instead of / as the delimiter, you make a pattern matching expression that would normally use the default delimiter, like the example, simpler, since you don't have to escape it The patter above is simple: match the "/" character 1 or more times, as many as possible without encounter some other token and replace that match with a single "/" s#^(/project\d+/)#/projects/# or s#^/project\d+/#/projects/# or s/^\/project\d+\//\/projects\// matches a string where, at the beginning is starts with "/project" followed by 1 or more numbers and ending with "/" such as "/project1234/" and changes it to "/projects/"

FriedEgg · ‎02-10-2017

Yes, and yes Can be simplified to the following: data lexperm; array i[6] $ 1 (2*('A' 'B' 'C')); do _n_=1 to fact(dim(i)); rc=lexperm(_n_, of i[*]); if rc<0 then leave; else output; end; stop; run; lexperm also already outputs in order, so the proc sort shouldn't be necessary

FriedEgg · ‎02-10-2017

setting assurances for matching the whole string would be better, on the off change more that one string of numbers happens to occur in a row of the data. num = prxchange('s/^\D+(\d+)\D+$/$1',1,str); also, since OP states there is definitely at least one char to left and right, can use + instead of * to further validate expected input.

FriedEgg · ‎02-10-2017

There is likely to be a better way to do this with PROC PLAN too, just as @Rick_SAS showed with IML ods output plan=plan(drop=rep); proc plan seed=1234; factors rep=%sysfunc(fact(6)) col=6; run; data plan; set plan; array col [6]; array i [6] _temporary_ (2*(1:3)); do _n_=1 to 6; col[_n_]=i[col[_n_]]; end; run; proc sort data=plan nodupkey; by col:; run; proc iml; perm = allperm({1 1 2 2 3 3}); cols = 1:6; call sortndx(ndx, perm, cols); uidx = uniqueby(perm, cols, ndx); uval = perm[ndx[uidx], cols]; create planIml from uval; append from uval; close planIml; quit;

FriedEgg · ‎02-10-2017

use uniqueby or iterate through lexperm instead of allperm

FriedEgg · ‎02-09-2017

proc format; value $gndr 'F' = 'Female' 'M' = 'Male' 'O' = 'Other'; run; proc tabulate data=sashelp.class; class sex / preloadfmt; table sex/ printmiss misstext='0'; format sex $gndr.; run;

FriedEgg · ‎02-09-2017

Yes, that is what it means, which is fine, if that's the functionality you want. I will assume it not. So you would want to add and: else AGE/EDUCATION before the end on your two case statements

Online Status	Offline
Date Last Visited	‎03-31-2025 06:28 PM