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 (February 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 22 Feb 2002 09:06:05 -0600
Reply-To:     Bob Hutchins <bhutchins@GTRESOURCES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bob Hutchins <bhutchins@GTRESOURCES.COM>
Subject:      Sas Need
In-Reply-To:  <200202221501.KAA22154@pool1.valueweb.net>
Content-type: text/plain; charset=iso-8859-1

I hope you don't mind me posting this...

I have a client here in Nashville, TN who needs a SAS Programmer I to provide programming support for reporting, analysis, predictive modeling, creating mail files, etc. This includes reading data into SAS, performing data audit reports, data manipulation and transformations, and generating basic reports using PROC MEANS, PROC FREQ and PROC TABULATE. Other analysis responsibilities may include: tracking and measuring direct mail campaigns, providing recommendations, and ad-hoc analysis.

If any one is interested, please e-mail me at bob.hutchins@weberize.com

Thanks!

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Automatic digest processor Sent: Friday, February 22, 2002 9:01 AM To: Recipients of SAS-L digests Subject: SAS-L Digest - 22 Feb 2002 - Special issue (#2002-144)

There are 13 messages totalling 1003 lines in this issue.

Topics in this special issue:

1. Parse a Macro Variable into Multiple Observations 2. how to convert numeric to date variables? 3. Automate Files Import by using SAS statement (4) 4. Tabulate Column Headings 5. SAS/Connect on a NT Server using Novell Netware 6. 让干柴遇到烈火!:) #5712 7. MVS Question 8. Consultant for data transporting 9. GeneralizedLinearMixedModels (had no Subject) 10. Table+Graph on one screen.

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

Date: Thu, 21 Feb 2002 19:58:36 -0800 From: Mike Stuart <muon33@NYC.RR.COM> Subject: Re: Parse a Macro Variable into Multiple Observations

Charles_S_Patridge@PRODIGY.NET (Charles Patridge) wrote in message news:<200202211922.g1LJMI410655@listserv.cc.uga.edu>... > Hi Mike, > > Just in case you need to deal with Character List in the future - > > /*** TIP 00324 ***/ > I'm trying to write some code that will take a macro variable like > this: > > %let list=4,23,89,78,41,13 ; > > and create a dataset like this: > > list > 4 > 23 > 89 > 78 > 41 > 13 > -------------------------------------------------------------------------- -- > ---- > Solution #1 > Paul M. Dorfman > Email: paul_dorfman@HOTMAIL.COM > > %let list=4,23,89,78,41,13 ; > data list ; > do list = &list ; > output ; > end ; > run ; > > -------------------------------------------------------------------------- -- > ---- > Solution #2 > Pete Lund > Email: pete.lund@nwcsr.com > > %let list=4,23,89,78,41,13 ; > data test(drop=i); > do i = 1 by 1 while (scan("&list",i,',') ne ''); > value = scan("&list",i,','); > output; > end; > run; > > -------------------------------------------------------------------------- -- > ---- > Solution #3 (IN CASE LIST is Character) > Charles Patridge (Paul's solution adapted - Nice Trick Paul!) > Email: Charles_S_Patridge@prodigy.net > > > %let list='0A1','4','23','89','78','41','13','1234567890'; > data list ; > length list $ 10. ; > do list = &list ; > output ; > end ; > run ; > > > /*** end of TIP 00324 ***/

Sorry -- didn't mean to be ungracious. Thanks also to Charles, Pete and David for the quick response.

--m.

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

Date: Fri, 22 Feb 2002 09:08:08 -0500 From: "Brucken, Nancy" <Nancy.Brucken@PFIZER.COM> Subject: Re: how to convert numeric to date variables?

