About Xianhua_zeng

Xianhua_zeng · ‎03-12-2014

How about this: data test; do i=1 to 999; if mod(i,3)=0 or mod(i,5)=0 then total+i; if i=999 then output; end; run;

Xianhua_zeng · ‎02-27-2014

data want; set test; array have(*) ANR_Q1 ANR_Q2 ANR_Q3; array temp(3); do i=1 to dim(have); temp(i)=have(i); end; call sortn(of temp:); Base=temp3; drop i temp:; run;

Xianhua_zeng · ‎02-26-2014

a complex method park=prxchange('s/(Canyon)//i',-1,park);

Xianhua_zeng · ‎11-14-2013

proc sort data=sample out=int; by emp; run; proc transpose data=int out=want(drop=_:) prefix=sal_ ; by emp; var sal; id date; run;

Xianhua_zeng · ‎04-25-2013

Hi, suraestar, A simple method.You can try it. data _null_; varlist='Hello$Test$System$SAS'; key=prxchange('s/(.+?)(\$)(.+?)\$(.+)/$1$2$3/',-1,varlist); put key=; run;

Xianhua_zeng · ‎04-08-2013

%macro splitdata; %do i=1 %to 8600 %by 860; data want_&i.; set have(firstobs=&i obs=%eval(&i+859)); flag="&i-%eval(&i+859)"; run; %end; %mend splitdata; %splitdata

Online Status	Offline
Date Last Visited	‎11-20-2015 10:04 AM

Re: Using SAS to find multiples of X

Re: want to create a max base

Re: Removing a certain part of a word

Re: Converting rows into columns

Re: Function to Fetch n words from a variable separated by a Delimiter...

Re: How to split a data set equally

Re: Using SAS to find multiples of X

Re: Using SAS to find multiples of X

Re: want to create a max base

Re: Removing a certain part of a word

Re: Converting rows into columns

Re: Function to Fetch n words from a variable separated by a Delimiter...

Re: How to split a data set equally