Able to connect to PC files but not able view the data and write to the excel file.   CODE:   options validvarname=any; libname xl XLSX 'C:\Users\107792\Desktop\excel\con_a_del.xlsx';   /* discover member (DATA) names */ proc datasets lib=xl; quit;   libname xl list;     PROC DATASETS LIBRARY=xl; QUIT;       data xl.class;                 set sashelp.class; run;   proc sql;                 create table as xl.class;                 select * from Sashelp.class; quit;   libname xl clear;     LOG   1    %studio_hide_wrapper; 82   options validvarname=any; 83   libname xl XLSX 'C:\Users\107792\Desktop\excel\con_a_del.xlsx'; NOTE: Libref XL was successfully assigned as follows:       Engine:        XLSX       Physical Name: C:\Users\107792\Desktop\excel\con_a_del.xlsx   /* con__del.xlsx file is having 10 sheets naming S1,S2,S3….S10 those sheets are also not recognised */ 84   85   /* discover member (DATA) names */ 86   proc datasets lib=xl;                                                              Directory                                     Libref         XL                                                                              Engine         XLSX                                                                             Physical Name  C:\Users\107792\Desktop\excel\con_a_del.xlsx                                     Por            .                                           WARNING: No matching members in directory. 87   quit; NOTE: PROCEDURE DATASETS used (Total process time):       real time           0.02 seconds       cpu time            0.03 seconds       88   89   libname xl list; NOTE: Libref=   XL       Scope=    Compute Server       Engine=   XLSX       Physical Name= C:\Users\107792\Desktop\excel\con_a_del.xlsx       Por= 90   91   92   PROC DATASETS LIBRARY=xl;                                                              Directory                                     Libref         XL                                                                               Engine         XLSX                                                                            Physical Name  C:\Users\107792\Desktop\excel\con_a_del.xlsx                                     Por            .                                           WARNING: No matching members in directory. 93   QUIT; NOTE: PROCEDURE DATASETS used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds       94   95   96   97   data xl.class; 98   set sashelp.class; 99   run; ERROR: Temporary file for XLSX file can not be created -> C:\Users\107792\Desktop\excel\/con_a_del.$$1.  Make sure the path name is correct and that you have write permission. ERROR: File XL.class.DATA does not exist. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set XL.class was only partially opened and will not be saved. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.01 seconds       100  101  proc sql; 102  create table as xl.class;                       --      -                       79      22                               76 ERROR 79-322: Expecting a LIKE. ERROR 22-322: Syntax error, expecting one of the following: (, AS, LIKE.  ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 103  select * from Sashelp.class; NOTE: Statement not executed due to NOEXEC option. 104  quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds       105  106  %studio_hide_wrapper; 117  118  ... View more