I did not create a library earlier which was the reason for the error. ... View more

same error even when i used these options ... View more

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 %Let infile= "~/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx";/* Change the file path */ 75 %Let outpath=~/home/Output;/* Change the file path */ 76 77 78 **************************************** 79 READ IN DEVELOPMENT DATA 80 ***************************************; 81 options validvarname=v7; 82 PROC IMPORT DATAFILE=&infile 83 OUT=Base 84 DBMS=XLSX REPLACE; 85 GETNAMES=YES; 86 SHEET='CLOC & IMS'; 87 RUN;   ERROR: Physical file does not exist, /home/u58836540/home/u58836540/CTE-SAS//Baseline_Report_raw_data. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2054.21k OS Memory 33700.00k Timestamp 22/06/2021 09:51:38 PM Step Count 145 Switch Count 0 Page Faults 0 Page Reclaims 462 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0   88 89 90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 102 ... View more

options nodate pageno=1; title; footnote; libname _all_;   %Let infile= "~/home/u58836540/TRY-SAS/Base_Report_raw_data.xlsx"; %Let outpath=~/home/u58836540/TRY-SAS/Output;/ options validvarname=v7; PROC IMPORT DATAFILE=&infile OUT=Base DBMS=XLSX REPLACE; GETNAMES=YES; SHEET='CLOC & IMS'; RUN; ... View more