topic Re: Importing excel data from a single work sheet? in New SAS User

Importing excel data from a single work sheet?

EdgarIsmael — Fri, 12 Jun 2020 09:56:15 GMT

Hi, I am stuck on level 1 practise and can not figure out how to solve it. This is the code that should be correct, but I still get the following errors. ( ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/home/userid/EPG194/data//eu_sport_trade. ) and (ERROR: File WORK.EU_SPORT_TRADE.DATA does not exist. )

proc import datafile="home/userid/EPG194/data/eu_sport_trade.xlsx"
dbms=xlsx
out=eu_sport_trade
replace;
run;

proc contents data=eu_sport_trade;
run;

Re: Importing excel data from a single work sheet?

Kurt_Bremser — Fri, 12 Jun 2020 10:03:05 GMT

You are working on a UNIX environment; supply absolute path names, otherwise the system will consider your filename a relative path that starts in the Current Working Directory. An absolute path starts in the system root, so the first character should be a forward slash:

proc import datafile="/home/userid/EPG194/data/eu_sport_trade.xlsx"

Re: Importing excel data from a single work sheet?

Kurt_Bremser — Fri, 12 Jun 2020 10:04:00 GMT

PS welcome to the Communities!