f



Re: A sas program can't e-mail its own log, can it? #6

Thanks so much for the helpful response.

So should I be using FORWARD stepwise selection to choose from the
probability space of possible log files to e-mail, or BACKWARDS stepwise
selection?  I can never remember which one is statistically valid...

;-D

-----Original Message-----
From: Sigurd Hermansen [mailto:HERMANS1@WESTAT.com]
Sent: Friday, November 18, 2005 4:03 PM
To: Pardee, Roy; SAS-L@LISTSERV.UGA.EDU
Subject: RE: A sas program can't e-mail its own log, can it?



You have a nested sample of a population of possible logs from different
samples of data. You should, of course, use PROC SURVEYSELECT to copy it
and forward it via e-mail; otherwise, ERROR message variance estimates
may be biased (A REALLY BAD THING).

PROC SURVEYSELECT generates replicates. That makes it ideal for copying
a sample of, say, a log. For example,

data test;
  x=y;
run;
proc printto log=log;
run;
quit;
filename l "c:\TEMP\test.log";
filename out email "pardee.r@ghc.org";
data l;
   infile l;
   input log $char1. @@;
run;
proc surveyselect data=l out=email samprate=100 rep=1;
run ;
data _null_;
set email;
   file out
     to=("pardee.r@ghc.org")
     subject="SAS File"
     attach = ("c:\TEMP\test.log")
     ;
run ;

In conclusion, one cannot use PROC SURVEYSELECT too often. After seeing
what one line of PROC SURVEYSELECT can do, imagine what three lines of
PROC SURVEYSELECT can do! Don't try that at home!

It takes a bit more effort to make full use of PROC SURVEYSELECT, but
doing so guarantees that you will make David C. happy. I recommend it
for every programming chore.

Don't thank me for this helpful answer. All the credit goes to David.
Your friend, Mike Raithel

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Pardee, Roy
Sent: Friday, November 18, 2005 1:47 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: A sas program can't e-mail its own log, can it?


Hey All,

When I run the below code, my attempt at having sas e-mail me the log
file gives me this:

   ERROR: Error opening attachment file \\home\pardre1\deleteme.log.
   ERROR: File is in use, \\home\pardre1\deleteme.log.

There's no trick for avoiding this, is there?

Thanks!

-Roy

Here's the code--the program is \\home\pardre1\deleteme.sas

data gnu ;
   do i = 1 to 1000 ;
      r = uniform(1234) ;
      output ;
   end ;
run ;

proc univariate data = gnu ;
   var r ;
run ;

filename out email "pardee.r@ghc.org";
data _null_;
   file out
     to=("pardee.r@ghc.org")
     subject="SAS File"
     attach = ("\\home\pardre1\deleteme.log")
     ;
run ;
0
pardee.r (1272)
11/19/2005 12:06:56 AM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
613 Views

Similar Articles

[PageSpeed] 40

Reply:

Similar Artilces:

Re: A sas program can't e-mail its own log, can it?
On Fri, 18 Nov 2005, Pardee, Roy wrote: > When I run the below code, my attempt at having sas e-mail me the log > file gives me this: > > ERROR: Error opening attachment file \\home\pardre1\deleteme.log. > ERROR: File is in use, \\home\pardre1\deleteme.log. > > There's no trick for avoiding this, is there? > > Thanks! > > -Roy > > Here's the code--the program is \\home\pardre1\deleteme.sas > > data gnu ; > do i = 1 to 1000 ; > r = uniform(1234) ; > output ; > end ; > run ; > > proc univariate dat...

