About slchen

slchen · ‎08-11-2015

Day_of_Week=put(weekday(Start_Date)+1,downame7.); monthyear=put(Start_Date,monyy7.);

slchen · ‎07-28-2015

%let myStr = fileNameXy_blah_blah07282015.csv; %let num=%sysfunc(compress(&mystr,,kd)); %put &num;

slchen · ‎07-27-2015

Try with hash: data want; if 0 then set B(rename=(type1=_type1 type2=_type2 type3=_type3)); if _n_=1 then do; declare hash h(dataset:'B(rename=(type1=_type1 type2=_type2 type3=_type3)'); h.definekey('ID'); h.definedata(all:'y'); h.definedone(); end; set A; if h.find()=0 then do; if index(_type1,strip(type1))>0 and index(_type2,strip(type2))>0 and index(_type3,strip(type3))>0 then output; end; drop _:; run;

slchen · ‎07-27-2015

proc sql inobs=10; select * from sashelp.class; quit; data class; set sashelp.class(obs=10); run;

slchen · ‎07-24-2015

Try this: category_Id =input(prxchange('s/.*(?<=categoryId=)(\d+).*/$1/',-1,string),12.);

slchen · ‎07-22-2015

data want; set have; if not missing(cat_code)then do; num=count(cat_code,'*'); do i=1 to num; hi_code=max(hi_code,scan(cat_code,i,'*')); end; end; if index(cat_code,'*')=0 then hi_code=cat_code; if hi_code>200 then delete; drop i num cat_code hi_code; run;

slchen · ‎07-21-2015

data want; set string; IF Index(DrugName,'MG') > 0 then do; _var2=prxchange('s/[^0-9-.]//i',-1,drug_strength); _var3=prxchange('s/[^a-z\/]//i',-1,drug_strength); end; run;

slchen · ‎07-19-2015

Try this: data _null_; string="TEXT TEXT TEXT: •TEXT TEXT TEXT •TEXT TEXT TEXT. •TEXT TEXT TEXT"; _string=prxchange('s/(\•)/$1 /',-1,string); put _all_; run;

slchen · ‎07-16-2015

proc sql; select id, max(x) as x,max(y) as y,max(z) as z from temp group by id; quit;

slchen · ‎07-15-2015

data a; input x $ 30.; cards; 28,16c2b8c4l8n 28,16cb8c4l8n 28,cbc4l24n ; run; data want; set a; _x=translate(prxchange('s/(?<=\D)([a-z])/1$1/i',-1,x),' ','cbln'); activity=scan(_x,1)/4; contract=(scan(_x,2)+scan(_x,4))/4; break=(scan(_x,3))/4; lunch=(scan(_x,5))/4; noactivity=(scan(_x,6))/4; drop x _x; run;

slchen · ‎07-14-2015

data have; input var_original $20.; array vars (4)$ var1-var4; do i=1 by 1; if missing(scan(var_original,i,' -')) then return; vars(i)=scan(var_original,i,' -'); end; drop i; cards; 500 MG-7.5 MG 50 MG/hl 20 MG-5 MG ; run;

slchen · ‎07-12-2015

data want; set have; array vars1 dx1-dx5; array vars2 dx6-dx10; call missing(of vars2(*)); output; set have; call missing (of vars1(*)); do over vars1; vars1=vars2; end; output; drop dx6-dx10; run;

slchen · ‎07-08-2015

Try this: if "&var" = "&&ProvName&i" then output &data._&i.;

slchen · ‎07-08-2015

data have; input string $50.; var1=prxchange('s/$.*$//',-1,string); var2=prxchange('s/.*$(.*)$.*/$1/',-1,string); cards; Calcium (mmol/L) High Creatinine Clearance (mL/min) Albumin (g/L) C-Reactive Protein (mg/L) ; run;

slchen · ‎07-08-2015

proc sort data=have; by id grp1 descending val; run; data want; merge have have(firstobs=2 rename=(id=_id grp1=_grp1 val=_val)); if id=_id and grp1=_grp1 and val in (0,1) and _val in (0,1) then val=-val; drop _:; run;

Online Status	Offline
Date Last Visited	‎07-12-2017 03:27 PM

Re: How to exclude some names when use proc sql to create macrolist?

Re: Counting character variable in array with substr

Re: DATETIME variable stored as a string

Re: Moving observations in the required position

Re: Number Format to Date Format

Re: Extracting keywords and corresponding number

Re: Extract conditional information from text

Re: %do without using %to

Re: How do I combine multiple columns with missing data and prioritizi...

Re: Counting the number of occurrences for a grouped variable

Re: Last 5 characters from string(irrespective of the length)

Re: Replacing " " with a "_" for variable names in a given file

Re: ODS graphics with more than 5000 points have been suppressed

Re: How to exclude some names when use proc sql to create macrolist?

Re: Moving observations in the required position

Re: Extracting year, month, day from date

Re: using %scan (maybe) to extract date from macro variable

Re: look up solution help for row to column values or column to row ma...

Re: Output dataset has x amount or records

Re: Regular Expressions: Performing String Extractions on Several Vari...

Re: help with picking out numeric codes from a text field

Re: Need help on PRXCHANGE function

Re: Regarding compbl in text.

Re: Replace missing value with previous value

Re: splitting variable into multiple variables

Re: how to devide the context of 1 variable into several variables

Re: 10 column to 5 column array

Re: Masking special character when the subsetting variable is a quoted...

Re: Extract specific word from a string/variable

Re: pick 0 and 1