Thanks.  I will try this method as well.  Thanks. ... View more

Hello there, Thanks! Yes, it worked!  However, what has been puzzling is that the original codes DID work very well until about a couple of weeks ago.  That is, the file folder to which the Excel file was imported did not have to be named the same as the library's name.  For example, I named the library X for the ease of typing; but, the folder where the Excel resides was meaningful.  Any idea why there is this change or was I missing any other info?   Anyway, I found out an alternative by simply creating a permanent SAS dataset without using the libname statement, and it worked, too. ... View more

Hello there, Thanks for your response.  I've checked the original Excel file attached, and the tab name is called "Sheet1."  Thanks. ... View more

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;  70          71         OPTIONS NOOVP NODATE NONUMBER LS=70 PS=50;  72          73         LIBNAME X xlsx '/home/…/…/…/Book2.xlsx';  NOTE: Libref X was successfully assigned as follows:        Engine:        XLSX        Physical Name: /home/.../.../.../Book2.xlsx  74          75         DATA Weekly;  76            SET X.Sheet1;  ERROR: File X.Sheet1.DATA does not exist.  77            NOTE: The SAS System stopped processing this step because of errors.  WARNING: The data set WORK.WEEKLY may be incomplete.  When this step           was stopped there were 0 observations and 0 variables.  NOTE: DATA statement used (Total process time):        real time           0.00 seconds        user cpu time       0.00 seconds        system cpu time     0.00 seconds        memory              2822.21k        OS Memory           25080.00k        Timestamp           01/09/2025 07:12:40 PM        Step Count                        24  Switch Count  2        Page Faults                       0        Page Reclaims                     737        Page Swaps                        0        Voluntary Context Switches        15        Involuntary Context Switches      0        Block Input Operations            0        Block Output Operations           160             78         PROC FREQ DATA=Weekly order=data;  79             BY Observation;  ERROR: Variable OBSERVATION not found.  80         TABLES Depositor/BINOMIAL(p=0.3 level='Paid_Weekly' wald  80       ! exact) alpha=0.1;  ERROR: Variable DEPOSITOR not found.  81          82         RUN;    NOTE: The SAS System stopped processing this step because of errors.  NOTE: PROCEDURE FREQ used (Total process time):        real time           0.00 seconds        user cpu time       0.00 seconds        system cpu time     0.00 seconds        memory              336.03k        OS Memory           22948.00k        Timestamp           01/09/2025 07:12:40 PM        Step Count                        25  Switch Count  0        Page Faults                       0        Page Reclaims                     30        Page Swaps                        0        Voluntary Context Switches        0        Involuntary Context Switches      0        Block Input Operations            0        Block Output Operations           0         83          84         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ... View more