Thanks! (was Re: A sas program can't e-mail its own log, can it?)
Thanks to everyone who responded--I will indeed look into proc printto. Thanks! -Roy -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Peter Crawford Sent: Friday, November 18, 2005 11:02 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: A sas program can't e-mail its own log, can it? On Fri, 18 Nov 2005 10:46:54 -0800, Pardee, Roy <pardee.r@GHC.ORG> wrote: >Hey All, > >When I run the below code, my attempt at having sas e-mail me the log >file gives me this: > > ERROR: Error opening attachment file \\home\pardre1\delet...

A sas program can't e-mail its own log, can it?
Hey All, When I run the below code, my attempt at having sas e-mail me the log file gives me this: ERROR: Error opening attachment file \\home\pardre1\deleteme.log. ERROR: File is in use, \\home\pardre1\deleteme.log. There's no trick for avoiding this, is there? Thanks! -Roy Here's the code--the program is \\home\pardre1\deleteme.sas data gnu ; do i = 1 to 1000 ; r = uniform(1234) ; output ; end ; run ; proc univariate data = gnu ; var r ; run ; filename out email "pardee.r@ghc.org"; data _null_; file out to=("pardee.r@ghc.org&...

Re: Can I e-mail from SAS program? #5
Is it possible to use the smtp method described here with a username and password option? I got a starttls error Rgds On Tue, 6 Jan 2009 11:53:00 -0500, Mike Zdeb <msz03@ALBANY.EDU> wrote: >hi ... take a look at ... Usage Note 19767: How to send SMTP email with SAS > >http://support.sas.com/kb/19/767.html > >-- >Mike Zdeb >U@Albany School of Public Health >One University Place >Rensselaer, New York 12144-3456 >P/518-402-6479 F/630-604-1475 > >> Thanks jack, >> Yes, I do not want to use Outlook at all. >> It would be very unconfortable to use hotmail or other web e-mail >> accounts. >> Is there any basic setup for SMTP? What Do I need to setup SMTP? I only >> wants to e-mail programtically. >> >> ...

Re: Can I e-mail from SAS program? #4
Mike, I tried that one but got following error. ERROR: Bad email address: xxxx@xxx.com WARNING: Email: 554.5.5.1 Error: no valid recipients. I did entered correct port number. Are you familier with this error? ...

Re: Can I e-mail from SAS program? #3
hi ... take a look at ... Usage Note 19767: How to send SMTP email with SAS http://support.sas.com/kb/19/767.html -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > Thanks jack, > Yes, I do not want to use Outlook at all. > It would be very unconfortable to use hotmail or other web e-mail > accounts. > Is there any basic setup for SMTP? What Do I need to setup SMTP? I only > wants to e-mail programtically. > > ...

Re: Can I e-mail from SAS program? #2
Thanks jack, Yes, I do not want to use Outlook at all. It would be very unconfortable to use hotmail or other web e-mail accounts. Is there any basic setup for SMTP? What Do I need to setup SMTP? I only wants to e-mail programtically. ...

Re: Can a SAS program call another SAS program
> From: David Fickbohm > I am writing a report that counts the number of widgets produced by > partners. I have a small routine that finds the partners id > number and > name. Obviously I could copy this code into my program and > execute it. I was wondering if there was a more elegant way > of "Calling" a SAS program > from within a SAS program. > I am running SAS 8.1 in windows. still!?!? surely that is a typo: 9.1? i.e.: -The- 9.1==9.1.3 include it: - - - subRoutineX.sas - - - *...; - - - subRoutineX.sas end - - - - - - autoexec.sas - - - filen...

Re: Can a SAS program call another SAS program #2
Dave, What you want to do can be done with %include. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com David Fickbohm <DavidF@HOMEGAIN.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 10/15/2004 04:05 PM Please respond to David Fickbohm To: SAS-L@LISTSERV.UGA.EDU cc: Subject: Can a SAS program call another SAS program People, I am writing a report that counts the number of widgets produced by partners. I have a small routine that finds the partners id number and name. Obviously I could copy this code into my...

Re: Can a SAS program call another SAS program #3
Dear SAS-L-ers, David Fickbohm posted the following: > I am writing a report that counts the number of widgets produced by > partners. I have a small routine that finds the partners id > number and > name. Obviously I could copy this code into my program and > execute it. I was wondering if there was a more elegant way > of "Calling" a SAS program > from within a SAS program. I am running SAS 8.1 in windows. > David, there sure is a more elegant way; and a simple one at that! Simply use the %INCLUDE statement. The %INCLUDE statement allows you to in...

Re: Why I can't export the SAS talbe into Excel file? #6
Excel 2007 is a massive overhaul of Excel. For anyone who can afford it (or convince IT), seriously consider upgrading to this new version. It is well worth every penny. Not only are the limits removed but the graphics are stunning, significant BI capability, smaller file sizes, and on and on. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Gerhard Hellriegel Sent: Tuesday, January 29, 2008 10:17 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Why I can't export the SAS talbe into Excel file? Thanks Alan! Good to know! My current version is 2003. I'm not sure but I think I remember a 32768 (32K) record limit of one of the elder versions... Gerhard On Tue, 29 Jan 2008 10:02:41 -0700, Alan Churchill <savian001@GMAIL.COM> wrote: >FYI, Excel 2007 does not have these limits. 65K columns, 1M rows. > >Alan > >Alan Churchill >Savian >www.savian.net > > > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Gerhard >Hellriegel >Sent: Tuesday, January 29, 2008 9:59 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: Why I can't export the SAS talbe into Excel file? > >seems to me that EXCEL uses chars and double-chars for the columns. That >are 25*25 doubles and 25 single names for columns. That means 650 possible >columns. If you have 659 vars, you have too much for EXCEL. ...

Can I e-mail from SAS program?
We have outlook express installed on SAS Windows server and when I setup my account on outlook express, I was able to send e-mails but I dont want to use my personal account for SAS e-mails. Is there any other way to send e-mail attachement from SAS? or is it possible to send e-mail from SAS without setting up e-mail accountin outlook express? Do you want to use Outlook but not your email account, or do you not want to use Outlook at all? If you have access to an SMTP server (either in your company or from an external provider like Yahoo or Fastmail), you can use that instead of the local mail agent. From <http://support.sas.com/onlinedoc/913/getDoc/en/hostwin.hlp/win-sysop-emailsys.htm>: "SAS supports three types of electronic mail interfaces: MAPI (such as Microsoft Exchange), Vendor Independent Mail (VIM--such as Lotus, cc:Mail) and SMTP. The default value is MAPI. If you specify SMTP, you must also specify and configure the EMAILHOST and EMAILPORT system options. SMTP is available only when you are sending e-mail programatically. SMTP is not available using either your e-mail program native dialog box or the SAS e-mail dialog box." For information on the emailhost and emailport options, see <http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000309878.htm>. On Tue, 6 Jan 2009 11:09:08 -0500, "Abc Unha" <abcunha@YAHOO.COM> said: > We have outlook express installed on SAS Windows server and when I setup > my accou...

Maple9 Can't run, can't re-install
-I installed the maple-9 on laptop without any problem. But when I run it, nothing happens. -I tried to uninstall it with start->settings->control panel->add/remove program->maple9, the "add/remove program" freeze (for long--------). All other programs still work at that time (computer is not froozen). -I tried to shut down the computer, it needs to 'end' the 'un-installation' -I tried to re-install the maple9 from the original CD, nothing happens. -With 'autorun', it runs a few seconds and nothing happens. -Tried to installed it ...

Can't send e-mail but I can d/l it
I use Peg v. 4.12a (Win32), 6/19/03 and suddenly I can't send e-mail. I haven't changed any settings and have dbl ck'd the ones for SMTP and everything seems to jive w/ what my ISP (sonic.net) says they should be. The error msg is titled "TCP/IP timeout!" and it says: "Pegasus Mail has timed out while waiting for a response from the remote host. Socket timeouts like this can be caused by network congestion, slow responses from the remote host or by network problems which cause loss of data." I went and changed the default timeout for network conne...

config.sys corrupted; can't fix; can't start windows 2000
The computer attempts to open windows 2000 pro and gets hung up with the message that winn config.sus is corrupted. I tried booting from the win 2000 cd-rom and then creating floppy boot disks. The computer won't recognize or run off of these. Rename the Config.sys file in the root directly to ConfigOLD.sys. See if the machine will boot without it for now. Any release of NT should be able to. If you work out for sure that the Config.sys file is faulty, you can go in with your text editor, and troubleshoot it. You will need the base knowledge to work in this file. Jerry G. ======== ...

Can't log in (can't type) on console on Solaris 10 on Ultra 10
Hello, I've installed Solaris 10 on an Ultra 10. Unfortunately I cannot log in on console and I'm looking for some advice. I can log in over the net. I installed the machine using console so I know that works fine. After booting up, I can not type anything on console, though console messages, e.g. su, are printed on the screen. The only error message is "Console login service(s) cannot run". I've googled a lot on this and found only one really relevent item here: http://blog.sun.com/roller/page/lianep/Weblog/20050204. svcs states the service is not running (as if I didn't know): # svcs -x svc:/system/console-login:default (Console login) State: offline since Thu Feb 24 15:05:08 2005 Reason: Unknown. See: http://sun.com/msg/SMF-8000-AR See: ttymon(1M) Impact: This service is not running. http://sun.com/msg/SMF-8000-AR has a meaningless explanation and no fix. I've tried restarting the service without any good effect: # svcadm -v enable svc:/system/console-login svc:/system/console-login:default enabled. I've enabled "milestone all". A reboot doesn't fix it. I can't see any dependencies that are not running: # svcs -d svc:/system/console-login STATE STIME FMRI online 14:56:20 svc:/system/identity:node online 14:56:21 svc:/system/filesystem/minimal:default online 14:56:27 svc:/milestone/sysconfig:default online 14:56:28 svc:/system/utmp:default Does anyon...

