SAS

Questions about SAS DDE,
Xamil -=20 =20 The problem is that Excel names macro and worksheets sequentially - = macro1, macro2, macro3, etc. and sheet1, sheet2, sheet3, etc. On the = second iteration your program refers to incorrect macro and sheet names. = =20 Not quite sure what all you are trying to accomplish, but here's a = coup... 29 Nov 2006 14:34

copy external file
Is there a way to make a copy of an external files from SAS (without using SYSTEM or X)? I want to "proc import" an excel file even if the user already has it open. The idea is to first copy it to C:\temp (OK not very portable...) and then "proc import" the copy. I can do it with "system" and the noxwait option,... 4 Dec 2006 03:16

Error SAS to ORACLE
Hi everybody, I have the following situation, I have SAS Foundation 9.1 on a unix machine and ACCESS To ORACLE and it was running perfect. And I have several libraries on Oracle very fine. but I stopped the services in order to install SP4. The installer didn't work but at the time of start the services agai... 24 Nov 2006 17:55

testing for random effects in proc mixed
Dear all, I have data with four class dimensions: countries, year, sector, size of company (qualitative variable). I construct dummies for the industry and use PROC REG to estimate an equation in the form Y = X + industry dummies. I would like to make a Hausman test to check whether my industry fixed effects a... 30 Nov 2006 03:13

Proc reg test not consistent
I have the following code. I want to test for the significance of the different transforms of income as a group. data test; set input.desc1; income2 = income*income; incomelog = log(income+1); run; proc reg; model alrndom = income income2 incomelog /corrb collin; test income, income2, incomelog; qui... 7 Dec 2006 22:40

Import from Access
Do you have sas/access for odbc or oledb licensed? If so, you should be able to do pass-through to solve both problems at once. Something like: Proc sql ; connect to oledb as msacc (Provider=Jet DataSource='\\server\dir\subdir\my_file.mdb') ; create table sas_friendly as select * from connection to msac... 21 Nov 2006 10:37

IML Error - Please Help
The message is telling you that the variable PHI is not defined when the Probit function is called. Ian. ----- Original Message ----- From: "Ricardo G Silva" <ricardosilva(a)SERASA.COM.BR> To: <SAS-L(a)LISTSERV.UGA.EDU> Sent: Thursday, November 09, 2006 1:22 PM Subject: IML Error - Please Help In runnin... 9 Nov 2006 08:29

error: conversation termination status=2
Hi all, I have SASv9 on my local pc and do a signon on mainframe, which has SASv9 as well. After a while (between 15 and 20minutes), the connection stops with error message error: conversation termination status=2 Anyone got this problem before? Any idea where the problem comes from? I couldn't find any descrip... 8 Nov 2006 05:30

Data Integration Studio performance
We're using Data Integration Studio and the performance when we make a checkin of our repository is terrible. While checkin is processing, nobody can work and it can take 15/30 minutes.... Any solution?? Thanks a lot ... 4 Nov 2006 07:24

FTP Binary File and Verify
I am trying to write a program to download a binary file from the mainframe to a pc and verify it. The pc file does not match the original. Any suggestion would be appreciated. FILENAME A ' main.report.PDF' DISP=SHR; FILENAME B FTP 'report.PDF' HOST='my.mainframe.com' USER='xxxxx' PASS='xxxxx' RE... 2 Nov 2006 09:41