Hi all, A better method for calculating age is this SAS-L classic from Billy Kreuter by way of a 12/23/98 posting from Karsten Self (http://www.listserv.uga.edu/cgi-bin/wa?A2=ind9812D&L=sas-l&P=R6283):

%macro age( date, birth );

/******* * Billy Kreuter, Back Pain Outcome Assessment Team, * University of Washington * billyk@u.washington.edu http://weber.u.washington.edu/~billyk/ * voice or voice mail: 206-543-5007 * fax: 206-685-3467 * mailstop: 354807 * * Here's my occasionally posted %AGE macro, which returns the age in * integer years incremented exactly on a person's birthday. * */;

floor( ( intck( 'month', &birth., &date. ) - ( day( &date. ) < day( &birth )))/ 12 ) %mend age;

Hope this helps, Nancy

Nancy Brucken Clinical/Regulatory Informatics Pfizer Global Research & Development, Ann Arbor (734) 622-5767 E-mail address: Nancy.Brucken@pfizer.com

-----Original Message----- From: Jian WU [mailto:JWU@DOH.HEALTH.NSW.GOV.AU] Sent: Thursday, February 21, 2002 6:48 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: how to convert numeric to date variables?

I reckon intck() is not a good way to calculate 'year' since only integer is returned for 'year'. Apparently, it's not suitable for many occassions such as research.

data _null_; age=intck('year', '01jan69'd, '31dec69'd); put age=; run; ________

age=0

JW

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

Date: Fri, 22 Feb 2002 09:28:27 -0500 From: Charles Kincaid <ckincaid@VENTURIPARTNERS.COM> Subject: Re: Automate Files Import by using SAS statement

This is a MIME message. If you are reading this text, you may want to consider changing to a mail reader or gateway that understands how to properly handle MIME multipart messages.

--=_E3BEA494.9AFB87AD Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable

Hello,

There are a number ways to do this. Essentially, you execute the command = from within SAS.

data _null_; rc=3Dsystem("d:\source>dir > d:\source\filelist.txt"); run;

This can be called conditionally, also. The other commands similar to = this one are=20

call system X %SYSEXEC

You could probably also set up a pipe in a fileref and read that straight = in. I haven't actually tried this, but I've seen similar. =20

filename dirlist pipe "dir d:\source\*"; data filelist; infile dirlist missover pad; input filename $40-60; memname=3Dscan(filename,1,.); ext=3Dscan(filename,2,.); run;

Others more competent than I can give you more info.

HTHABA

Chuck

>>> siapaini <siapaini@INAME.COM> 02/22/02 12:53AM >>> Peter/ Jim,

Thanks for your reply and tried the suggestions but it didn't really works. Perhaps I should have explained in more detail.

I have about 69 files in the d:\source\ folder and need to import all of them. There is no standard naming criteria for these text files. What I have done is go to command prompt and print the list of files into a text file by typed "d:\source>dir > d:\source\filelist.txt". Then, I execute the program below in SAS.

Would like to like if there is anyway for me to skip the part where I have to print the file list in command prompt. Any helps and advice are much appreciated.

data filelist; infile "d:\source\filelist.txt" missover pad; input filename $40-60; memname=3Dscan(filename,1,.); ext=3Dscan(filename,2,.); run;

proc sort data=3Dfilelist out=3Dlistfile (where=3D(ext in ("txt"))); by memname ext; run;

options mprint; %macro abc(try); data _null_; if 0 then set listfile nobs=3Dn; call symput('n',n); stop; run;

%put &n; %if &n >=3D 1 %then %do; data _null_; set listfile; mname =3D "mva"|| trim(left(put(_n_,8.))); call symput( mname, left(trim(memname))); run; %end;

%do i=3D1 %to &n; data _null_; nama=3Dleft(trim("&&mva&i")); call symput ('name',name); run;

data &nama; infile "d:\source\&name..txt" missover pad; input field $7.; run;

proc append base =3D allfiles data =3D&name; run; %end; %mend;

%abc();

--=_E3BEA494.9AFB87AD Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type= > <META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR></HEAD> <BODY style=3D"FONT: 10pt Times New Roman; MARGIN-LEFT: 2px; MARGIN-TOP: = 2px"> <DIV>Hello,</DIV> <DIV>&nbsp;</DIV> <DIV>There are a number ways to do this.&nbsp; Essentially, you execute = the=20 command from within SAS.<FONT face=3D"Times New Roman"></FONT></DIV> <DIV><FONT face=3D"Times New Roman"></FONT>&nbsp;</DIV> <DIV><FONT face=3D"Times New Roman">data _null_;<BR>&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;=20 rc=3Dsystem("d:\source&gt;dir &gt; d:\source\filelist.txt");<BR>run;</FONT>= </DIV> <DIV>&nbsp;</DIV> <DIV>This can be called conditionally, also.&nbsp; The other commands = similar to=20 this one are </DIV> <DIV>&nbsp;</DIV> <DIV>call system</DIV> <DIV>X</DIV> <DIV>%SYSEXEC</DIV> <DIV>&nbsp;</DIV> <DIV>You could probably also set up a pipe in a fileref and read that = straight=20 in.&nbsp; I haven't actually tried this, but I've seen similar.&nbsp; = </DIV> <DIV>&nbsp;</DIV> <DIV>filename dirlist pipe "dir d:\source\*";</DIV> <DIV>data filelist;<BR>&nbsp;&nbsp;&nbsp;&nbsp; infile&nbsp;dirlist = missover=20 pad;<BR>&nbsp;&nbsp;&nbsp;&nbsp; input filename=20 $40-60;<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20 memname=3Dscan(filename,1,.);<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20 ext=3Dscan(filename,2,.);<BR>run;<BR><BR>Others more competent than I can = give you=20 more info.</DIV> <DIV>&nbsp;</DIV> <DIV>HTHABA</DIV> <DIV>&nbsp;</DIV> <DIV>Chuck<BR><BR>&gt;&gt;&gt; siapaini &lt;siapaini@INAME.COM&gt; = 02/22/02=20 12:53AM &gt;&gt;&gt;<BR>Peter/ Jim,<BR><BR>Thanks for your reply and tried = the=20 suggestions but it didn't really<BR>works. Perhaps I should have explained = in=20 more detail.<BR><BR>I have about 69 files in the d:\source\ folder and = need to=20 import all<BR>of them. There is no standard naming criteria for these = text=20 files.<BR>What I have done is go to command prompt and print the list = of=20 files<BR>into a text file by typed "d:\source&gt;dir &gt;=20 d:\source\filelist.txt".<BR>Then, I execute the program below in=20 SAS.<BR><BR>Would like to like if there is anyway for me to skip the part = where=20 I<BR>have to print the file list in command prompt.&nbsp; Any helps and=20 advice<BR>are much appreciated.<BR><BR>data=20 filelist;<BR>&nbsp;&nbsp;&nbsp;&nbsp; infile "d:\source\filelist.txt" = missover=20 pad;<BR>&nbsp;&nbsp;&nbsp;&nbsp; input filename=20 $40-60;<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20 memname=3Dscan(filename,1,.);<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20 ext=3Dscan(filename,2,.);<BR>run;<BR><BR>proc sort data=3Dfilelist = out=3Dlistfile=20 (where=3D(ext in ("txt")));<BR>&nbsp;&nbsp;&nbsp; by memname=20 ext;<BR>run;<BR><BR>options mprint;<BR>%macro abc(try);<BR>data=20 _null_;<BR>&nbsp;&nbsp;&nbsp; if 0 then set listfile=20 nobs=3Dn;<BR>&nbsp;&nbsp;&nbsp; call symput('n',n);<BR>&nbsp;&nbsp;&nbsp;= =20 stop;<BR>run;<BR><BR>%put &amp;n;<BR>%if &amp;n &gt;=3D 1 %then=20 %do;<BR>&nbsp;&nbsp;&nbsp; data=20 _null_;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set=20 listfile;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mname =3D = "mva"||=20 trim(left(put(_n_,8.)));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;=20 call symput( mname, left(trim(memname)));<BR>&nbsp;&nbsp;&nbsp;=20 run;<BR>%end;<BR><BR>&nbsp;&nbsp;&nbsp; %do i=3D1 %to=20 &amp;n;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data=20 _null_;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;=20 nama=3Dleft(trim("&amp;&amp;mva&amp;i"));<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 call symput ('name',name);<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20=

run;<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data=20 &amp;nama;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;=20 infile "d:\source\&amp;name..txt" missover=20 pad;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;=20 input field $7.;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20 run;<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; proc append base = =3D=20 allfiles data =3D&amp;name;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= =20 run;<BR>&nbsp;&nbsp;&nbsp;=20 %end;<BR>%mend;<BR><BR>%abc();<BR></DIV></BODY></HTML>

--=_E3BEA494.9AFB87AD--

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

Date: Fri, 22 Feb 2002 15:27:06 +0100 From: Peter Crawford <peter.crawford@DB.COM> Subject: Re: Automate Files Import by using SAS statement

You can avoid the macro, dos box, intermediate files etc, if it is only the final, appended dataset you need ! simply try data allfileP; length filename $100 ; infile 'd:\source\*.txt' filename=filename truncover; input field $7. ; /* code for testing if filename ne lag(filename) then put /filename=; put field= ; *********/ ; run;

Is the result in allfileP not the same as work.allfiles ? Is the log file informative with the if and put statements?

For my test, I ran the code from the sas system viewer ! with this result

NOTE: SAS initialization used: real time 1.12 seconds cpu time 1.09 seconds

1 data allfileP; 2 length filename $100 ; 3 infile '!temp\*.txt' filename=filename truncover; 4 input field $7. ; 5 if filename ne lag(filename) then put /filename=; 6 put field= ; 7 run;

NOTE: The infile '!temp\*.txt' is: File Name=C:\TEMP\ldap.txt, RECFM=V,LRECL=256

filename=C:\TEMP\ldap.txt field=ldap_in field=filter field=returni <<<<<<<<<snipped >>> field=telepho field=1 match NOTE: 29 records were read from the infile '!temp\*.txt'. The minimum record length was 9. The maximum record length was 60. NOTE: The data set WORK.ALLFILEP has 29 observations and 1 variables. NOTE: DATA statement used: real time 0.07 seconds cpu time 0.06 seconds

Regards Peter

Datum: 22/02/2002 14:03 An: SAS-L@LISTSERV.UGA.EDU

Antwort an: siapaini <siapaini@INAME.COM>

Betreff: Re: Automate Files Import by using SAS statement Nachrichtentext:

Peter/ Jim,

Thanks for your reply and tried the suggestions but it didn't really works. Perhaps I should have explained in more detail.

I have about 69 files in the d:\source\ folder and need to import all of them. There is no standard naming criteria for these text files. What I have done is go to command prompt and print the list of files into a text file by typed "d:\source>dir > d:\source\filelist.txt". Then, I execute the program below in SAS.

Would like to like if there is anyway for me to skip the part where I have to print the file list in command prompt. Any helps and advice are much appreciated.

data filelist; infile "d:\source\filelist.txt" missover pad; input filename $40-60; memname=scan(filename,1,.); ext=scan(filename,2,.); run;

proc sort data=filelist out=listfile (where=(ext in ("txt"))); by memname ext; run;

options mprint; %macro abc(try); data _null_; if 0 then set listfile nobs=n; call symput('n',n); stop; run;

%put &n; %if &n >= 1 %then %do; data _null_; set listfile; mname = "mva"|| trim(left(put(_n_,8.))); call symput( mname, left(trim(memname))); run; %end;

%do i=1 %to &n; data _null_; nama=left(trim("&&mva&i")); call symput ('name',name); run;

data &nama; infile "d:\source\&name..txt" missover pad; input field $7.; run;

proc append base = allfiles data =&name; run; %end; %mend;

%abc();

--

Diese E-Mail enth鋖t vertrauliche und/oder rechtlich gesch黷zte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt黰lich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

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

Date: Fri, 22 Feb 2002 15:32:00 +0100 From: Jim Groeneveld <J.Groeneveld@ITGROUPS.COM> Subject: Re: Automate Files Import by using SAS statement

Dear Siapaini,

Just as I alreay indicated, but now explicitely coded (*untested*): change your code part:

data filelist; infile "d:\source\filelist.txt" missover pad; input filename $40-60;

by:

FILENAME AllFiles PIPE "DIR /B D:\SOURCE\*.*";

DATA FileList; LENGTH FileName $ 100; INFILE AllFiles TRUNCOVER; INPUT FileName;

Regards - Jim. -- Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070 senior statistician, P.O. Box 1 fax. +31 412 407 080 senior data manager 5350 AA BERGHEM IMRO TRAMARKO: a CRO J.Groeneveld@ITGroups.com the Netherlands in clinical research

As time elapses it is getting later.

Notice of confidentiality: this e-mail may contain confidential information intended for the addressed recipient only. If you have received this e-mail in error please delete this e-mail and please notify the sender so that proper delivery can be arranged.

> -----Original Message----- > From: siapaini [SMTP:siapaini@INAME.COM] > Sent: Friday, February 22, 2002 6:53 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: Automate Files Import by using SAS statement > > Peter/ Jim, > > Thanks for your reply and tried the suggestions but it didn't really > works. Perhaps I should have explained in more detail. > > I have about 69 files in the d:\source\ folder and need to import all > of them. There is no standard naming criteria for these text files. > What I have done is go to command prompt and print the list of files > into a text file by typed "d:\source>dir > d:\source\filelist.txt". > Then, I execute the program below in SAS. > > Would like to like if there is anyway for me to skip the part where I > have to print the file list in command prompt. Any helps and advice > are much appreciated. > > data filelist; > infile "d:\source\filelist.txt" missover pad; > input filename $40-60; > memname=scan(filename,1,.); > ext=scan(filename,2,.); > run; > > proc sort data=filelist out=listfile (where=(ext in ("txt"))); > by memname ext; > run; > > options mprint; > %macro abc(try); > data _null_; > if 0 then set listfile nobs=n; > call symput('n',n); > stop; > run; > > %put &n; > %if &n >= 1 %then %do; > data _null_; > set listfile; > mname = "mva"|| trim(left(put(_n_,8.))); > call symput( mname, left(trim(memname))); > run; > %end; > > %do i=1 %to &n; > data _null_; > nama=left(trim("&&mva&i")); > call symput ('name',name); > run; > > data &nama; > infile "d:\source\&name..txt" missover pad; > input field $7.; > run; > > proc append base = allfiles data =&name; > run; > %end; > %mend; > > %abc();

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

Date: Fri, 22 Feb 2002 15:35:40 +0100 From: Jim Groeneveld <J.Groeneveld@ITGROUPS.COM> Subject: Re: Tabulate Column Headings

Dear Dave,

Not as far as I know, except while limiting the column width to 1.

Regards - Jim. -- Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070 senior statistician, P.O. Box 1 fax. +31 412 407 080 senior data manager 5350 AA BERGHEM IMRO TRAMARKO: a CRO J.Groeneveld@ITGroups.com the Netherlands in clinical research

As time elapses it is getting later.

Notice of confidentiality: this e-mail may contain confidential information intended for the addressed recipient only. If you have received this e-mail in error please delete this e-mail and please notify the sender so that proper delivery can be arranged.

> -----Original Message----- > From: S. David Riba [SMTP:dave@JADETEK.COM] > Sent: Friday, February 22, 2002 7:04 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Tabulate Column Headings > > Is it possible to rotate the column heads in a table created with Proc > Tabulate? > > In other words, instead of this: > column1 column2 column3 > I want something like this: > c c c > o o o > l l l > u u u > m m m > n n n > 1 2 3 > > Any suggestions? > > Dave Riba > > -------------------------------------------------------------------------- > -- > S. David Riba INTERNET: dave@JADETEK.COM > <mailto:dave@JADETEK.COM> > JADE Tech, Inc. <http://www.jadetek.com> > P O Box 4517 > Clearwater, FL 33758 SAS Certified Professional - V6 > VOICE: (727) 726-6099 A SAS Alliance Partner > SSU 2001 Co-Chair www.ssu2001.com > <http://www.ssu2001.com> > SAS. It's not just an attitude > >

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

Date: Fri, 22 Feb 2002 14:33:25 +0000 From: Simon Gillow <Simon.Gillow@BBG.CO.UK> Subject: Re: SAS/Connect on a NT Server using Novell Netware

Thanks for all your suggestions so far. I have experimented with NET USE but have had no success so far. It appears that I can't remote submit the NET USE command as when I do it doesnt do anything. I tested this by running the following line remotely and locally:

NET USE > c:\out.txt

When run locally the out.txt command contains a listing of my drives whereas when run remotely the file doesnt even get created.

I have also tried adding in my password and adding in my NT context but to no avail.

Any ideas anyone?

Thanks,

Simon

2 signon; WARNING: The SAS/CONNECT product with which the global statement 'signon' is associated will expire within 30 days. Please contact your SAS installation representative to have it renewed. WARNING: The SAS/CONNECT product with which CONNECT is associated will expire within 30 days. Please contact your SAS installation representative to have it renewed. NOTE: Remote signon to NBAS04 commencing (SAS Release 8.02.02M0P012301). WARNING: The SAS/CONNECT product with which SASXDMR is associated will expire within 30 days. Please contact your SAS installation representative to have it renewed. NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0) Licensed to MORTGAGE EXPRESS LIMITED, Site 0086345001. NOTE: This session is executing on the WIN_NTSV platform.