Can't save existing SAS programs
Hi, I have strange issue. Somehow I can't save my current SAS programs. I open it from SAS Display Manager but could not save changes that I made. After doing some googling it was suggested that rename or delete following files regstry.sas7bitm profile.sas7bcat But I can't even delete or rename these files because I get an error stating: "cannot delete regstry: it is being used by another person or program" I have closed all SAS programs but still getting that error. This is totally strange as I can't make any changes to any of SAS programs. even using N...

Re: Why I can't do searching on SAS OnlineDoc using IE?
Are you fully updated? I just tried that and it works for me. The help included with your copy of SAS is also nice - note that you must have all hotfixes applied. -----Original Message----- From: Frank Duan [mailto:df73@OMEGA.MED.YALE.EDU] Sent: Friday, August 06, 2004 2:22 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Why I can't do searching on SAS OnlineDoc using IE? Dear SAS-L people, I am new to this board and I failed to find the answer after browsing the archives. My question is: When I try to search SAS OnlineDoc by keywords using Internet Explorer, I always get the error message "Java.lang.NullpointerException" and "no matches found" results (even I typed "proc reg"). Does anybody know what that error means and how to fix it? By the way, I have no problem doing searching with Netscape. Thanks a lot, Frank ...

Re: what system options can you use to debug a SAS program #6
On Wed, Apr 16, 2008 at 4:31 PM, Ian Whitlock <iw1junk@comcast.net> wrote: > I intentionally haven't shown the code for the macro. What's the harm? Does this look a little bit like %let? Back in the day, named them beginning with an underscore to help me identify them more easily. macro xxx 1% > If you don't know it, you shouldn't play with it. I reckon we could say the same thing about the "modern" macro language. Or just look for regular SAS language solution. You will be much happier at the end of the day. ...

