My understanding is that EG 4.2 is supposed to provide Vista support. Tech Support won't confirm, but new releases often come out around the time of the SUGI meetings in the spring. That said, EG 4.1 can be installed with Vista (I haven't tried it myself, but had a student succeed this fall.). Search this forum for a thread on it. If you run into trouble, SAS Tech Support won't help. Doc ... View more

This sounds like a question for Tech Support. Also, this forum is for Enterprise Guide, not Enterprise Miner, so there aren't very many readers who can help directly. Doc ... View more

Take a look at the ODS statistical graphics for proc CORR. You could do all your scatterplots with 3 lines. add ODS graphics on: before the PROC; add ODS GRAPHICS OFF; after it. Modify the PROC statement to add the options that you want for the plots (look at the SAS reference on the Web). Doc ... View more

Anil, You will likely find the references to the software used for a particular Cancer study analysis in the methods section of the papers in the medical literature. Just go to medline and search on the acronym for the cooperative groups (CALGB, POG, ACoSOG, etc.), or just page through any issue of the Journal of the National Cancer Institute for an idea. I know CALGB and ACoSOG routinely use SAS for analyses. They may also use S+ or R for some. Doc ... View more

With your SPSS experience, buy "SAS for Dummies" or "The Little SAS Book for Enterprise Guide 4.1" for a very quick start. Data transformations are under data --> filter and query . Then hit F1 for context sensitive help. [Bernie, SAS Learning Edition now uses SAS 9.1.3 and EG 4.1, supports 1500 observations, and cost ~$200. I think I got a slightly older copy, since it expires 12/31/2008.] Doc ... View more

Sounds like a mis-guided attempt to save money. First, get a copy of Constable's "SAS Programming for Enterprise Guide Users", it covers a lot of the links between SAS and EG. You can just use file --> open --> code to insert a complete SAS program into EGuide. It is there as a shortcut, so you can edit it with your favorite text editor in windows (or Unix, with a samba connection) or with the EG built in editor. Then you can just run it within the eguide environment (you'll have to define a SAS server in eguide to run it). I actually find EG quite convenient to prototype an application, then export the code, so I can refine/expand it with a professional editor (I prefer GNU EMACS) and bring it back in to EG run it. I still tend to do my data in from scratch, I get a lot of messy data to read. I like the way the process flow diagram can help keep all the pieces together (note you can have multiple process flow diagrams in one project) and I use the "send to" --> "email as part of project" to bundle multiple outputs and send them on to me or my users. I'm not sure what you mean about the SAS/Graph comment; EG uses the SAS server to run all the graphics. We may be "old dogs", but there truly are some productivity savings for us in EG. Don't fight it, adapt it to your needs. Doc ... View more

David makes a good point about multiple comparisons. In a frequentist view of the world, this can lead to many false positives if you adhere to the cut-point approach. P-values can also be interpreted as a metric on the strength of evidence. Suffice it to say, use caution with lots of p-values and little data. If you are looking just for p-values, and don't also need the regression coefficients, the correlation task provides the same p-values as univariable regression. It has different assumptions for interpretation of the statistic, but the p-values are the same. Doc Muhlbaier Duke ... View more

One thing to always be aware of in removing or counting "duplicates" is the definition of "duplicate" and the process of obtaining it. Your example and Cynthia's response will look at what are effectively duplicate KEYS, not duplicate RECORDS. To look at duplicate RECORDS, you have to sort on all variables in the dataset, and compare on all values. Recall this note from the PROC SORT documentation "Because NODUPRECS checks only consecutive observations, some nonconsecutive duplicate observations might remain in the output data set. You can remove all duplicates with this option by sorting on all variables." I believe SAS has had this "feature" since at least version 5. Doc Muhlbaier Duke ... View more

It seems like you could use something like the Hosmer & Lemeshow test for goodness of fit. It works with predicted risk under the logistic regression model. H&L is not a very powerful test, so I prefer to use a visual analogue to it. Sort the predicted scores, divide into deciles (quintiles if the N is small), and then plot the midpoint of each decile against the proportion of positive outcomes for the observations in that decile. If your risk score fits well the line through those 10 points will be reasonably straight. It's basically testing the reliability of your risk driver(s). Doc Muhlbaier Duke ... View more

Check the DDE documentation in the SAS manuals. The DDE application data needs to be a triplet consisting of the word "excel", then name of the sheet, and the location of the data in the sheet. Here is an example form the SAS manual filename test dde 'Excel|c:\excel\ [Sales.xls]Sales Data!R1C1:R4C2' If that doesn't work, it's time to call SAS Tech Support. Doc Muhlbaier ... View more

yes. Import data (and the create a SAS dataset option under File>Open>data) create a SAS dataset from the excel sheet. To re-import, you have to re-run the task. file>open>data also allows you to open the excel file "in place" so changes to the excel file appear immediately to the project. IMHO, import data allows a little more flexibility at the expense of immediacy. Doc Muhlbaier ... View more

This note shows some ways to get more efficient throughput for large data in EG http://support.sas.com/kb/26/178.html If you are just using the GUI in EGuide to do the analyses, the default behavior is to bring the data into EGuide and then send it on to the SAS server, effectively requiring that the data be read twice. The more data, the more noticeable the delay. ... View more

When I have to access multiple schemas in one oracle database, I just use the SAS SQL passthrough to get to them (I use the CONNECT statement to get to one of them and then specifying the rest using the schema_name.table_name.column_name in the passthrough query.). Perhaps not elegant, but it works. Doc Muhlbaier ... View more

If you save the log to a file, you can search it with grep or using the SAS perl regular expressions. I'm not sure that is what you were searching for, but it works reasonably well in a batch environment. Doc Muhlbaier Duke ... View more

SAS/Access to ODBC for unix is a separately licensed product. It does exist and we use it. Doc ... View more