WARNING: Your system is scheduled to expire on February 28, 2002, which is 6 days from now. Please contact your SAS Software Representative to obtain your updated SETINIT information. The SAS System will no longer function on or after that date. NOTE: SAS initialization used: real time 0.35 seconds cpu time 0.35 seconds

NOTE: Remote signon to NBAS04 complete. 3 4 rsubmit; WARNING: The SAS/CONNECT product with which the global statement 'rsubmit' is associated will expire within 30 days. Please contact your SAS installation representative to have it renewed. NOTE: Remote submit to NBAS04 commencing. 1 OPTIONS NOXWAIT NOXSYNC; 2 3 x 'net use \\mx3\risk\data /user:P01964' 3 ! ; 4 5 libname pants '\\mx3\risk\data\data'; NOTE: Library PANTS does not exist. NOTE: Remote submit to NBAS04 complete.

Date: Thu, 21 Feb 2002 10:49:15 -0800 From: David Rubanowice <rubanowice.d@GHC.ORG> Subject: Re: SAS/Connect on a NT Server using Novell Netware

Hi, Simon,

Yes, your SAS code needs to 'login' to the Novell server within the rsubmitted code. We have a similar server arrangement and we are required to issue a NET USE operating system command before issuing the netware libname statement. Perhaps that will work for you, too. This also means that client and server drive mappings don't have to match which is a good thing.