Re: Why I can't export the SAS talbe into Excel file?
Guessing, I would say the number of variables in MELODY.TOTAL1 is greater that the number of columns allowed in an EXCEL spread sheet. How many variables do you have? On Jan 28, 2008 3:14 PM, Melodyp <pearsonmelody@gmail.com> wrote: > Hello everyone, I used the code below to export a SAS table to excel > file, but keep getting the same errors, could anyone of you to let me > know what I did wrong? > proc export data=melody.total1 > outfile='V:\project\total1.xls' > dbms=excel > replace; > run; > > here is the log file: > > 96 proc export data=melody.total1 (obs=10) > 97 outfile='V:\project\total1.xls' > 98 dbms=excel > 99 replace; > 100 run; > > ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Too > many fields defined.. > WARNING: File deletion failed for _IMEX_.TOTAL1.DATA. > ERROR: Export unsuccessful. See SAS Log for details. > NOTE: The SAS System stopped processing this step because of errors. > NOTE: PROCEDURE EXPORT used (Total process time): > real time 3.81 seconds > cpu time 0.23 seconds > On 28 jan, 22:37, datan...@GMAIL.COM ("data _null_,") wrote: > Guessing, I would say the number of variables in MELODY.TOTAL1 is > greater that the number of columns allowed in an EXCEL spread sheet. > How many variables do you have? > > On Jan 28, 2008 3:14 PM, Melodyp <pearsonmel....

