Thanks ... View more

I am a bit confused what is the site link? Can you please send me? Thanks. ... View more

Thanks so much!! I really appreciate your help. ... View more

Thanks so much for your help. ... View more

Please see the log message below. %put &=SYSSCPL 74 75 libname inexcel xlsx '/home/sandhyatippur/cert/input/test_tab.xlsx'; SYSSCPL=Linux libname inexcel xlsx '/home/sandhyatippur/cert/input/test_tab.xlsx' 76 77 proc sql; 78 select memname from dictionary.tables where libname ="inexcel"; NOTE: No rows were selected. 79 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 5291.93k OS Memory 33960.00k Timestamp 07/14/2020 05:29:26 AM Step Count 24 Switch Count 0 Page Faults 0 Page Reclaims 534 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 80 81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ... View more

please see error from my log 73 libname inexcel xlsx '/home/sandhyatippur/cert/input/test_tabs.xlsx'; NOTE: Libref INEXCEL was successfully assigned as follows: Engine: XLSX Physical Name: /home/sandhyatippur/cert/input/test_tabs.xlsx 74 75 76 77 proc import datafile='/home/sandhyatippur/cert/input/test_tabs.xlsx' 78 out=test dbms=xlsx 79 replace; 80 getnames=yes; 81 run; ERROR: Physical file does not exist, /home/sandhyatippur/cert/input//test_tabs. NOTE: The SAS System stopped processing this step because of errors. ... View more

I tried using proc import like you mentioned and the error message I got is: ERROR: Physical file does not exist, /home/sandhyatippur/cert/input//test_tabs. libname inexcel xlsx '/home/sandhyatippur/cert/input/test_tabs.xlsx'; proc import datafile='/home/sandhyatippur/cert/input/test_tabs.xlsx' out=test dbms=xlsx replace; getnames=yes; run; please advise. Thanks. ... View more

Thanks for your help.  ... View more

I ran the proc contents and got this error message. Please advise.   proc contents data='/home/sandhyatippur/cert/input/test_tabs.xlsx'; ERROR: Extension for physical file name "/home/sandhyatippur/cert/input/test_tabs.xlsx" does not correspond to a valid member type.     ... View more

Thanks so much for your help!!! ... View more

Thanks I was able to figure out the issue. ... View more