ERROR: Physical file does not exist ?

[leehsin · Accepted solution]

Thanks to all suggestions in the discussions. These suggestions provide all the ways/directions to debug the code. In summary, by testing, I found in the current scenario, two ways made it work:
1) update the cases of letters in the path/file to be consistent;
2) I added a slash to the end of the first line, it could import the data (not knowing why, but this was what happened):
%CsvExl_Import(location= &rootDir.projects/pmh/qa/qci/pmh-be-car-cat/&impl./
,filename= caCat_Test_Plan_&impl.
,DBMS= xlsx
,outfile= caCat_Test_Plan_&impl.)

[DWilson]

In your first post you have the string "bene" in your file path. In all subsequent posts the "bene" is gone and replaced with "be"

Which one is correct? "bene" or "be"?

Also, the let statement appears to have a space between the equals sign and the start of the name you want. Maybe the space is being captured and inserted into your file path? On Linux, spaces in file names are possible but you need to use a / before the space. Maybe SAS is trying to do something like that and is not quite able to do it? Maybe SAS is translating the space as a / which would give you two slashes which means that the resulting file path would not be found.

[leehsin]

'bene' you caught is a typo. It should be 'be'. Thanks.

I will check the effect of the space between the equal sign and the start of text in let statement. Thanks for the suggestion.

[DWilson]

In one of your posts you said this:

I defined DBMS= xlsx. &impl is resolved as " 2019".

so it does look like the let statement is capturing the leading space before 2019. Try removing the leading space in your let statement.