Hi, my sas is stuck everytime I try to run this code: proc sql;
insert into myora.Customer_t
set customerid = 100,
customername = "Cool Future",
customeraddress = "123 Lake Side Drive",
customercity = "Ithaca",
customerstate = "NY",
customerpostalcode = "14850";
quit; But I can connect to myora and select as normal (as shown below:) 1 libname myora oracle user="xxx" password=XXXXXXXXXX path="xe";
NOTE: Libref MYORA was successfully assigned as follows:
Engine: ORACLE
Physical Name: xe
1 ! run;
2 libname orasas "D:\hw5";
NOTE: Libref ORASAS was successfully assigned as follows:
Engine: V9
Physical Name: D:\hw5
3 title2 "Output2";
4 proc sql;
5 select * from
6 (select * from myora.customer_t where customerstate="NY" or customerstate="PA")
7 order by customerstate, customername;
NOTE: Writing HTML Body file: sashtml.htm
8 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.25 seconds
cpu time 0.09 seconds
This is what it looks like when I submit those code: I really don't know why it is stuck every time just for this insert statement. I tried to wait for it. But it just won't finish executing. There is no log output, I can't even scroll the log window, or anywhere else. I can insert this row as normal in SQL developer: INSERT INTO Customer_t (customerid, customername, customeraddress, customercity, customerstate, customerpostalcode)
VALUES (100, 'Cool Future', '123 Lake Side Drive', 'Ithaca', 'NY', '14850'); (Log: "1 row inserted.")
... View more
