HI Team, Is there a way to export a sas dataset as Oracle/SQL Table without having a Connect to oracle(Odbc connection)?? The basic need here is to make data ready to upload in oracle, which is on a different machine as well as on different network and didn't have SAS Installation. Any help will be appreciated. Thanks in advance, Regards, Rajesh
... View more
HI Reeza, It is happening with certain specific data but not with every input data. So, trying to find out the reason and pattern which is causing this issue: Below is the SAS code, which i am trying to execute: libname test "C:\Rajesh\HRA\AL_CERT\Input_May_06\test_datasets"; PROC TRANSPOSE DATA= test.ac_cert_check OUT=al_cert_check_tr; BY A--AE; VAR AF--JW; RUN; For reference, I have attached the input dataset. Regards, Rajesh
... View more
Hi Team, I am getting below exception and error while Transposing a dataset in SAS. Can anyone please help me on this? ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [TRANSPOSE] ERROR: Read Access Violation TRANSPOSE Exception occurred at (0CEBEA19) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) Thanks in advance for your help, Regards, Rajesh
... View more
HI Reeza, Thanks for your much needed help. Really appreciated. So, it worked with your library decalration given as below: Libname xls pcfiles path="path to excelfile"; I utilized them in my code as below : libname xls pcfiles path= "C:\test\testfile.xlsx"; data t; set sashelp.vtable; where libname = 'XLS'; run; Regards, Rajesh
... View more
I have Office 2013 and Yes, Libname is assigned in Window SAS . Regarding, Checking the bits (SAS vs Office), what steps do i need to follow. Could you please guide me
... View more
Hi KurtBremser, Thanks for your quick help. The file which i am trying to open is valid xlsx. I mean with valid xlsx extension. I tried with XLSX engine but got below error as: libname xls xlsx "C:\test\testfile.xlsx"; ERROR: The XLSX engine cannot be found. ERROR: Error in the LIBNAME statement. I am currently using SAS 9.3 and i have SAS/ACCESS Interface to PC Files installed as copy of Proc setinit from my SAS PC as below: Product expiration dates: ---Base SAS Software 31AUG2016 ---SAS/STAT 31AUG2016 ---SAS/GRAPH 31AUG2016 ---SAS/ETS 31AUG2016 ---SAS Enterprise Miner 31AUG2016 ---SAS Text Miner 31AUG2016 ---SAS Enterprise Guide 31AUG2016 ---SAS/ACCESS Interface to PC Files 31AUG2016 ---SAS Enterprise Miner for Desktop 31AUG2016 ---SAS Workspace Server for Local Access 31AUG2016 ---SAS Add-in for Microsoft Excel 31AUG2016 Regards, Rajesh
... View more
Hi RW9, Thanks for your quick help. The file which i am trying to open is valid xlsx. I mean with valid xlsx extension. I am currently using SAS 9.3 and i have SAS/ACCESS Interface to PC Files installed as copy of Proc setinit from my SAS PC as below: Product expiration dates: ---Base SAS Software 31AUG2016 ---SAS/STAT 31AUG2016 ---SAS/GRAPH 31AUG2016 ---SAS/ETS 31AUG2016 ---SAS Enterprise Miner 31AUG2016 ---SAS Text Miner 31AUG2016 ---SAS Enterprise Guide 31AUG2016 ---SAS/ACCESS Interface to PC Files 31AUG2016 ---SAS Enterprise Miner for Desktop 31AUG2016 ---SAS Workspace Server for Local Access 31AUG2016 ---SAS Add-in for Microsoft Excel 31AUG2016 Regards, Rajesh
... View more
Hi Team, I want to get worksheet names from excel in order to validate the available sheets? since sometimes i did not get the required worksheets as part of excel and my sas codes starts throwing error for the same with proc import. I tried below code for finding out the worksheet names available: libname xls excel 'C:\test\testfile.xlsx'; data t; set sashelp.vtable; where libname = 'XLS'; run; But continiously getting below error: 104 libname xls excel 104! 'C:\test\testfile.xlsx.xlsx'; ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. 105 data t; 106 set sashelp.vtable; 107 where libname = 'XLS'; 108 run; Can anyone help me on the same to resolve this error as I am stuck here!!
... View more