Re: SAS/Warehouse Administrator Problem?? or SAS/ACCESS problem?? #2
What's the question? I know it you presented it earlier, but you can't
expect people to find the pieces of a problem and put them together.
Look at the various intermediate results and find the point where they
first diverge from what is expected. Then look at the code which generates
that particular result. De-macroize that code and prepare some test data so
that anybody can run it easily. Then present that isolated version of the
problem (if the answer has not already emerged during this process).
On Mon, 24 Apr 2006 11:19:35 -0700, saivs28@GMAIL.COM wrote:
>The following code ...Re: problem when installing SAS. windows x64 does not support SAS? #2
Take a look at:
On Wed, 14 May 2008 07:54:57 -0700, elodie.gillain@GMAIL.COM wrote:
>I am trying to install SAS on a Vista machine.
>The setup wizard says that Windows x64 does not support the SAS
>version I am trying to install.
>What can I do?
>I greatly appreciate your help.
...Re: SAS 9.2 Update on problem re Help files #2
SNOTES is an approximately daily email from SAS STech Support listing
the new or changed usage notes since the last email. So the item
pertaining to you was:
32792 - SAS prompts you to rebuild the index when you press F1 to
request help while running a SAS procedure in SAS 9.2
Release(s) Reported: 9.2
Date Created: 28JUL2008
Date Last Updated: 11AUG2008
To subscribe, go to
You'll get an extra email on most workdays, but if you sub...Re: Transfering datasets to Unix /SAS from PC/SAS
Re: <<...tried using FTP --- Invalid header on file...>>
If, as Art sagely mentions, the versions of SAS
on both platforms are 7 or after, then one note
worthy thing to check is that when transferring
a dataset with FTP, you must toggle the FTP
utility to NOT do any byte convertions. i.e. set
mode to BINARY (IMAGE on some platforms). You
can certainly make a quick check before and after
the transfer with your favorite editor or utility
to just look the first bunch of bytes in hex, or
whatever, to see if the bytes did not change. The
FTP utilities on different platforms, some...Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2 #2
> From: A Little Birdie
> I just searched the SAS-L archives (should have done that
> first) and found references to these two pages:
> Have you seen this page?
> http://support.sas.com/kb/35/631.html <---<<< NICE!
> It looks like it addresses your needs, and might be something
> nice to add to the SASCo...Re: SAS/Warehouse Administrator Problem?? or SAS/ACCESS problem??
I'm pretty sure that behind the scenes SAS/Warehouse Administrator is
generating and running SQL code. If you can expose that code and post it
here it might help.
On Sun, 23 Apr 2006 21:53:41 -0700, saivs28@GMAIL.COM wrote:
>I've built a process in SAS/Warehouse Administrator, where i'm trying
>to extract distinct cities from the 3 tables(source schema) in Oracle
>into a new table (target schema) called CITY and again into UniqueCity
>(target schema) bcos of some redundancy. The process looks like this.
> Unique ...SAS/Warehouse Administrator Problem?? or SAS/ACCESS problem?? #2
I've built a process in SAS/Warehouse Administrator, where i'm trying
to extract distinct cities from the 3 tables(source schema) in Oracle
into a new table (target schema) called CITY and again into UniqueCity
(target schema) bcos of some redundancy. The process looks like this.
...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #2
Test preparation is akin to following a simple algorithm:
1. Evaluate the test and discover if it is worth taking.
2. If #1 evaluates false then go to exit.
3. Determine if your *test* knowledge of SAS is insufficient.
4. If #3 evaluates true, do the test preparation.
5. Pay the money.
6. Take the test.
From your standpoint, the step of paramount importance is step #1. That is
where you mainly failed. From SAS' standpoint, only one step matters: #5.
This is the only reason the test was created in the first place.
The world would be a better place if all employers un...Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
Sounds like R is the SAS equivalent of Linux .. who are incidentally in all
sorts of a copy left/right mess at the moment.
On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote:
>I use both SAS and R; I"ve used SAS for 10 or 15 years, R for about 6
>months - 1 year.
>Each has strengths and weaknesses; I'd not like to give up either.
>Strengths of SAS (esp. compared to R)
>Tech support - I have SAS tech support's phone number and our license
>number memorized. They're great.
>SAS-L - There's also an R-help list...Re: FTP problem in SAS v9.2 #2
The problem may be with Windows Firewall/McAfee/Other Antivirus
programs blocking all but some programs from using FTP.
> Our program run on z/OS, but the same problem occurs on windows.
> There is no problem accessing the same ftp server from a native ftp client, and ping works as well.
> I have opened an issue with SAS.
...Re: SAS 8.2 to SAS 9.1 libname convertion #2
I am able to read Access 2000 tables using SAS 9.1.3, with syntax modeled
proc contents data=bb._all_; run;
to see what tables and views are detected.
On Fri, 8 Jul 2005 13:51:40 -0700, DC <chendlcan@YAHOO.COM> wrote:
>my codes created on SAS 8.2 does not work on SAS 9.1?
>Anyone knows how to convert the below code to SAS 9.1?
>Thanks a lot!
>libname bb dbaccess 'x:\a\b\c\d.mdb' bbb='asdfgh
>libname cc dbaccess 'x:\a\b\c\d.mdb' ccc='asd zxc';
> cre...Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #2
I am not sure that the SI Tech Support examples should have all the error
checking that Chang wanted to throw in the macro. The examples should be
clear concise and easy to read and get going, as well as be illistrative.
Too much error checking in an example well is just over kill and even
detrimental to an example. However, any code solution on the SI Tech
Support web sit should follow basic rules of good practices and sound
advice. Such as with thier macros having atleast a somewhat good Macro
Look at Example SAS Sample 1728:
The first method well lets say is soooo bad...Re: SAS time problem and formula problem #2
Please re-post your second question and present the formula in-line, as
part of the message. SAS-L does not allow attachments.
Also make it a separate posting, with its own subject. When a person has
two or more unrelated questions, there is no reason to bundle them in one
posting. It's not as if one has to pay for postage. Making a separate
posting for each question, with appropriate subjects, makes it much easier
to carry on and follow the discussions.
On Mon, 3 Nov 2003 11:51:14 +0000, Vijay Reddi <Vijay.Reddi@SSL-
>I have two probl...Re: suggest: improve SAS Deployment Wizard for SAS v9.2, phase 2
Subject: Re: v9.2 phase 2, page update
"Make the installation of SAS BI Server easier!"
Just remember that the majority of us are still just installing only
SAS Foundation v9.2, and possibly Enterprise Guide v4.2
My rant/suggestion to Tech Support has been addressed.
I have added notes about my conversation with Tech Support
to this sas community wiki page:
summary: if you have Build # greater than or equal to 28
then you can dispense with ForceInstall.
Ronald J. Fehd, IT Spec
HelpDesk Level 3: SAS
CDC S...Re: Newbie SAS Array problem (take 2) #2
Nice, good. But you should also declare your arrays dxnum and diagnum as
being of character type. And I would even completely avoid this kind of
solution. I would use a format instead (with some arrays or some macro
Create a format for your 46 diagnose codes, like:
'4270' = 'Paroxysmal supraventricular tachycardia'
.............and so on.............
And if it is just for presentation then never create a variable with the
textual diagnoses, but use the code variables (dx#) instead with the
format. If you really n...