Within rsubmitted code:

x 'net use \\SERVER\SHARE /user:.USERID.CONTEXT'; libname N '\\SERVER\SHARE\PATH';

Fill in SERVER, SHARE, USERID, CONTEXT, and PATH with specifics from your environment. One way to get the CONTEXT, which will have several levels delimited by periods, is to look at the advanced tab of your Novell login prompt window. Also visible in control panel Novell client properties.

For example:

x 'net use \\CEDAR\DeptData /user:.jwilliams.findept.admin.north.rsfn.rda'; libname FinData '\\CEDAR\DeptData\Finance\Sasdata';

Oh, one other thing, I think the Novell and NT passwords for the USERID being used (to log in to the NT server and then the Novell server) must match (case sensitive) or the Novell password will have to be hardcoded in the net use command (yuck!) between \\SERVER\SHARE and /user:...

Hope this helps.

David

********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

Bradford & Bingley plc Registered Office: PO Box 88, Croft Road, Crossflatts, Bingley, West Yorkshire, BD16 2UA Registered in England No. 3938288 Regulated by the Financial Services Authority and a Member of the General Insurance Standards Council.

With immediate effect all group internet addresses will change from BBBS-group.co.uk to bbg.co.uk

http://www.bbg.co.uk Bradford Bingley plc **********************************************************************

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

