JasmineChia Tracker

DDE: Data Step running but Not Responding

JasmineChia — Thu, 20 Oct 2011 02:48:26 GMT

Just an update, I realised that after I restart my computer, open the CreateCSVFiles.xls, run the program. I am able to run the program successfully after that even after I restart my SAS program.

But if I restart my computer, I need to go through the steps above again. Just wondering if anyone out there able to explain to me why this situation is happening?

DDE: Data Step running but Not Responding

JasmineChia — Wed, 19 Oct 2011 01:37:10 GMT

My original code is longer than this and does more thing than this. Right now I'm just trying to eliminate other unnecessary codes to find out what prompted my sas program to not respond. So I realised my program will stop responding whenever it tries to open CreateCSVFiles.xls.

DDE: Data Step running but Not Responding

JasmineChia — Wed, 19 Oct 2011 01:09:01 GMT

I can get through the first data step and successfully initiate my excel 2003, so I don't think it's the path problem, but after that my program will go into an infinite loop and stop responding, or so it seems to me. The problem seems to start at the 2nd data step. In the past I am able to open up the CreateCSVFiles.xls but not sure why now I can't do that anymore. I have also tried running other similar DDE program and failed at the part where I need to open the excel file (not initiate excel program).

I have updated my Windows once, so I'm not sure if this contributes to the error.

DDE: Data Step running but Not Responding

JasmineChia — Tue, 18 Oct 2011 08:51:32 GMT

The following are my line of codes that I've been trying to run on my SAS. Previously it was running ok with occasional error but lately I have been unsuccessful when running this code. I keep getting error where my SAS program will not respond then I will have to do a CTRL+ALT+DEL and kill the SAS program. I can't seem to decipher the error and failed to find any solution, these are just lines I copy from the Internet and it used to work fine. Can someone please enlighten me on this?

options noxwait noxsync;

x '"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe"';

data _null_;

x=sleep(5);

run;

filename ddecmd dde 'excel|system';

data _null_;

file ddecmd;

put '[FILE-OPEN("C:\My Projects\Temp\Data Capture\CreateCSVFiles.xls")]';

run;

data _null_;

file ddecmd;

put '[FILE-CLOSE("C:\My Projects\Temp\Data Capture\CreateCSVFiles.xls")]';

put '[QUIT()]';

run;

Retrieving data using Microsoft Access

JasmineChia — Tue, 16 May 2006 04:06:20 GMT

Good day,
Is it possible for me to obtain data from SAS data set using Microsoft Access without writing code in Base SAS, ie. using SAS ODBC?

Currently i'm trying to use Microsoft Access to retrieve data from SAS data set that is residing on a UNIX server.

Thanks