Hello, IT WORKED!!   Thank you so much. Like you told, my MS office was installed in 32 bits and after I changed it to 64 bit and closed all open windows, I was able to Import both CSV and Excel files.   Thanks a lot. ... View more

Sorry for the confusion..   I am unable to import any file...   So basically when we import any file (.xlsx/xls, .csv) or any format.. I went like,   File -> Import Data -> Select format -> Browse file -> (When I select Excel)  ------> Connection failed (Check log for details)   Importing .xls   Log details:   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.     When I import .csv file  File -> Import Data -> Select format -> Browse file -> (When I select .csv) ------>    PROC IMPORT OUT= WORK.FAMILYHD DATAFILE= "C:\Users\Shashank\Desktop\DEN SD & HD plan list ( 1).csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; RUN; When I run this code this is the log detail I get     NOTE: The LocalTime has been updated. NOTE: This is likely due to a Daylight Savings Time or Timezone change. NOTE: NOTE: The LocalTime has been updated. NOTE: This is likely due to a Daylight Savings Time or Timezone change. NOTE: NOTE: Import Cancelled. 1 PROC IMPORT OUT= WORK.FAMILYHD 2 DATAFILE= "C:\Users\Shashank\Desktop\DEN SD & HD plan list ( 3 1).csv" 4 DBMS=CSV REPLACE; 5 GETNAMES=YES; 6 DATAROW=2; 7 RUN; ERROR: File is in use, C:\Users\Shashank\Desktop\DEN SD & HD plan list (1).csv. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.23 seconds cpu time 0.04 seconds       Kindly suggest..   ... View more

Hello, When I try to import xlsx file, after selecting the file and clicking okay, I get a prompt "Connection Failed: Please check the log window".   The result I get in Log window is below:   ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ... View more

Hello, I tried the code you mentioned and this is the log result i got. Could you please guide?   9 libname _all_ list; NOTE: Libref= SHASHANK Scope= DMS Process Engine= V9 Physical Name= C:\Users\Shashank\Desktop\SAS TEST Filename= C:\Users\Shashank\Desktop\SAS TEST NOTE: Libref= TMP1 Scope= DMS Process Engine= V9 Physical Name= C:\Users\Shashank\Desktop\SAS\Demo1 Filename= C:\Users\Shashank\Desktop\SAS\Demo1 NOTE: Libref= SHWETA Scope= DMS Process Engine= XPORT Physical Name= C:\Users\Shashank\Desktop\SYMPATHY EMPATHY\SAS DATA\demo1 NOTE: Libref= SASHELP Scope= Kernel Levels= 12 -Level 1- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG Filename= C:\Program Files\SASHome\SASFoundation\9.4\nls\en\SASCFG -Level 2- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\core\sashelp -Level 3- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\aacomp\sashelp -Level 4- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\cmp\sashelp -Level 5- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\dmine\sashelp -Level 6- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\ets\sashelp -Level 7- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\graph\sashelp -Level 8- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\iml\sashelp -Level 9- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\inttech\sashelp -Level 10- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\or\sashelp -Level 11- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\stat\sashelp -Level 12- Engine= V9 Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\tmine\sashelp Filename= C:\Program Files\SASHome\SASFoundation\9.4\tmine\sashelp NOTE: Libref= MAPS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps NOTE: Libref= MAPSSAS Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\maps Filename= C:\Program Files\SASHome\SASFoundation\9.4\maps NOTE: Libref= MAPSGFK Scope= Kernel Engine= V9 Access= READONLY Physical Name= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk Filename= C:\Program Files\SASHome\SASFoundation\9.4\mapsgfk NOTE: Libref= SASUSER Scope= Kernel Engine= V9 Physical Name= C:\Users\Shashank\Documents\My SAS Files\9.4 Filename= C:\Users\Shashank\Documents\My SAS Files\9.4 NOTE: Libref= WORK Scope= Kernel Engine= V9 Access= TEMP Physical Name= C:\Users\Shashank\AppData\Local\Temp\SAS Temporary Files\_TD9176_LAPTOP-0J3S2GHG_ Filename= C:\Users\Shashank\AppData\Local\Temp\SAS Temporary Files\_TD9176_LAPTOP-0J3S2GHG_ ... View more

Hello, I am getting same error with the libname and i am unable to import any data.   I tried running the code you mentioned and here are the log results   2 filename dir pipe "dir /b c:\"; 3 data _null_; 4 infile dir; 5 input; 6 put _infile_; 7 run; NOTE: The infile DIR is: Unnamed Pipe Access Device, PROCESS=dir /b c:\,RECFM=V,LRECL=32767 dc FFOutput HPHWDiag_log.txt inetpub Intel pcfservice.log PerfLogs Program Files Program Files (x86) SHANKY SWSetup Users Windows NOTE: 13 records were read from the infile DIR. The minimum record length was 2. The maximum record length was 19. NOTE: DATA statement used (Total process time): real time 0.37 seconds cpu time 0.01 seconds   ... View more