Date: Fri, 22 Feb 2002 18:33:36 +0800 From: saskatoon@163.NET Subject: 让干柴遇到烈火!:) #5712

1784 七彩谷力荐新品:

性爱1+1,原装进口,让干柴遇到烈火,男欢女爱。

给予她双倍的诱惑!

性爱1+1(佛裸蒙+西班牙D5水) ,详细信息请见: http://shop.7cv.com/pdetail.php?localcode=0040010019&asstfrom=7cvtest94

--------------------------- 按照国际惯例,只要本邮件包括“联系信息”和“移除信息”,就不应被看做垃圾信件 。如果您想我们从邮件列表中移除您的邮件地址,请用您想移除的信箱发信到:7cvmail @btamail.net.cn,信件主题:“Remove",如果本邮件给您带来了不便,我们深表歉意 。

Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with "remove" and include your "original email address/addresses" in the subject heading send to 7cvmail@btamail.net.cn. Include complete address/addresses and/or domain to be removed. We will immediately update it accordingly. We apologize for the inconvenience if any caused.

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

Date: Fri, 22 Feb 2002 14:49:44 +0000 From: Jen=?iso-8859-1?Q?s=AE?= <Jens=?iso-8859-1?Q?M?=@T-ONLINE.DE> Subject: Re: MVS Question

