Date: Thu, 27 Jul 2000 14:52:29 -0400
Reply-To: "Hudson, Spencer" <shudson@VIROPHARMA.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Hudson, Spencer" <shudson@VIROPHARMA.COM>
Subject: Re: macro help
Content-Type: text/plain; charset="iso-8859-1"
Pat,
Try the following macro %setblnk. I couldn't think of anyway to do it
without a interim data step. Maybe one of the gurus can get rid of _TEMP_.
Spencer.
%macro setblnk(indata, outdata, keep);
data _TEMP_;
set &indata;
stop;
run;
data &outdata;
set &indata(keep = &keep) _TEMP_;
run;
proc datasets library=work nolist;
delete _TEMP_ / memtype = data;
quit;
run;
%mend;
> -----Original Message-----
> From: Pat Rudolph [SMTP:rudolph@ADVBIOL.COM]
> Sent: Wednesday, July 26, 2000 12:08 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: macro help
>
> Does anyone know of a macro way to replace a string with blanks for all
> of the variables in a dataset - with exceptions. I want to be able to
> specify the exceptions -
>
> So if I had a dataset TEST
> PATIENT
> DATE
> LAB
> VISIT
>
> and wanted to replace the contents of visit , date and lab with blanks
> but leave PATIENT.
>
> Thanks!
>
> pat rudolph
> -----Original Message-----
> From: Pat Rudolph [SMTP:rudolph@ADVBIOL.COM]
> Sent: Wednesday, July 26, 2000 12:08 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: macro help
>
> Does anyone know of a macro way to replace a string with blanks for all
> of the variables in a dataset - with exceptions. I want to be able to
> specify the exceptions -
>
> So if I had a dataset TEST
> PATIENT
> DATE
> LAB
> VISIT
>
> and wanted to replace the contents of visit , date and lab with blanks
> but leave PATIENT.
>
> Thanks!
>
> pat rudolph
____________________________________________________________________________
__________
Spencer Hudson, Ph.D.
Director, Biostatistics and Clinical Data Management
ViroPharma Incorporated
405 Eagleview Boulevard
Exton, PA 19341
Telephone: (610) 458 7300 extension 154
FAX: (610) 458 7380
Electronic Mail: shudson@viropharma.com
Web: www.viropharma.com
CONFIDENTIALITY NOTICE: This e-mail transmission contains 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 VIROPHARMA INCORPORATED can
arrange for
proper delivery, and then please delete the message from your inbox. Thank
you.
-----Original Message-----
From: Automatic digest processor [mailto:LISTSERV@LISTSERV.UGA.EDU]
Sent: Thursday, July 27, 2000 2:29 PM
To: Recipients of SAS-L digests
Subject: SAS-L Digest - 27 Jul 2000 - Special issue (#2000-732)
There are 20 messages totalling 1071 lines in this issue.
Topics in this special issue:
1. job posting data management SAS programmer
2. Parse 1 string into numerics? (2)
3. Job opening: Contract in VA
4. running SAS V8 from Ultraedit (3)
5. More on SAS V8.1 TS1M0 (3)
6. <No subject given>
7. Reverse Question of, Parse 1 string into numerics?
8. macro help
9. V8.1 err msg: font MIA (2)
10. PC Binary Signed data
11. fsd on unix
12. How To Create Range Table (2)
13. Reverse Question of, Parse 1 string
----------------------------------------------------------------------
Date: Thu, 27 Jul 2000 15:03:41 GMT
From: Esther Kwan <ekwan@CRL.BE>
Subject: job posting data management SAS programmer
Dear fellow SAS programmers,
I am Esther, a former resident and SAS programmer of San Francisco. Now
I work as a Senior Data Manager in a Central Laboratory for Clinical
Trials in Brussels, Belgium. Our company is growing and I need another
SAS programmer to help me with my work.
The job descriptions are:
* Set up/program Clinical Trial Protocols in our customized SAS/AF
Laboratory Information System, using SAS/BASE and SAS/SCL.
* Monitor study data and follow-up on data consistency.
* Assist users with advanced data queries.
* Write programs for study specific data reports, etc.
If you have the following attributes:
** Attention to detail.
** Organized.
** Able to work on multiple tasks simultaneously.
** Enjoy working with people.
** Have 2 or more years of work experience in SAS/BASE, SAS/SCL, etc.
** Have data management work history, have programmed for large amounts
of data.
** Familiar with Clinical Trials, or have strong interests in clinical
research data.
** Have flexible hours.
And if you are interested in this position please send me your CV.
Thanks,
Esther Kwan
Senior Data Manager
CRL Europe
Excelsiorlaan 39,
1930 Zaventem,
Belgium
fax: 32-02-725-2102
email: ekwan@crl.be
------------------------------
Date: Thu, 27 Jul 2000 08:16:52 -0700
From: "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Subject: Re: Parse 1 string into numerics?
Hi Adam,
This can be several ways, here is just one.
The SUBSTR() function can chop each out each
character from the string, and the INPUT() converts
the character to numeric. Conversely, PUT() converts
numeric back to character (just for FYI).
data _null_;
array x{100};
s = '121212';
do i=1 to length(s);
x{i} = input(substr(s,i,1),1.);
end;
put x1=;
put x2=;
put x3=;
put x4=;
put x5=;
put x6=;
put _all_;
run;
Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
(360) 902-0741
(360) 902-0705 fax
mailto:terjemw@dshs.wa.gov
> -----Original Message-----
> From: sundor96@ASSETS.WHARTON.UPENN.EDU
> [SMTP:sundor96@ASSETS.WHARTON.UPENN.EDU]
> Sent: Thursday, July 27, 2000 6:12 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Parse 1 string into numerics?
>
> How to parse a string variable, like: "121212"
>
> so it becomes 6 separate numeric variables of 1 2 1 2 1 2?
>
>
> Will be used on SAS 6.10 Windows or maybe SAS 6.12 Unix.
>
> Thanks, Adam Sundor.
------------------------------
Date: Thu, 27 Jul 2000 11:12:54 -0400
From: Bennie Fiol <fiolb@WHITEOAKSEMI.COM>
Subject: Job opening: Contract in VA
SAS Programmer opening(6-12 month contract) at WhiteOak Semiconductor in
Richmond, VA.
Needed: SAS programming with version 6.xx screen control language (SCL) -
if not current, significant development experience in SCL;
Helpful = experience with UNIX environment with ability to maintain shell
script programs.
Submit your resume via e-mail to fiolb@whiteoaksemi.com or
fax to (804) 952-7522 - Attention: Bennie Fiol
To find out more about WhiteOak Semiconductor go to:
http://www.whiteoaksemi.com
------------------------------
Date: Thu, 27 Jul 2000 15:28:17 GMT
From: John Iwaniszek <jiwaniszek@NC.RR.COM>
Subject: running SAS V8 from Ultraedit
Has anyone hit on the magic words for setting up and Ultaedit tool to
run V8 from the button bar? I had it set up for v612 and the button
worked fine.
As my command line I now have : D:\sasv8\Sas.exe %f -nologo -config -set
jobpath
%f is the ultraedit variable that contains the full path to and name of
the sas program.
JOBPATH is an environment variable the will contain the full path to and
name of the sas program that will later get placed in a macro variable.
sasv8cfg is in the directory containing the sas program and I am
assuming SAS looks there first for configuration (This assumption is
probably what is killing me).
Thanks for any help.
--
John Iwaniszek
Statistical Programming Manager
Stat-Tech Services, LLC
919 571 6444
Developers of the Macro Reporting System - Delivering
Statistical reports in ASCII, RTF, and HTML
http://www.StatTechServices.com
------------------------------
Date: Thu, 27 Jul 2000 15:34:15 GMT
From: "John M. Wildenthal" <jmwildenthal@MY-DEJA.COM>
Subject: Re: More on SAS V8.1 TS1M0
In article <62AAE2DBEFD3D211841A0008C7456801BAE1EE@EXCHANGE>,
Jack Shoemaker <JShoemaker@ACCORDANT.NET> wrote:
> Dear SAS-L,
>
> Never trust the odd-numbered releases. I thought I had learned
> this lesson already. Remember 6.03, 6.07, 6.09, 6.11 and 7.0? Would
> you rather run those versions of SAS, or 6.04, 6.06, 6.08, 6.12, and
> 8.0?
>
> Add 8.1 to that esteemed list.
>
> SAS/ACCESS for PC file formats either is broken, or has changed
> radically with V8.1. I have production jobs involving PROC IMPORT
> and PROC EXPORT which are failing all over the place. If you use
> this component of SAS, I'd suggest that you not to upgrade at this
> time.
But don't forget that v8.0 for Windows can leak memory when using
iterative DO loops. We ran out of memory on a production server with
1.25gig physical ram and a 4gig swap file in less than 75 total inner
iterations (nested loops really leak memory).
Sent via Deja.com http://www.deja.com/
Before you buy.
------------------------------
Date: Thu, 27 Jul 2000 12:12:07 -0400
From: John Hixon <125241N@KNOTES.KODAK.COM>
Subject: <No subject given>
From: John Hixon
David,
Something looks fishy to me in your indexing through the X matrix,
but, assuming there are no errors there, all you need to do is
change two lines to get your output...
Change FROM:
create final from X[colname='dataset quantile inter Xcoe'];
append;
Change TO:
create final from X[colname={'dataset' 'quantile' 'inter' 'Xcoe'}];
append from X;
HTH,
John Hixon
john.hixon@kodak.com
Eastman Kodak Company
Rochester, NY, USA
716-726-1229
Original post below:
-----------------------------
Date: Thu, 27 Jul 2000 10:47:16 EDT
From: David Wright <david_20000@HOTMAIL.COM>
Subject: Maxtrix/Dataset tranformation and data Correction
Hi, sasers,
I am trying to correct some data in one big dataset. They are the first 231
observation of each dataset. What I have done are as followed: 1) tranfer
SAMPLE into a matrix X; 2) correct the data in X; 3) tranfer X back to
dataset Final; 4) save the Final into file in the harddisk. Now the
problems
lie at CREATE and APPEND. The hints of LOG is 'WARNING: All data set
variables are unvalued. No APPEND done.' Who can tell me why?
By the way, can any one give some advice to correct the data not by MATRIX?
I guess it needs more skills.
Thanks in advance,
David
+++++++++++++++++++++
data sample;
infile "c:\sas\swat_low.txt";
input dataset quantile Inter Xcoe;
run;
proc iml;
use sample var{dataset quantile inter Xcoe};
read all var _num_ into X;
do j=0 to 99;
do i=1 to 231;
qpart=X[i+j*440,2];
qpart=1-qpart;
X[i+j*440,2]=qpart;
end;
end;
create final from X[colname='dataset quantile inter Xcoe'];
append;
show datasets;
show contents;
data _null_;
set final;
file "c:\sas\swat_low_correct.txt";
put dataset quantile Inter Xcoe;
run;
------------------------------
Date: Thu, 27 Jul 2000 16:18:58 GMT
From: Dale McLerran <dmclerra@FHCRC.ORG>
Subject: Re: Reverse Question of, Parse 1 string into numerics?
Mark,
One straightforward approach would be:
var13 = input(var10 || var3, 13.);
Now, there may be some question whether var10 will always be filled
out to the end of the string (have nonblank 10th character) and
whether var3 will always be filled to the start of the string (have
nonblank first character). If these situations could be encountered,
then you would have to do something like
var13 = input(compress(var10 || var3), 13.);
Dale
--------------------------------------
Dale McLerran
Fred Hutchinson Cancer Research Center
Seattle, WA 98109
mailto:dmclerra@fhcrc.org
ph: (206) 667-2926
fax: (206) 667-5977
--------------------------------------
Mark.K.Moran@CCMAIL.CENSUS.GOV (Mark Moran) wrote in
<85256929.004DE1A7.00@it008nthqln.tco.census.gov>:
>I have the almost exact reverse question. What is the best,
>straightforward way in SAS 6.12 to string together a 10-digit variable
>VAR10 and a 3-digit variable VAR3 into
>a single 13-digit variable VAR13? For example,
>
> VAR10 VAR3 ==> VAR13
>____________ ______
>_______________
>0112030201 574 0112030201574
>2560493172 123 2560493172123
>
>Mark
>---------------------- Forwarded by Mark K Moran/CSD/HQ/BOC on
>07/27/2000 10:07 AM ---------------------------
------------------------------
Date: Thu, 27 Jul 2000 16:31:55 GMT
From: Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject: Re: Parse 1 string into numerics?
Adam,
You can substring, but usually it is more economical to do it by straight
computation recursively, e.g:
85 data _null_;
86 s = '654321';
87 array q n1-n6; array t(0:6) _temporary_;
88 t(0) = 10*input(s,6.);
89 do over q;
90 t(_i_) = int (t(_i_-1)*.1);
91 q = mod (t(_i_),10);
92 end;
93 put n1--n6;
94 run;
1 2 3 4 5 6
Kind regards,
======================
Paul M. Dorfman
Jacksonville, Fl
======================
>From: sundor96@ASSETS.WHARTON.UPENN.EDU
>Reply-To: sundor96@ASSETS.WHARTON.UPENN.EDU
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Parse 1 string into numerics?
>Date: Thu, 27 Jul 2000 13:12:24 GMT
>
>How to parse a string variable, like: "121212"
>
>so it becomes 6 separate numeric variables of 1 2 1 2 1 2?
>
>
>Will be used on SAS 6.10 Windows or maybe SAS 6.12 Unix.
>
>Thanks, Adam Sundor.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------
Date: Thu, 27 Jul 2000 09:40:12 -0700
From: "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Subject: Re: macro help
Hi Pat,
I just happen to do something real similar
a couple days ago, try this:
You can remove the debug lines if you wish.
You can also adjust the macro to not overwrite
the original file by making another argument for
an inname and an outname.
data test;
patient='111'; date='14jan99'd; lab='1'; visit=501; output;
patient='222'; date='15jan99'd; lab='1'; visit=502; output;
patient='333'; date='16jan99'd; lab='2'; visit=503; output;
patient='444'; date='17jan99'd; lab='2'; visit=504; output;
patient='555'; date='18jan99'd; lab='4'; visit=505; output;
run;
options mprint;
%macro blnksome(dsname,keepers);
%* need libref and dsname split for processing below ;
%local lbnam dsnam;
%if %index(&dsname,.) %then
%do;
%let lbnam=%substr(&dsname,1,%eval(%index(&dsname,.)-1));
%let
dsnam=%substr(&dsname,%eval(%index(&dsname,.)+1),%eval(%length(&dsname)-%ind
ex(&dsname,.)));
%end;
%else
%do;
%let lbnam=work;
%let dsnam=&dsname;
%end;
%put lbnam is >&lbnam<; %* debug ;
%put dsnam is >&dsnam<; %* debug ;
%* fetch the variable names to blank ;
proc sql noprint;
select distinct name,type into :name1-:name1000,:type1-:type1000
from sashelp.vcolumn
where upcase(libname) eq upcase("&lbnam")
and upcase(memname) eq upcase("&dsnam")
and index(upcase("&keepers"),compress(upcase(name))) eq 0
;
quit; %put count is >&sqlobs<; %* debug ;
%do _i = 1 %to &sqlobs; %* debug ;
%put &&name&_i &&type&_i; %* debug ;
%end; %* debug ;
%* blank desired variables in dataset ;
data &dsname;
set &dsname;
%do _i = 1 %to &sqlobs;
%if %upcase(%substr(&&type&_i,1,1)) eq N %then
%do;
&&name&_i = .;
%end;
%else
%do;
&&name&_i = '';
%end;
%end;
run;
%mend;
/*
%blnksome(test,patient date visit);
%blnksome(test,patient date);
*/
%blnksome(test,patient);
options nomprint;
Hope this is helpful,
Mark Terjeson
Washington State Department of Social and Health Services
Division of Research and Data Analysis (RDA)
(360) 902-0741
(360) 902-0705 fax
mailto:terjemw@dshs.wa.gov
> -----Original Message-----
> From: Pat Rudolph [SMTP:rudolph@ADVBIOL.COM]
> Sent: Wednesday, July 26, 2000 12:08 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: macro help
>
> Does anyone know of a macro way to replace a string with blanks for all
> of the variables in a dataset - with exceptions. I want to be able to
> specify the exceptions -
>
> So if I had a dataset TEST
> PATIENT
> DATE
> LAB
> VISIT
>
> and wanted to replace the contents of visit , date and lab with blanks
> but leave PATIENT.
>
> Thanks!
>
> pat rudolph
------------------------------
Date: Thu, 27 Jul 2000 12:43:23 -0400
From: "Fehd, Ronald J." <rjf2@CDC.GOV>
Subject: V8.1 err msg: font MIA
This qualifies as an intelligent error message:
"The SAS system could not get metrics for the font "SAS Monospace".
This failure is probably caused by the font being corrupted
or by Windows being low on virtual memory.
Possible solutions for the problem include:
1) double-clicking on the font in the Control Panel's fonts window,
2) rebooting the Windows system, or
3) uninstalling and reinstalling the SAS System."
Oh, did I mention this is the NEW AND IMPROVED V8.1 aka 8e?!
NOTE: SAS (r) Proprietary Software Release 8.1 (TS1M0)
option 1 didn't work
option 2 rebooting succeeding in eliminating this message
option 3: I don't _think_ so! PuuuuLease!*!
It took _me_ several hours to install V8.1.
that was coming off my site's intranet, some ten miles down the road.
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
archives: http://www.listserv.uga.edu/archives/sas-l.html
------------------------------
Date: Thu, 27 Jul 2000 16:54:40 GMT
From: Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject: Re: PC Binary Signed data
William,
First, ship the data from MF as is, i.e. in the binary form. On the PC side,
read them as S370FPDw.d (w and d being defined by the layout) and write the
result to a w-long character variable using IBw.d (use w=8 for maximum
precision). The string should contain what you need.
Kind regards,
=====================
Paul M. Dorfman
Jacksonville, FL
=====================
>From: William Gillin <Bill.Gillin@GECAPITAL.COM>
>Reply-To: Bill.Gillin@GECAPITAL.COM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: PC Binary Signed data
>Date: Wed, 26 Jul 2000 08:52:35 -0400
>
>I have an application that requires the data to be formatted as PC Binary
>Signed (also referred to as PCBS) . The mainframe data that I am using can
>be PD 2, PD 4, or PD 8. Would anyone know what format I need to use in SAS
>to convert this to PC Binary Signed?
>
>Thanks,
>
>Bill
>
> > William Gillin
> > Manager of Credit Scoring, IT
> > GE Capital - Commercial Equipment Finance
> > 44 Old Ridgebury Road, Danbury CT 06810
> > phone: (203) 790-2794 fax: (203) 790-2799 mobile: (203) 470-1874
> > email: bill.gillin@gecapital.com
> >
> >
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------
Date: Thu, 27 Jul 2000 10:03:55 -0700
From: kmself@IX.NETCOM.COM
Subject: Re: fsd on unix
--NMuMz9nt05w80d4+
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Wed, Jul 26, 2000 at 04:28:07AM -0700, karl wrote:
> Hi,
>=20
> When I use the 'sas -fsd ascii.vt100' command in Unix it
> seems impossible to increse the rows and columns. The sas
> screen remains very small. How do I configure sas for
> increased number of rows and columns in the termwindow.
IIRC, the character-mode FSD will fill the current terminal window. If
you size your terminal to the maximum size you want, *then* run SAS,
you'll get a larger display manager session.
Another alternative you may want to look at is the Emacs SAS mode.
--=20
Karsten M. Self <kmself@ix.netcom.com> http://www.netcom.com/~kmself
Evangelist, Opensales, Inc. http://www.opensales.org
What part of "Gestalt" don't you understand? Debian GNU/Linux rocks!
http://gestalt-system.sourceforge.net/ K5: http://www.kuro5hin.org
GPG fingerprint: F932 8B25 5FDD 2528 D595 DC61 3847 889F 55F2 B9B0
--NMuMz9nt05w80d4+
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE5gGt7OEeIn1XyubARAg3NAJwMoWTDGFfI86LoTbXdOzEnt6m5QwCeNWKU
hu5B8nvPkU8ZB+hcHq8nOSA=
=+Kd7
-----END PGP SIGNATURE-----
--NMuMz9nt05w80d4+--
------------------------------
Date: Thu, 27 Jul 2000 09:45:33 -0700
From: Anna Henson <anna_henson@YAHOO.COM>
Subject: How To Create Range Table
from SAS Dataset Mem.score
MEMID SCORE
995 15
996 78
997 17
998 20
999 72
1000 80
1001 60
1002 40
1003 55
1004 24
1005 35
1006 95
...... ... more
I WOULD LIKE TO CREATE A RANGE TABLE FROM THE DATA SET ABOVE.
MemCount ScoreRange
2 1-10
7 11-20
2 21-30
7 31-40
0 41-50
2 51-60
5 61-70
4 71-80
2 81-90
7 90-100
Note: MemCount= number of members fall into that ScoreRange.
Thank you for your helps.
Anna
------------------------------
Date: Thu, 27 Jul 2000 10:20:18 -0700
From: Thomas Kunselman <TKunselman@STAN.CSUSTAN.EDU>
Subject: Re: How To Create Range Table
I'd use a format.
I love formats.
proc format
value scrfmt 1-10 = '1-10'
11-20='11-20'
...
;
PROC FREQ data=mem.score;
table score;
format score scrfmt.;
run;
Sincerely,
Thom Kunselman
Message below deleted to allow posting:
"Anna Henson" <anna_henson@yahoo.com> wrote in message
news:so0qs5gl3j1114@corp.supernews.com...
------------------------------
Date: Thu, 27 Jul 2000 19:39:46 +0200
From: Lex Jansen <l.jansen@LEX-JANSEN.DEMON.NL>
Subject: Re: running SAS V8 from Ultraedit
John,
I have this:
command:
"C:\Program Files\SAS Institute\SAS\V8\SAS.EXE" "%f" -nosplash
working directory: %p
Anf I have check the tickbox 'Check if Windows program', otherwise it won't
work.
sasv8cfg is also in my directory containing the sas program.
and it's used which I can check because that's where my AUTOEXE.SAS is being
defined.
and it works!
so I'm not sure what goes wrong in your setup.
Maybe quotes around %f ??
Regards,
Lex Jansen
"John Iwaniszek" <jiwaniszek@nc.rr.com> wrote in message
news:398053C6.5B58F933@nc.rr.com...
> Has anyone hit on the magic words for setting up and Ultaedit tool to
> run V8 from the button bar? I had it set up for v612 and the button
> worked fine.
>
> As my command line I now have : D:\sasv8\Sas.exe %f -nologo -config -set
> jobpath
>
> %f is the ultraedit variable that contains the full path to and name of
> the sas program.
> JOBPATH is an environment variable the will contain the full path to and
> name of the sas program that will later get placed in a macro variable.
>
> sasv8cfg is in the directory containing the sas program and I am
> assuming SAS looks there first for configuration (This assumption is
> probably what is killing me).
>
> Thanks for any help.
>
> --
> John Iwaniszek
>
> Statistical Programming Manager
> Stat-Tech Services, LLC
>
> 919 571 6444
>
> Developers of the Macro Reporting System - Delivering
> Statistical reports in ASCII, RTF, and HTML
>
> http://www.StatTechServices.com
------------------------------
Date: Thu, 27 Jul 2000 17:50:40 GMT
From: Paul Dorfman <paul_dorfman@HOTMAIL.COM>
Subject: Re: More on SAS V8.1 TS1M0
John,
Would you be willing to post the malignant piece of code? It would be
interesting to know if it manifests on the real computer, too.
Kind regards,
===================
Paul M. Dorfman
Jacksonville, Fl
===================
>From: "John M. Wildenthal" <jmwildenthal@MY-DEJA.COM>
>But don't forget that v8.0 for Windows can leak memory when using
>iterative DO loops. We ran out of memory on a production server with
>1.25gig physical ram and a 4gig swap file in less than 75 total inner
>iterations (nested loops really leak memory).
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
------------------------------
Date: Thu, 27 Jul 2000 13:40:23 -0400
From: Jack Shoemaker <JShoemaker@ACCORDANT.NET>
Subject: Re: V8.1 err msg: font MIA
Ron,
I was so distracted by SAS/ACCESS for PC File Formats not working that I
forgot to mention this. As you write only option 2) works. I got a chuckle
out of 3) as well.
- Jack
--
Jack N Shoemaker / JShoemaker@Accordant.net
Visit our patient communities at http://www.accordant.com or our corporate
site http://www.accordant.net
-----Original Message-----
From: Fehd, Ronald J. [mailto:rjf2@CDC.GOV]
Sent: Thursday, July 27, 2000 12:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: V8.1 err msg: font MIA
This qualifies as an intelligent error message:
"The SAS system could not get metrics for the font "SAS Monospace".
This failure is probably caused by the font being corrupted
or by Windows being low on virtual memory.
Possible solutions for the problem include:
1) double-clicking on the font in the Control Panel's fonts window,
2) rebooting the Windows system, or
3) uninstalling and reinstalling the SAS System."
Oh, did I mention this is the NEW AND IMPROVED V8.1 aka 8e?!
NOTE: SAS (r) Proprietary Software Release 8.1 (TS1M0)
option 1 didn't work
option 2 rebooting succeeding in eliminating this message
option 3: I don't _think_ so! PuuuuLease!*!
It took _me_ several hours to install V8.1.
that was coming off my site's intranet, some ten miles down the road.
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
archives: http://www.listserv.uga.edu/archives/sas-l.html
------------------------------
Date: Thu, 27 Jul 2000 17:48:44 GMT
From: John Iwaniszek <jiwaniszek@NC.RR.COM>
Subject: Re: running SAS V8 from Ultraedit
Lex Jansen wrote:
>
>
> "John Iwaniszek" <jiwaniszek@nc.rr.com> wrote in message
> news:398053C6.5B58F933@nc.rr.com...
> > Has anyone hit on the magic words for setting up and Ultaedit tool to
> > run V8 from the button bar? I had it set up for v612 and the button
> > worked fine.
> >
> > As my command line I now have : D:\sasv8\Sas.exe %f -nologo -config -set
> > jobpath
> >
> > %f is the ultraedit variable that contains the full path to and name of
> > the sas program.
> > JOBPATH is an environment variable the will contain the full path to and
> > name of the sas program that will later get placed in a macro variable.
> >
> > sasv8cfg is in the directory containing the sas program and I am
> > assuming SAS looks there first for configuration (This assumption is
> > probably what is killing me).
> >
> > Thanks for any help.
> >
> John,
>
> I have this:
> command:
> "C:\Program Files\SAS Institute\SAS\V8\SAS.EXE" "%f" -nosplash
> working directory: %p
> Anf I have check the tickbox 'Check if Windows program', otherwise it
won't
> work.
>
> sasv8cfg is also in my directory containing the sas program.
> and it's used which I can check because that's where my AUTOEXE.SAS is
being
> defined.
>
> and it works!
> so I'm not sure what goes wrong in your setup.
> Maybe quotes around %f ??
>
> Regards,
>
> Lex Jansen
I have adopted a stripped down version that amounts to what you have and
it seems to work.
John
------------------------------
Date: Thu, 27 Jul 2000 20:10:17 +0200
From: Lex Jansen <l.jansen@LEX-JANSEN.DEMON.NL>
Subject: Re: Reverse Question of, Parse 1 string
VAR13 = trim(VAR10)||VAR3;
Regards,
Lex Jansen
"Mark Moran" <Mark.K.Moran@CCMAIL.CENSUS.GOV> wrote in message
news:85256929.0050E60F.00@it008nthqln.tco.census.gov...
> I should mention that, when I say "string together" I am talking about
character
> variables, not numbers.
>
> Mark
>
> >>>>>>>>>>>>>>>>>>>
> I have the almost exact reverse question. What is the best,
straightforward way
> in SAS 6.12 to string together a 10-digit variable VAR10 and a 3-digit
variable
> VAR3 into
> a single 13-digit variable VAR13? For example,
>
> VAR10 VAR3 ==> VAR13
> ____________ ______
> _______________
> 0112030201 574 0112030201574
> 2560493172 123 2560493172123
>
> Mark
------------------------------
Date: Thu, 27 Jul 2000 18:17:20 +0100
From: David Johnson <David.Johnson@UK.ROYALSUN.COM>
Subject: Re: More on SAS V8.1 TS1M0
I'm not sure I agree entirely with you Jack. It seemed to be true of Star
Trek
movies <g>.
Seriously though, my experience found 6.07 to be light years ahead of 6.06
and
6.09 didn't represent any significant issue. I note you missed 6.10,
perhaps
with reason, but I agree that the backwards writing and other minor bugs in
6.11 were a little painful.
Anyway, enough wasted bandspace, on to the purpose of posting.
After some difficulty, which wouldn't have happened if I had first read all
100
pages of the install manual, we got the new library interfaces working
brilliantly into Sybase. However, some syntax doesn't seem to work as
expected.
Proc Contents Data = MYDBLIB._All_ NoDs;
Run;
Gives me a lovely header sheet, and no data set index listing. Hitting
dictionary.tables in proc sql similarly misses out all the libraries in the
interface. However, I can get to individual tables if I know the name.
Have I missed something here? I had hoped that all the capability of the
Libname engine would be surfaced to the DBAccess method. That doesn't seem
to
be the case.
Any ideas out there?
HP-UX OS 11.0 Sybase 11.0 SAS V8 TS1M0.
David
JShoemaker@ACCORDANT.NET@AKH-WIEN.AC.AT
27/07/2000 14:41
___________________________________________________________________________
Please respond to JShoemaker@ACCORDANT.NET
Sent by: SAS-L@AKH-WIEN.AC.AT
To: SAS-L@AKH-WIEN.AC.AT
cc:
Subject: More on SAS V8.1 TS1M0
"THIS MESSAGE ORIGINATED ON THE INTERNET - Please read the detailed
disclaimer below"
----------------------------------------------------------------------
Dear SAS-L,
Never trust the odd-numbered releases. I thought I had learned this
lesson already. Remember 6.03, 6.07, 6.09, 6.11 and 7.0? Would you rather
run those versions of SAS, or 6.04, 6.06, 6.08, 6.12, and 8.0?
Add 8.1 to that esteemed list.
SAS/ACCESS for PC file formats either is broken, or has changed radically
with V8.1. I have production jobs involving PROC IMPORT and PROC EXPORT
which are failing all over the place. If you use this component of SAS, I'd
suggest that you not to upgrade at this time.
Stay tuned. - jack
--
Jack N Shoemaker / JShoemaker@Accordant.net
Visit our patient communities at http://www.accordant.com or our corporate
site http://www.accordant.net
----------------------------------------------------------------------
The following message has been automatically added by the mail gateway
to comply with a Royal & Sun Alliance IT Security requirement:
"As this email arrived via the Internet you should be cautious about
its origin and content. Replies which contain sensitive
information or legal/contractual obligations are particularly
vulnerable. In these cases you should not reply unless you are
authorised to do so, and adequate encryption is employed.
If you have any questions, please speak to your local desktop
support team or IT security contact".
----------------------------------------------------------------------
------------------------------
End of SAS-L Digest - 27 Jul 2000 - Special issue (#2000-732)
*************************************************************
