I will rais it to SAS, ... View more

I will not test the hotfix because I using EG 8.3 and the hotfix is for 8.2. I will not risking corupt EG 8.3 with a hotfix for 8.2. And according to the note, it is solved in 8.3. I think my problem is another problem, maybe due to different encoding in the OS and SAS.   EG will browse the Files.   /Anders ... View more

I think You are right. Now I can let the administrator work with the problem. ... View more

Thank You for your respons. I have test the request several times form other servers, with the same script, and got perfect result. And every time I test on the server, I got bad result. ... View more

I know about AMO but it works not on a SAS Workstation licens. I consider useing AMO on an other set up with OA-server. /Anders ... View more

Code; libname myxl xlsx "C:\Dokument\Befolkningspronos\Manuell_justering\projektParametrar.xlsx"; run; data flyttrikser_data; set myxl.flyttrisker; run; proc ds2; data flyttrisker_ds2; method run(); set myxl.flyttrisker; end; enddata; run;quit; proc ds2; data _null_; method run(); sqlexec('select * into work.flyttrikser_fsql from myxl.flyttrisker'); end; enddata ; run;quit; log: 30 libname myxl xlsx "C:\Dokument\Befolkningspronos\Manuell_justering\projektParametrar.xlsx"; NOTE: Libref MYXL was successfully assigned as follows: Engine: XLSX Physical Name: C:\Dokument\Befolkningspronos\Manuell_justering\projektParametrar.xlsx 31 run; 32 data flyttrikser_data; 33 set myxl.flyttrisker; 34 run; NOTE: The import data set has 12928 observations and 8 variables. NOTE: There were 12928 observations read from the data set MYXL.flyttrisker. NOTE: The data set WORK.FLYTTRIKSER_DATA has 12928 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 1.73 seconds cpu time 1.68 seconds 35 proc ds2; 36 data flyttrisker_ds2; 37 method run(); 38 set myxl.flyttrisker; 39 end; 40 enddata; 41 42 run; 42 ! quit; ERROR: Compilation error. ERROR: BASE driver, schema name MYXL was not found for this connection ERROR: Table "MYXL.FLYTTRISKER" does not exist or cannot be accessed ERROR: Line 38: Unable to prepare SELECT statement for table flyttrisker (rc=0x80fff802U). NOTE: PROC DS2 has set option NOEXEC and will continue to prepare statements. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE DS2 used (Total process time): real time 1.40 seconds cpu time 0.34 seconds 43 44 proc ds2; 45 data _null_; 46 method run(); 47 sqlexec('select * into work.flyttrikser_fsql from myxl.flyttrisker'); 48 end; 49 enddata ; 50 run; 50 ! quit; ERROR: BASE driver, schema name MYXL was not found for this connection ERROR: Table "MYXL.FLYTTRISKER" does not exist or cannot be accessed ERROR: Failed to prepare SQL statement: select * into work.flyttrikser_fsql from myxl.flyttrisker NOTE: Execution succeeded. No rows affected. NOTE: PROCEDURE DS2 used (Total process time): real time 0.12 seconds 2 The SAS System 08:38 Monday, June 4, 2018 cpu time 0.10 seconds My question: Is the result by design or have I done an error? /Anders ... View more

Thanks, I have write a demographic prognos program and use Excel as interface to data which I had to change. /Anders ... View more