evilpettingzoo97's articles:

Items(352) /36 Next >> Last >|

Re: Traffic lighting for character variables? 0 20 (3/6/2010 4:15:57 AM) comp.soft-sys.sas On Fri, 5 Mar 2010 18:23:47 -0500, Ya Huang wrote: >Hi there, > >For numeric var, we can define range in format to control the >cell background/foreground. What about character var? > >data xx; >s='123523'; o... evilpettingzoo97

Re: CDISC format of XML 0 27 (1/22/2010 9:48:40 PM) comp.soft-sys.sas Jeff, If you are interested in creating ODM XML then take a look at:=20 http://support.sas.com/rnd/base/xmlengine/proccdisc/TW8774.pdf PROC CDISC requires you to create auxillary fields so it can create the X... evilpettingzoo97

Re: how to insrt a line at the end of every page in rtf 1 326 (1/22/2010 3:14:57 PM) comp.soft-sys.sas All, I'd like re-open the occassionally posted question of getting a solid line appear over the first footnote, particularly in RTF. Most of the solutions I have seen involve using RTF control characters o... evilpettingzoo97

Re: SAS vs. SPLUS vs. SAS #7 0 85 (12/13/2009 1:43:52 PM) comp.soft-sys.sas Paul, Have you taken a look at the support for sequential designs in V9.2? http://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/seqd= esign_toc.htm Regards, Ken Borowiak =20 =20 -----Ori... evilpettingzoo97

Re: matrix mulitplication................... #3 0 39 (10/10/2009 5:43:59 PM) comp.soft-sys.sas For matrix operations without IML, how about loading a JAVA package ( http://math.nist.gov/javanumerics/jama/ ) and using the JAVA object in a DATA step. /* Sample Code */ ?* OK, I dont how to do this .... p... evilpettingzoo97

Re: How to create an dataset with 0 has value from Proc Freq 1 28 (9/20/2009 12:13:40 PM) comp.soft-sys.sas SL, You can try dummying up your input data set, assigning weights of 1 to actual data and weights of 0 to the levels you want to force in and then using the WEIGHT statement in PROC FREQ with the ZEROES opti... evilpettingzoo97

Multiple j= in title and footnote statements 1 40 (9/19/2009 1:00:34 AM) comp.soft-sys.sas All, In an effort to generate more than ten lines in title and footnotes statements, I am exploring using multiple j= options within a single statement. Consider the following: title j=l 'First title text' j=... evilpettingzoo97

Re: Which airport is the closest to Cary (SAS head office). 0 28 (9/5/2009 9:53:32 PM) comp.soft-sys.sas DN writes sooth .... it is only 5-10 minute drive from RDU down I-40 to SI. Ken -----Original Message----- From: a To: SAS-L@LISTSERV.UGA.EDU Sent: Sat, Sep 5, 2009 7:00 am Subject: Re: Which airport ... evilpettingzoo97

Re: Ignoring Case #6 0 40 (8/27/2009 8:45:58 PM) comp.soft-sys.sas Jason, PRXMATCH has an option (actually, it is a modifier )?to ignore case when matching a pattern. eg where?? prxmatch( '/apple/i', your_var )> 0 ?would match APPLE, apple, AppLE, etc hth, Ken --... evilpettingzoo97

Re: Month end #10 0 39 (8/26/2009 3:52:10 AM) comp.soft-sys.sas Here is a link re: DATA step using a binary tree search algorithm in V9.2 with the IN operator. http://rtsug.org/ppt/Secosky_nov07.ppt IIRC, SQL already employed a binary search algorithm for IN prior to V9.2... evilpettingzoo97

evilpettingzoo97's replies:

Items(108) /11 Next >> Last >|

PROC SQL left joins - did everyone know this but me? 8 28 (7/28/2007 8:43:25 PM) comp.soft-sys.sas Suppose you have a data table with some coded values, and two tables expanding the coded values: ===== data airlines; input @1 alcode $2. @4 alname $20.; cards; DL Delta UA United AA American... jfh (1363)

RTF superscripts 2 38 (8/7/2007 9:29:42 PM) comp.soft-sys.sas I am creating a label for a RTF table using the following: %str(BMI (kg/m^{super 2})) which resolves in my log to: label = "BMI (kg/m^{super 2})"; which resolves to in RTF code to (viewed in text editor): ... michael.despirito (1)

A better JOIN method 11 41 (8/10/2007 7:40:06 PM) comp.soft-sys.sas Is there another form of a JOIN and/or Data step merge that is more efficient than this? Basically, I want to select records from 'datain' where ID is not in 'datain2'. proc sql; create table xyz as ... auto208611 (76)

Padding out a denormalized dset--what's the easy way? 2 31 (8/17/2007 11:00:44 PM) comp.soft-sys.sas Hey All, I've got to de-normalize a dataset--that is, take something like this: mrn dx Roy V90 Roy 402.2 Roy 333 Mary 200.3 And turn it into: mrn dx1 dx2 dx3 Roy V90 402.2 333 Mary 200.3... pardee.r (1272)

4 WEEKS TO NESUG !!! 5 18 (10/15/2007 6:21:55 PM) comp.soft-sys.sas 4 WEEKS TO NESUG !!! Hotel discount ends THIS Thursday - October 18! ----------------------------------------------- http://www.nesug.org/conference/hotel.htm October 18 is the final day to get the NESUG disc... nesug2007 (7)

Advice on joining large tables wanted. 5 22 (3/10/2008 1:37:13 AM) comp.soft-sys.sas g'day all, I have two tables, Big & Small that I need to join on the variable P7 and must keep all the records from Big. Big has 135m rows, 14 variables, all about $10, with the key variable P7 having 60k dis... phillip.anderra (25)

A Data Manupulation Question with RETAIN Statement - (Please Help 4 25 (10/10/2008 2:03:55 AM) comp.soft-sys.sas I have a following dataset: subject visit date visit ------- ---------- ----- 100001 30JUN2006 Screening 100001 30JUN2006 Day1 100001 21JULY Day2 100001 21July Day2 10000... need_sas_help (102)

A Fotmat issue ( variables' value combining) - Please look at it. 2 24 (1/17/2009 4:43:36 AM) comp.soft-sys.sas I have a following dataset with three variables (Treatment, Center,Subject) as below: Treatment Center Subject --------- ------ ------- A0006 B0 00001 A0007 C1 00002 A00... need_sas_help (102)

SAS vs. SPLUS vs. SAS 7 122 (12/11/2009 9:09:32 PM) comp.soft-sys.sas Hello Everyone, =C2=A0 I=E2=80=99ve recently become interested in sequential clinical trials desig= ns. I=E2=80=99ve purchased a book that discusses the topic called =E2=80=9C= Analysis of Clinical Trials u... pjmiller_57 (82)

Traffic lighting for character variables? 4 523 (3/5/2010 11:23:47 PM) comp.soft-sys.sas Hi there, For numeric var, we can define range in format to control the cell background/foreground. What about character var? data xx; s='123523'; output; s=' 234'; output; s='Abc dd'; output; run;... ya.huang (1962)