Can't make Eudora Default E-mail Program
I have installed a new W7 Ultimate64-bit, and installed Eudora v7.1.0.9 first. I had to select 'run as administrator' to get it to go at all, but now it says: There is no e-mail program associated to perform the requested action. Please install an e-mail program, or, if one is already installed, create an association in the default programs control panel. Well, I already have Eudora installed. And further when I went to stated control panel, Eudora was NOT listed. So naturally I could not select it as default. Great. Now what? Thanks in advance Big Fred On...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #6
I interviewed at a company that gave a test where I had a half hour to produce a very simple report using PROC REPORT. I was provided all the manuals I wanted, but because I had used PROC REPORT before, I wanted none of them. I finished in five minutes, and most people on SAS-L would be able to beat that time. Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com "toby dunn" <tobydunn@HOTMAIL.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 09/04/2007 05:15 PM Please respond to "toby dunn" <tobydunn@HOTMAIL.COM> To SAS-L@LISTSERV.UGA.EDU cc Subject Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspective and you can make your choice from there. Toby Dunn Comprimise is like telling a lie, it gets easier and easier. Each comprimise you make, that becomes your standard. Perfection doesnt exist, once...

Re: Why I can't export the SAS talbe into Excel file? #3
My free Notebook can open any SAS dataset directly into MS Excel as a native *.xls spreadsheet. You don't need to write any PROC EXPORT code! Do NOT open it by double-clicking on the file icon from the File Explorer. Instead, click on the Data Editor tab and click on the 'Open Data File' toolbar item. Browse to the location of your SAS dataset file, select it, and click 'Open'. A dialog will appear asking you how you would like to open the data file. Select "Open in Excel as a native spreadsheet (*.xls)'. Get it free here: http://sas2themax.com/free or here: http://sas2themax.com/free/mxnotebook.zip Regards, Audi ----- Original Message ----- From: "Nat Wooding" <Nathaniel.Wooding@DOM.COM> To: <SAS-L@LISTSERV.UGA.EDU> Sent: Tuesday, January 29, 2008 9:06 AM Subject: Re: Why I can't export the SAS talbe into Excel file? > I, too, have received this message but have never quite figured out the > cause. In the last instance, I was replacing a spread sheet; there were no > more than a few thousand lines; and, I had about 20 columns. > > As I recall, I deleted the workbook and the problem went away. It may well > be that I was trying to add a new column and this was not allowed when > rewriting the spreadsheet. > > Nat Wooding > Environmental Specialist III > Dominion, Environmental Biology > 4111 Castlewood Rd > Richmond, VA 23234 > Phone:804-271-5313, Fax: 804-271-2977 > >...

Re: Why I can't export the SAS talbe into Excel file? #5
Thanks Alan! Good to know! My current version is 2003. I'm not sure but I think I remember a 32768 (32K) record limit of one of the elder versions... Gerhard On Tue, 29 Jan 2008 10:02:41 -0700, Alan Churchill <savian001@GMAIL.COM> wrote: >FYI, Excel 2007 does not have these limits. 65K columns, 1M rows. > >Alan > >Alan Churchill >Savian >www.savian.net > > > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Gerhard >Hellriegel >Sent: Tuesday, January 29, 2008 9:59 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: Why I can't export the SAS talbe into Excel file? > >seems to me that EXCEL uses chars and double-chars for the columns. That >are 25*25 doubles and 25 single names for columns. That means 650 possible >columns. If you have 659 vars, you have too much for EXCEL. Records are >also limited, I think to a power of 2, in decimal 65536. So the 10008 (?) >should fit in. > >Gerhard > > > >On Tue, 29 Jan 2008 08:45:03 -0800, Melodyp <pearsonmelody@GMAIL.COM> >wrote: > >>On Jan 29, 10:36 am, a...@SAS2THEMAX.COM ("Audimar P. Bangi") wrote: >>> My free Notebook can open any SAS dataset directly into MS Excel as a >native >>> *.xls spreadsheet. You don't need to write any PROC EXPORT code! Do NOT >open >>> it by double-clicking on the file icon from the File Explorer. I...

Web resources about - Re: A sas program can't e-mail its own log, can it? #6 - comp.soft-sys.sas

Resources last updated: 3/18/2016 4:50:05 PM