About hhchenfx

hhchenfx · ‎07-10-2014

That's perfect. Many thanks. HHC

hhchenfx · ‎06-17-2014

Thank you, Reeza for correcting it. HHC

Reeza · ‎06-17-2014

Use an array. %let x=10; data have; array var(100) var1-var100; if var(&x)=3 or var(&x-1)=3 or var(&x-4)=3 then find=1; run;

hhchenfx · ‎06-13-2014

Thanks Everyone for helping me. Have a nice weekend. HHC

hhchenfx · ‎06-13-2014

Thank you, Xia. HHC

hhchenfx · ‎05-05-2014

You are right, Xia. The A1A1 shouldn't be there. I should change to do ii=i+1 to dim(_a2); HHC

hhchenfx · ‎04-15-2014

Sorry for not making it clear. I'll get back to this issue later. Thank you, HHC

jakarman · ‎04-10-2014

@hhchenfx, converting a sequential process to one that goes for a divide an conquer approach will usually result in a even worse performance unless you have a fit in the infrastructure. Luckily enough you can go for that infrastructure fit with grid-computing and/or the hadoop way. You have just describe the principles of those,

hhchenfx · ‎04-05-2014

Thanks, Tom. You are right. I should use merge in this case since it is only 1-to-1 matching. Also the (%IF=abc) works perfectly. HHC

hhchenfx · ‎03-01-2014

oh I got it. data one; input old $20. ; datalines; change1 && && face change2 && && askljklj change3 dfa xlx & ) run; data two; set one; new = prxchange('s/&& &&/&&/', 1, old); new2 = prxchange('s/& \)/kkk/', 1, old); run;

hhchenfx · ‎02-01-2014

Thanks, Tom, for clear explanation. HHC

hhchenfx · ‎01-29-2014

Hi Data_null, Is there any quick change to your code if I want to change from "AND" to "OR" in my argument below? Thank you, HHC If a1=1 how many observations have target=0 and how many have target=1. If a1=1 OR a2=9, how many observations .... If a1=1 OR a2=9 OR a3=1 how many observations .... ... If a1=1 OR a2=9 OR a3=1 OR a4=0 OR a5=8 OR a6=1 .... If a1=2 how many observations ...

hhchenfx · ‎01-28-2014

Thank you, Peter and Data_null_. Lesson learned. HHC

hhchenfx · ‎12-05-2013

Thank you for your help, Arthur. The reason I did it is that there are about 100 condition and I dont want to manually count the position to put in DO statement. HHC

hhchenfx · ‎11-09-2013

Thank you for your help. I got it. Have a nice weekend. HHC

Online Status	Offline
Date Last Visited	‎06-11-2025 01:48 PM

Re: Help with Do Loop return incorrect result

Help with Do Loop return incorrect result

Re: Running time issue

Running time issue

Transpose multiple columns Long to Wide

Re: SAS Error Unable to sample external file, no data in first 5 recor...

SAS Error Unable to sample external file, no data in first 5 records

Get the highest value within a window

Issue with WORK.PROFILE will be opened instead

import specific sheet of an xlsx file into SAS

Re: Running time issue

Re: SAS Error Unable to sample external file, no data in first 5 recor...

Re: Get the highest value within a window

Re: Get the highest value within a window

Re: Get the highest value within a window

Where to download SAS 9.4

Go to the end of a Macro loop when condition met

Re: Go to the end of a Macro loop when condition met

Re: Run code when minutes is 0,5,10...

Re: Running code when time between certain window

Re: Help with Calling SAS file to run

Re: Moving percentile not include current record

Re: Help with Marco variables

Re: Automatic variable creation in Array

Re: Help with Do loop for proc Expand

Re: Create summary for each combination of different set of variables

Re: Macro create aggregate file at the first itteration of a group

Re: Setup running macro variable

Re: Help with Macro data creation for SQL

Re: Help with replace text

Re: Help with inputting character variables with different lengths

Re: Summary of statistics for ALL Combination from a set of variables

Re: Help with create a summary of distinct value for each variable

Re: Counting number of condition met

Re: Help with Retain