LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2000, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 9 Nov 2000 10:50:52 -0500
Reply-To:     wendy.watson@COVANCE.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         wendy.watson@COVANCE.COM
Subject:      unlinking formats
Comments: To: ekomarof@sdac.harvard.edu

unlinking formats:

you can use the following code to remove formats from your data table:

PROC DATASETS LIBRARY=<libname> MEMTYPE=DATA; MODIFY <sas data set name>; FORMAT <variable(s) whos format to remove> ; RUN;

You can also use the _all_, _numberic_, and _Character_ auto variables in the format statment above.

-Wendy

-----Original Message----- From: Automatic digest processor [mailto:LISTSERV@listserv.uga.edu] Sent: Thursday, November 09, 2000 10:39 AM To: Recipients of SAS-L digests Subject: SAS-L Digest - 9 Nov 2000 - Special issue (#2000-1150)

There are 22 messages totalling 1017 lines in this issue.

Topics in this special issue:

1. Oracle dates 2. SORT FAILED 3. Helvetica in RTF using ODS 4. PHREG and dummy variables (4) 5. Max. length of the record (4) 6. Application Dispatcher and WebAF JSP 7. SAS Reference Card (4) 8. contrast estimates in catmod 9. citation for SAS v8 10. unlinking formats (4)

----------------------------------------------------------------------

Date: Thu, 9 Nov 2000 09:07:28 +0100 From: Troels Lind <lind@DSR.KVL.DK> Subject: Re: Oracle dates

I use this makro to convert Oracledates, simple anf efficinet:

%macro oracdato(var); if &var > 0 then &var=input (put(&var,datetime9.),date9.); %mend oracdato;

after the macro have executede, you need to use a format

- troels

spider_templar@my-deja.com wrote:

> Hi Gary, when coverting dates I have used a program that lets > your "copy and paste" tables from Oracle to SAS and actaully any > OLEDB/ODBC connection. If there are datatypes that don't align, this > program will pop up a conversion wizard and let you define the types > before it transfers the database/table structure and the data. The > program is titled "Schemer Advanced" and is being offered from a > company called Appligator.com - I use it to do all my reports as well - > check it at: http://www.appligator.com/products/Schemer/moreSchemer.asp > here is the product desc from the site.... > > Connect to ANY OLEDB or ODBC Datasource from Schemer! > > SQL Server, Oracle, SAS, Access, AS/400, DB2, Excel, Text Files, DBase, > *ANY* OLEDB or ODBC type! > Runs on Windows 95/98/NT/2000 platforms. > Supports full SQL "Query Analyzer" functionality; SQL Execution and > Color Syntax Highlighting!!! > Drag and Drop Data from Schema Pane to Data Grid, Use the Visual Query > Builder! > Sort Results via GUI at the click of your mouse! > Export to results to ASP, XML, Text files (delimited), HTML , ADTG, > RTF, & Other Data Sources! > Copy and Paste Tables from Source to Source!!! > Print Result Sets from the Data Grid, Print Extended Schema Information > for each database > Plus Many More Features!!!!!!!!!! > > In article <01c03486$9cbf0400$09167a90@t112637>, > "Gary Ross" <gary_ross@mgic.com> wrote: > > We usually let the date come through as datetime16. and lateruse the > > datepart function. For instance, > > > > sasdate=datepart(sas_oracle_datetime); > > > > This effectively strips off the time portion, leaving only the sas > date. > > > > Bernard Tremblay <imaginasys@HOTMAIL.COM> wrote in article > > <F92WvqzAoa2JB1ndcx3000139e6@hotmail.com>... > > > Hello SAS-L'ers, > > > > > > I would like to know how to handle date from Oracle with SAS. > > > > > > We have a DBLOAD that load an Oracle table and then we process > it with > > > SAS. Oracle dates ended like DATETIME16. instead of DATE9. The > SAS code > > is > > > used by others too and SAS dates are expected. Is there an easy > way to > > > handle this without changing the SAS code ? > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

spider_templar@my-deja.com wrote:

> Hi Gary, when coverting dates I have used a program that lets > your "copy and paste" tables from Oracle to SAS and actaully any > OLEDB/ODBC connection. If there are datatypes that don't align, this > program will pop up a conversion wizard and let you define the types > before it transfers the database/table structure and the data. The > program is titled "Schemer Advanced" and is being offered from a > company called Appligator.com - I use it to do all my reports as well - > check it at: http://www.appligator.com/products/Schemer/moreSchemer.asp > here is the product desc from the site.... > > Connect to ANY OLEDB or ODBC Datasource from Schemer! > > SQL Server, Oracle, SAS, Access, AS/400, DB2, Excel, Text Files, DBase, > *ANY* OLEDB or ODBC type! > Runs on Windows 95/98/NT/2000 platforms. > Supports full SQL "Query Analyzer" functionality; SQL Execution and > Color Syntax Highlighting!!! > Drag and Drop Data from Schema Pane to Data Grid, Use the Visual Query > Builder! > Sort Results via GUI at the click of your mouse! > Export to results to ASP, XML, Text files (delimited), HTML , ADTG, > RTF, & Other Data Sources! > Copy and Paste Tables from Source to Source!!! > Print Result Sets from the Data Grid, Print Extended Schema Information > for each database > Plus Many More Features!!!!!!!!!! > > In article <01c03486$9cbf0400$09167a90@t112637>, > "Gary Ross" <gary_ross@mgic.com> wrote: > > We usually let the date come through as datetime16. and lateruse the > > datepart function. For instance, > > > > sasdate=datepart(sas_oracle_datetime); > > > > This effectively strips off the time portion, leaving only the sas > date. > > > > Bernard Tremblay <imaginasys@HOTMAIL.COM> wrote in article > > <F92WvqzAoa2JB1ndcx3000139e6@hotmail.com>... > > > Hello SAS-L'ers, > > > > > > I would like to know how to handle date from Oracle with SAS. > > > > > > We have a DBLOAD that load an Oracle table and then we process > it with > > > SAS. Oracle dates ended like DATETIME16. instead of DATE9. The > SAS code > > is > > > used by others too and SAS dates are expected. Is there an easy > way to > > > handle this without changing the SAS code ? > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

-- Hilsen Troels

+-----------------------------------------------+ | Troels Lind | | Bissensgade 2, 4. th. | | DK-8000 Arhus | | e-mail: lind@dsr.kvl.dk | | homepage: www.dsr.kvl.dk/~lind | |-----------------------------------------------| | Arbejde: | | Landskontoret for Kvaeg | | Landbrugets Radgivningscenter | | Udkaersvej 15; Skejby; DK-8200 Aarhus N | | tlf: 87 40 53 44; fax: 87 40 50 91 | | e-mail: trl@lr.dk | +-----------------------------------------------+ _________________ || ( Husk: Pa ) || ( Nettet kan ingen ) || (se at du er en hund) || (____(Dogbert)____) || o || o || (__) o || (oo) || /-------\/ <--- (Ko) || / | || || * ||w---|| || -----^^----^^-------------------------------------------------------

------------------------------

Date: Thu, 9 Nov 2000 09:42:31 GMT From: Richard Phillips <R.H.Phillips@OPEN.AC.UK> Subject: Re: SORT FAILED

Looks like an extent in your work space wasn't available - examine the DISPosition of the work DDNAME - is it allocated in CYLS, how many extents are available on the scratch DASD?

Try clearing down WORK before this step - it sometimes helps.

Anyway, consult your systems progs, as they can use omegamon or similar to monitor the job while it fails

Paula M. Adkins <PAdkins@CHECKFREE.COM> wrote in article <OF2764B20F.05671BE6-ON85256991.00808417@ckfr.com>... > Beginner SAS - MVS Batch - SAS V8 > > I have a job that returned with an RC 08 error and shows the following > error messages: > > ERROR: SAS data library SYS00312.T182735.RA000.CB92025C.R0178449 not found > on volume. > ERROR: Sort failed during output after writing 1726825 observations > successfully. > ERROR: Write to WORK.SUBS.DATA failed. File is full and may be damaged. > > I got results from the PROC FREQ but don't trust the data. Could it be the > JCL? Is it a mainframe issue? Any help would be appreciated. > > Paula M. Adkins, Risk Analyst I > Payment Systems Department > CheckFree Corporation > 6000 Perimeter Drive > Dublin, OH 43017 > 614-564-3117, 614-564-4308 > www.checkfree.com >

------------------------------

Date: Thu, 9 Nov 2000 04:55:57 -0500 From: Henrik Mohnssen <hm155@HOTMAIL.COM> Subject: Helvetica in RTF using ODS

Hello dear: I am working with SAS for windows version 8.2. How am I able to change the font_face to Helvetica ore Helvetica-narrow when I am using RTF in ODS. I have tried to change the style in proc template but nothing seems to happen. Well what happens is that the text comes out but in Arial? I appreciate your time and help.

Kind Regards,

Henrik Mohnssen

------------------------------

Date: Thu, 9 Nov 2000 12:27:17 +0100 From: Luca Boni <boni@CBA.UNIGE.IT> Subject: PHREG and dummy variables

Hi all:

Question about SAS V8...

Is there any statement (such as CLASS in the PROC GLM) to define a classification variable inside the PROC PHREG ? (i.e. the treatment variable has three levels and I would like to apply a stepwise selection method)

Thanks

Luca

\\\|/// \\ - - // ( @ @ ) ----o00o-(_)-o00o----------------------------------------------------

Luca Boni, MD Unit of Clinical Epidemiology and Trials Advanced Biotechnology Center-National Institute for Cancer Research GENOVA-ITALY Tel.: +39 010 5737477 Cellular Phone: +39 335 6777997 E-mail: boni@cba.unige.it

------------------------------

Date: Thu, 9 Nov 2000 04:15:14 -0800 From: Jie Qin <c674010@YAHOO.COM> Subject: Max. length of the record

I have a 5 million record file with a field called emailaddress. I want to know the max. length of the emailaddress. How can I do that? Thanks in advance.

__________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/

------------------------------

Date: Thu, 9 Nov 2000 13:46:12 +0100 From: Ace <b.rogers@VIRGIN.NET> Subject: Re: Max. length of the record

Jie Qin wrote: > > I have a 5 million record file with a field called > emailaddress. I want to know the max. length of the > emailaddress. How can I do that? Thanks in advance.

Well the simplest solution would probably be with SQL:

proc sql; select max(length(emailadress)) from mylib.mydata ;

possibly using NOPRINT option and the INTO: clause to place the result in a macro variable instead of the output window. Or using a CREATE to write to a new SAS dataset.

This might not always be the most efficient method, however. I'm sure Someone Who Knows (tm) will be along shortly...

HTH -- Bruce

------------------------------

Date: Thu, 9 Nov 2000 13:12:08 GMT From: jeremy_m3784@MY-DEJA.COM Subject: Application Dispatcher and WebAF JSP

Hi guys, I am havin a hard time installing and setting up Application Dispatcher. I've used the howto from SAS but to no avail. Does anyone know where to point me for further information? Also, I've just started learning JSP, and am looking for info on how to apply it to SAS. The problem is, I do not know Java. I wanted to attempt learning by examples, but again, I cannot find any relevant (for myself that is) from SAS. Can anyone point me out for that as well?

Thank you inredibly in advance,

Jeremy

jeremy.moncho@firmenich.com

Sent via Deja.com http://www.deja.com/ Before you buy.

------------------------------

Date: Thu, 9 Nov 2000 14:27:48 +0100 From: VITE Philippe <Philippe.VITE@GEP.FR> Subject: SAS Reference Card

In addition to SAS user's guide, there used to be a 'SAS Reference Card', which - i think - was very helpfull.

Does anyone know what i am talking about and if it still exists ?

------------------------------

Date: Thu, 9 Nov 2000 08:42:24 -0500 From: John Jones <jonesj@PHARMARESEARCH.COM> Subject: Re: PHREG and dummy variables

Hi Luca,

There does not appear to be a CLASS statement for PHREG. You'll need to create indicator variables in a data step. Pick a reference treatment and omit its respective variable from the PHREG model.

Data Shmata; set MyTreatment; TrT1=0; TrT2=0; TrT3=0; if (TrT='PLACEBO') then TrT1=1; else if (TrT='LOW') then TrT2=1; else if (TrT='HIGH') then TrT3=1; run;

Proc PHReg data=Shmata; model response = TrT2 TrT3; run;

At 12:27 PM 11/9/00 +0100, Luca Boni wrote: >Hi all: > >Question about SAS V8... > >Is there any statement (such as CLASS in the PROC GLM) to define a >classification variable inside the PROC PHREG ? (i.e. the treatment >variable has three levels and I would like to apply a stepwise selection >method) > >Thanks > >Luca > > > > > \\\|/// > \\ - - // > ( @ @ ) >----o00o-(_)-o00o---------------------------------------------------- > >Luca Boni, MD >Unit of Clinical Epidemiology and Trials >Advanced Biotechnology Center-National Institute for Cancer Research >GENOVA-ITALY >Tel.: +39 010 5737477 >Cellular Phone: +39 335 6777997 >E-mail: boni@cba.unige.it

------------------------------

Date: Thu, 9 Nov 2000 08:05:29 -0600 From: Thompson Bill T Contr USAFSAM/FEC <Bill.Thompson@BROOKS.AF.MIL> Subject: contrast estimates in catmod

I am using proc catmod with logit response and a repeated trial (4). Can someone explain how I would write the contrast estimates for trial.

Thanks in advance.

Bill Thompson

------------------------------

Date: Thu, 9 Nov 2000 09:05:35 -0500 From: Michael Bramley <bramley.m@PG.COM> Subject: Re: SAS Reference Card

I still have my IML reference card, and wish I had I SAS/??? reference card that listed all of the options for module ???.

Michael

Internet Mail Message Received from host: mailgw.cc.uga.edu [128.192.1.101]

Envelope Sender: owner-sas-l@LISTSERV.UGA.EDU

From: VITE Philippe <Philippe.VITE@GEP.FR> on 11/09/2000 08:27 AM

Please respond to VITE Philippe <Philippe.VITE@GEP.FR>

To: SAS-L@LISTSERV.UGA.EDU cc: (bcc: Michael Bramley-M/PGI) Subject: SAS Reference Card

In addition to SAS user's guide, there used to be a 'SAS Reference Card', which - i think - was very helpfull.

Does anyone know what i am talking about and if it still exists ?

------------------------------

Date: Thu, 9 Nov 2000 14:53:56 +0100 From: Luca Boni <boni@CBA.UNIGE.IT> Subject: Re: PHREG and dummy variables

At 08.42 09/11/2000 -0500, John Jones wrote: > >There does not appear to be a CLASS statement for PHREG. You'll need to >create indicator variables in a data step. Pick a reference treatment and >omit its respective variable from the PHREG model. > >Data Shmata; > set MyTreatment; > TrT1=0; > TrT2=0; > TrT3=0; > if (TrT='PLACEBO') then TrT1=1; > else if (TrT='LOW') then TrT2=1; > else if (TrT='HIGH') then TrT3=1; >run; > >Proc PHReg data=Shmata; > model response = TrT2 TrT3; >run;

Off course, but with a forward, backward or stepwise selection of variables TrT1 and TrT2 and TrT3 are not all together entered or removed from the model.

Luca

\\\|/// \\ - - // ( @ @ ) ----o00o-(_)-o00o----------------------------------------------------

Luca Boni, MD Unit of Clinical Epidemiology and Trials Advanced Biotechnology Center-National Institute for Cancer Research GENOVA-ITALY Tel.: +39 010 5737477 Cellular Phone: +39 335 6777997 E-mail: boni@cba.unige.it

------------------------------

Date: Thu, 9 Nov 2000 14:01:12 GMT From: Charles Patridge <Charles_S_Patridge@PRODIGY.NET> Subject: Re: Max. length of the record

Jie,

Bruce's solution will work just fine.

Here is a DATASTEP / Proc Summary solution to get the same answer:

/*** SAS Version 6.12 on OpenVMS ***/ data test; length emailadd $ 200. ; emailadd = 'Charles_S_Patridge@prodigy.net'; output; emailadd = 'Charles.Patridge@thehartford.com'; output; run;

data maxlen; set test; maxlen = length(emailadd); /*** here is where you get the length ***/ keep maxlen; run;

proc summary data=maxlen nway missing; var maxlen; output out=maxlen (drop=_type_ _freq_) max=maxlen min=minlen; run;

proc print; run;

HTH, Charles Patridge

In article <3A0A9C94.3FD14392@virgin.net>, Ace <b.rogers@virgin.net> wrote: > Jie Qin wrote: > > > > I have a 5 million record file with a field called > > emailaddress. I want to know the max. length of the > > emailaddress. How can I do that? Thanks in advance. > > Well the simplest solution would probably be with SQL: > > proc sql; > select max(length(emailadress)) from mylib.mydata ; > > possibly using NOPRINT option and the INTO: clause to place the result > in a macro variable instead of the output window. Or using a CREATE to > write to a new SAS dataset. > > This might not always be the most efficient method, however. I'm sure > Someone Who Knows (tm) will be along shortly... > > HTH > -- > Bruce >

-- Charles Patridge - PDPC, Ltd. 172 Monce Road - Burlington, CT 06013 USA Phone: 860-673-9278 or 860-675-9026 Email: Charles_S_Patridge@prodigy.net - Web: www.sconsig.com

Sent via Deja.com http://www.deja.com/ Before you buy.

------------------------------

Date: Thu, 9 Nov 2000 08:32:43 -0600 From: Greg Woolridge <greg.woolridge@TAP.COM> Subject: Re: Max. length of the record

Couldn't it be done in a single data step using a RETAIN:

data maxlen (end=eof); set test; retain maxlen .; if length(emailadd)>maxlen then maxlen = length(emailadd); /*** here is where you get the length ***/ keep maxlen; if eof then output; run;

Greg M. Woolridge Manager, Study Programming TAP Pharmaceutical Products Inc. e-mail: greg.woolridge@tap.com phone: 847-582-2332 fax: 847-582-2403

Charles Patridge <Charles_S_Patridge@PR To: SAS-L@LISTSERV.UGA.EDU ODIGY.NET> cc: Sent by: "SAS(r) Subject: Re: Max. length of the record Discussion" <SAS-L@LISTSERV.UGA.ED U>

11/09/00 08:01 AM Please respond to Charles_S_Patridge

Jie,

Bruce's solution will work just fine.

Here is a DATASTEP / Proc Summary solution to get the same answer:

/*** SAS Version 6.12 on OpenVMS ***/ data test; length emailadd $ 200. ; emailadd = 'Charles_S_Patridge@prodigy.net'; output; emailadd = 'Charles.Patridge@thehartford.com'; output; run;

data maxlen; set test; maxlen = length(emailadd); /*** here is where you get the length ***/ keep maxlen; run;

proc summary data=maxlen nway missing; var maxlen; output out=maxlen (drop=_type_ _freq_) max=maxlen min=minlen; run;

proc print; run;

HTH, Charles Patridge

In article <3A0A9C94.3FD14392@virgin.net>, Ace <b.rogers@virgin.net> wrote: > Jie Qin wrote: > > > > I have a 5 million record file with a field called > > emailaddress. I want to know the max. length of the > > emailaddress. How can I do that? Thanks in advance. > > Well the simplest solution would probably be with SQL: > > proc sql; > select max(length(emailadress)) from mylib.mydata ; > > possibly using NOPRINT option and the INTO: clause to place the result > in a macro variable instead of the output window. Or using a CREATE to > write to a new SAS dataset. > > This might not always be the most efficient method, however. I'm sure > Someone Who Knows (tm) will be along shortly... > > HTH > -- > Bruce >

-- Charles Patridge - PDPC, Ltd. 172 Monce Road - Burlington, CT 06013 USA Phone: 860-673-9278 or 860-675-9026 Email: Charles_S_Patridge@prodigy.net - Web: www.sconsig.com

Sent via Deja.com http://www.deja.com/ Before you buy.

------------------------------

Date: Thu, 9 Nov 2000 08:59:09 -0600 From: Jaclyn Whitehorn <jaclyn@BAMA.UA.EDU> Subject: Re: citation for SAS v8

Also, if you are trying to reference the software, as opposed to the manuals, you may want to take a look at: http://www.sas.com/news/newsroom/guidelines.html (scroll all the way down to "Referencing Data Analysis Performed with SAS(r) Software")

- Jaclyn

------------------------------

Date: Thu, 9 Nov 2000 09:55:57 -0500 From: Eugene Komaroff <ekomarof@SDAC.HARVARD.EDU> Subject: unlinking formats

I need to work with a data set that someone else created, but do not have the formats for two variables. The variables are not needed in my analysis so I created "phony" formats to make the SET statement to work. What is a better way to disengage variables from their assigned formats.

Eugene Komaroff ekomarof@sdac.harvard.edu

------------------------------

Date: Thu, 9 Nov 2000 08:13:04 -0700 From: Michael Thomas <mjthom4@USWEST.COM> Subject: Re: SAS Reference Card

I just saw one yesterday..... I hadn't seen a SAS Reference Card in years and I think it is 5.18 vintage.....

Michael

VITE Philippe wrote:

> In addition to SAS user's guide, there used to be a 'SAS Reference Card', > which - i think - was very helpfull. > > Does anyone know what i am talking about and if it still exists ?

------------------------------

Date: Thu, 9 Nov 2000 10:13:22 -0500 From: Dirk Spruck <Dirk.Spruck@AVENTIS.COM> Subject: Re: unlinking formats

To disengage all variables from formats use

format _all_;

HTH

Dirk

Dirk Spruck Biometrical Data Manager Aventis Behring, King of Prussia, PA USA e-mail: Dirk.Spruck@Aventis.COM

-----Original Message----- From: Eugene Komaroff [mailto:ekomarof@SDAC.HARVARD.EDU] Sent: Thursday, November 09, 2000 9:56 AM To: SAS-L@LISTSERV.UGA.EDU Subject: unlinking formats

I need to work with a data set that someone else created, but do not have the formats for two variables. The variables are not needed in my analysis so I created "phony" formats to make the SET statement to work. What is a better way to disengage variables from their assigned formats.

Eugene Komaroff ekomarof@sdac.harvard.edu

------------------------------

Date: Thu, 9 Nov 2000 10:14:39 -0500 From: Girish Patel <gspatel@PEPCO.COM> Subject: Re: unlinking formats

Eugene,

This was once an interview question to me.......

If some body forgets to tell you the format or forgets to send the format along with the data, what would you do ?

My answer was to ask the person who defined and send to ........

Eugene Komaroff <ekomarof@SDAC.HA To: SAS-L@LISTSERV.UGA.EDU RVARD.EDU> cc: Sent by: "SAS(r) Subject: unlinking formats Discussion" <SAS-L@LISTSERV.U GA.EDU>

11/09/2000 09:55 AM Please respond to Eugene Komaroff

I need to work with a data set that someone else created, but do not have the formats for two variables. The variables are not needed in my analysis so I created "phony" formats to make the SET statement to work. What is a better way to disengage variables from their assigned formats.

Eugene Komaroff ekomarof@sdac.harvard.edu

------------------------------

Date: Thu, 9 Nov 2000 10:10:03 -0500 From: "Malarkey, Pat" <PMALARKEY@ULLICO.COM> Subject: Re: SAS Reference Card

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04A5F.248994DE Content-Type: text/plain; charset="iso-8859-1"

Hi, Philippe!

I think your reference card has mutated into a booklet (ala the IBM Yellow Card). I have a V6 "SAS Language and Procedures: Syntax" booklet which contains syntax, operators, functions, CALL routines, Informats and Formats and a whole bunch of other goodies.

- Pat

-----Original Message----- From: VITE Philippe [mailto:Philippe.VITE@GEP.FR] Sent: Thursday, November 09, 2000 8:28 AM To: SAS-L@LISTSERV.UGA.EDU Subject: SAS Reference Card

In addition to SAS user's guide, there used to be a 'SAS Reference Card', which - i think - was very helpfull.

Does anyone know what i am talking about and if it still exists ?

------_=_NextPart_001_01C04A5F.248994DE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: SAS Reference Card</TITLE> </HEAD> <BODY>

<P><FONT SIZE=3D2>Hi, Philippe!</FONT> </P>

<P><FONT SIZE=3D2>I think your reference card has mutated into a = booklet (ala the IBM Yellow Card).&nbsp; I have a V6 &quot;SAS Language = and Procedures: Syntax&quot; booklet which contains syntax, operators, = functions, CALL routines, Informats and Formats and a whole bunch of = other goodies.</FONT></P>

<P><FONT SIZE=3D2>- Pat</FONT> </P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: VITE Philippe [<A = HREF=3D"mailto:Philippe.VITE@GEP.FR">mailto:Philippe.VITE@GEP.FR</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: Thursday, November 09, 2000 8:28 AM</FONT> <BR><FONT SIZE=3D2>To: SAS-L@LISTSERV.UGA.EDU</FONT> <BR><FONT SIZE=3D2>Subject: SAS Reference Card</FONT> </P> <BR>

<P><FONT SIZE=3D2>In addition to SAS user's guide, there used to be a = 'SAS Reference Card',</FONT> <BR><FONT SIZE=3D2>which - i think - was very helpfull.</FONT> </P>

<P><FONT SIZE=3D2>Does anyone know what i am talking about and if it = still exists ?</FONT> </P>

</BODY> </HTML> ------_=_NextPart_001_01C04A5F.248994DE--

------------------------------

Date: Thu, 9 Nov 2000 10:15:34 -0500 From: Gerhard Hellriegel <ghellrieg@T-ONLINE.DE> Subject: Re: unlinking formats

On Thu, 9 Nov 2000 09:55:57 -0500, Eugene Komaroff <ekomarof@SDAC.HARVARD.EDU> wrote:

>I need to work with a data set that someone else created, but do not >have the formats for two variables. The variables are not >needed in my analysis so I created "phony" formats to make the >SET statement to work. What is a better way to disengage >variables from their assigned formats. > >Eugene Komaroff >ekomarof@sdac.harvard.edu

you should use the option NOFMTERR After you set this, missing formats do not generate errors. If you want, you can also delete the formats in the DIR window with the R (=Rename) line command. Just blank out any formats / informats.

------------------------------

Date: Thu, 9 Nov 2000 10:32:57 -0500 From: John Jones <jonesj@PHARMARESEARCH.COM> Subject: Re: PHREG and dummy variables

Luca,

Even with if you let the procedure select your model a reference group will be needed.

If these are your treatments though I'm wondering why you'd use a stepwise selection process?

John

At 02:53 PM 11/9/00 +0100, Luca Boni wrote: >At 08.42 09/11/2000 -0500, John Jones wrote: > > > >There does not appear to be a CLASS statement for PHREG. You'll need to > >create indicator variables in a data step. Pick a reference treatment and > >omit its respective variable from the PHREG model. > > > >Data Shmata; > > set MyTreatment; > > TrT1=0; > > TrT2=0; > > TrT3=0; > > if (TrT='PLACEBO') then TrT1=1; > > else if (TrT='LOW') then TrT2=1; > > else if (TrT='HIGH') then TrT3=1; > >run; > > > >Proc PHReg data=Shmata; > > model response = TrT2 TrT3; > >run; > >Off course, but with a forward, backward or stepwise selection of variables >TrT1 and TrT2 and TrT3 are not all together entered or removed from the model. > >Luca > > > > \\\|/// > \\ - - // > ( @ @ ) >----o00o-(_)-o00o---------------------------------------------------- > >Luca Boni, MD >Unit of Clinical Epidemiology and Trials >Advanced Biotechnology Center-National Institute for Cancer Research >GENOVA-ITALY >Tel.: +39 010 5737477 >Cellular Phone: +39 335 6777997 >E-mail: boni@cba.unige.it

------------------------------

End of SAS-L Digest - 9 Nov 2000 - Special issue (#2000-1150) *************************************************************

----------------------------------------------------- Confidentiality Notice: This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited.

If you have received this e-mail transmission in error, please reply to the sender, so that we can arrange for proper delivery, and then please delete the message from your inbox. Thank you.


Back to: Top of message | Previous page | Main SAS-L page