> If you are running on Jes3, there are parameters you can add to your main > statement that can specifiy a release time.... > > //*MAIN ORG=CNTR2,CLASS=TSO21,RLSETIME=(07:00)

Humm...this is standard JES3??

Jens

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

Date: Fri, 22 Feb 2002 14:48:18 +0000 From: Jens Schlatter <JensM@T-ONLINE.DE> Subject: Re: Consultant for data transporting

Thu, 21 Feb 2002 20:45:27 UTC roni_richards@yahoo.com wrote:

> > Anybody care to lend a hand on some data porting between various unix and > PC platforms? Let me know which unix variants and types of data you've > waded through. Thanks.

HPUX, Solaris, Linux, MVS, PC and 14 years of SAS. Where are you?

Jens Schlatter

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

Date: Fri, 22 Feb 2002 06:47:20 -0800 From: Stig Eide <stigeide@YAHOO.COM> Subject: Re: Automate Files Import by using SAS statement

You might be interested in concatinaded filerefs and wildcards: From OnlineDoc: The * and ? wildcards can be used in either the external file name or file extension for matching input file names. Use * to match one or more characters and the ? to match a single character. Wildcards are supported for input only in the FILENAME and INFILE statements, and in member name syntax (aggregate syntax). Wildcards are not valid in the FILE statement. The following filename statement reads input from every file in the current directory that begins with the string wild and ends with .dat:

filename wild 'wild*.dat'; data; infile wild; input; run; The following example reads all files in the current working directory: filename allfiles '*.*'; data; infile allfiles; input run;

Hope this helps, Stig Eide siapaini@iname.com (siapaini) wrote in message news:<4473172f.0202212153.391514e6@posting.google.com>...

<snip>

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

Date: Fri, 22 Feb 2002 15:50:00 +0100 From: Armin Gemperli <Armin.Gemperli@UNIBAS.CH> Subject: Re: GeneralizedLinearMixedModels (had no Subject)

Elcin YENIDUNYA wrote: > > Dear Users, > > I would like compare the estimates of ML, Bayes and Generlized Linear Mixed > Models in Mixed Logit for brand choice problem. Is there any way to get > estimates of Generlized Linear Mixed Models with SAS?

Dear Elcin,

Use the %GLIMMIX macro which you can get from http://www.sas.com/service/techsup/faq/stat_macro/glimacr.html or use PROC NLMIXED. The first uses so-called maximum pseudo likelihood which is an approximation to the marginal likelihood well known to produce biased results (e.g. Breslow and Lin, Biometrika 1995), whereas in my experience the latter easily reaches workspace limits when using numerical integration techniques or the simulation based method via importance sampling. A third choice is to use GEE (REPEATED Statement) in Proc Genmod, which handles the covariance parameters as nuisance parameters only. The choice you do is completely dependent on your problem and how the SAS solution's capacity is to let you formulate your problem. I am a bit confuse about your first sentence: ML and Bayes are distinct ways to estimate your parameters, whereas Generalized Linear Mixed Models describe a class of models which can be estimated either using Maximum-Likelihood or Bayesian solutions? The three presented Procs/Macro all use Maximum-Likelihood methods. There is a possibility to do a Bayesian analysis with the %GLIMMIX macro using the PRIOR statement, but this currently is supported only for variance component models.

Good Luck. Armin

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

Date: Fri, 22 Feb 2002 15:49:57 +0100 From: Anthony Guillouzo <aguillouzo@BUSINESSDECISION.COM> Subject: Re: Table+Graph on one screen.

Hello Vladimir,

If you put a Multidimensional report and a Multidimensional graph objects in an Application screen builder, you will have the result you need.

You just have one thing to respect : the Multidimensional report and the Multidimensional graph objects have to use the same EIS/OLAP data source.

Cheers, Anthony. ----- Original Message ----- From: "Vladimir" <vladimip@YAHOO.COM> Newsgroups: bit.listserv.sas-l To: <SAS-L@LISTSERV.UGA.EDU> Sent: Friday, February 22, 2002 8:27 AM Subject: Table+Graph on one screen.

> Hello! > > Is it possible to view a table and a chart that was built in EIS/OLAP > at the same time? If yes, is it possible to use drilling (expand) of > table and to see changes in graph simultaneously. > > Thank you in advance. > Vladimir

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

End of SAS-L Digest - 22 Feb 2002 - Special issue (#2002-144) *************************************************************


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