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
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). 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.</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.
