ben.powell1's articles:

Items(759) /76 Next >> Last >|

Re: Monte Carlo Simulation Help #2 0 20 (5/29/2009 9:04:13 AM) comp.soft-sys.sas Thanks for the link to a great paper. On Thu, 28 May 2009 16:27:37 -0500, Data _null_; wrote: >You don't need to pay here. > >You need to read this > >http://www.lexjansen.com/pnwsug/2007/David%20Cassell%20-... ben

Re: Algorithm to round a group of numbers 0 26 (5/28/2009 10:48:03 AM) comp.soft-sys.sas btw the algorithm should be the same whether the trunc or round function is used, rgds ... ben

Algorithm to round a group of numbers 0 34 (5/28/2009 10:15:14 AM) comp.soft-sys.sas Dear List Say I have 20 groups of floating point values that add up to 100 or very close (within 8 decimal places) - and I want to guarantee they add up to exactly 100 when truncated to 5 decimal places, is th... ben

Re: Where did all the SPAM come from? #3 1 31 (5/22/2009 12:45:29 PM) comp.soft-sys.sas May want to add: //megadealfinder On Thu, 21 May 2009 14:35:34 -0400, Nat Wooding wrote: >I set up a mail rule that deletes anything that has > >//bestdeallocator > >in the body > > >Nat Wooding > > >Enviro... ben

Re: Zipping files in SAS #3 0 30 (5/21/2009 8:44:11 AM) comp.soft-sys.sas Here is some code I've used in the past: data _NULL_; if weekday(today()) = 6 then call execute(" options noxwait; x '\\Archive$\SurveysDataMart\Scripts\dm_zip.bat'; x 'copy C:\survey\SurveyData\dm.7z \\cla... ben

Re: Zipping files in SAS #2 0 24 (5/21/2009 8:40:49 AM) comp.soft-sys.sas 7zip uses strong AES 256 encryption http://www.7-zip.org/7z.html HTH. ... ben

Re: Can't remove what appear to be blanks #4 1 31 (5/13/2009 10:56:01 AM) comp.soft-sys.sas Modifiers on COMPRESS may help, http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0812C&L=sas-l&D=0&P=36691 I've used 'c' in the past to remove HEX characters. Check the base manual data a; a="123 456 789"||"09"x... ben

Re: Vlookup in SAS 0 41 (5/6/2009 1:31:52 PM) comp.soft-sys.sas You could either use proc sql if you can write sql joins, or merge. proc sort data = cella;by lookupvar;run; proc sort data = cellb;by lookupvar;run; data want; merge cella (in=x keep=lookupvar var3) cell... ben

Re: Copyright (c) 2008 Paul OldenKamp #5 0 23 (5/5/2009 9:30:08 AM) comp.soft-sys.sas Its one thing to claim copyright, its another thing entirely to contest it in court. Rgds ... ben

Re: proc surveyselect is inefficient? #8 0 22 (5/1/2009 9:58:35 AM) comp.soft-sys.sas The sas support data step srs without replacement, no sort required, is equally tidy: * Method 3, Using SAS DATA Step and no sort is required ; /* Simple Random Sample of 50 students. ... ben

ben.powell1's replies:

Items(171) /18 Next >> Last >|

10 years of hash in SAS 6 32 (12/25/2008 6:09:54 AM) comp.soft-sys.sas It has just dawned on me that on 1998-12-15, this raw hash concoction was posted to SAS-L: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind9812C&L=sas-l&P=R985 Has it been 10 years already, really? Hard to belie... sashole (976)

a more efficient approach than using array? 10 18 (12/9/2008 5:44:30 PM) comp.soft-sys.sas Hi, As shown in my codes below, I use the array approach to select the observations when any of these 6 variables (PRCDR_CD1 - PRCDR_CD6) has the value '4701','4709','4711','4719','4720', and flag it I also u... i89rt5 (19)

64-bit versus 32-bit temporary arrays 5 23 (9/10/2008 8:39:50 AM) comp.soft-sys.sas Hi! On my 32-bit Windows-PC the max. size temporary array is as follows: data test; array x(92864512) _temporary_; run; Can anyone tell me what the max. size is on a 64-bit Windows-PC? Regards, Jesper ... jespersahner (76)

Aid in validating e-mail with regular expressions 3 24 (7/4/2008 7:39:39 PM) comp.soft-sys.sas Hi, I'm having a problem in the validation of e-mail using regular expressions. The expression below meets my need for validation, but invalidate emails correct, for example: luis@gmail.com carlos.pedro @ hot... lcwruck (1)

64-bit SAS: I'm confused 7 31 (4/16/2008 1:53:47 PM) comp.soft-sys.sas Hi folks, I know this sounds like a silly query, but having looked at a bunch of web pages at sas.com I can't seem to distinguish when they're talking about 32-bit SAS running in a 64-bit environment vs 64-bit... jweedon (207)

Streaming Tick data from a trading platform to a SAS app 8 20 (8/6/2007 4:59:40 AM) comp.soft-sys.sas Hi, I want to analyze live trading data (S&P 500 emini) with SAS. I have written a SAS app that summarizes and analyzes historical emini S&P 500 tick data, and generate buy and sell signals as well. I am quit... maskiepop (5)

SAS editor reset keyboard language??? 2 37 (7/16/2007 8:22:35 AM) comp.soft-sys.sas This morning SAS will mostly be interpretting keystrokes in mac-mode :( I go to type " and it types @ and vice versa. Why has this happened on a monday and why is nothing else effected?! Any idea what setting... ben.powell1 (971)

OT - Friday Humor 3 38 (7/13/2007 2:24:57 PM) comp.soft-sys.sas In light of this week's comments regarding voice recognition (Dragon vs. Windows), how much Vista sucks and even embracing David Cassell's love for Pearl, here is Youtube video that is pretty funny. Hey, three ... PhilRack (307)

Resolve & in macro file output? 6 20 (5/16/2007 3:10:34 PM) comp.soft-sys.sas Dear List, I've been resolving a file in a macro loop for 1000 or so items and running that file (a batch program). However, how do I do this if the parameter (a customer name) contains an ampersand? These jus... ben.powell1 (971)

Leading Zeros in EXCEL spreadsheet 4 101 (5/12/2007 10:03:35 PM) comp.soft-sys.sas Hi All, I have a dataset (sample) looks like this. 31-Aug-06 1037053806 APV 31-Aug-06 0163537806 APV 31-Aug-06 0163537806 APV 31-Aug-06 0163537806 APV 31-Aug-06 0163537806 APV 31-Aug-06 0163537806 APV 31-Aug-... ddraj2015 (106)