Hi,
I'm having trouble importing an excel file with the IMPORT procedure
proc import datafile= "/folders/myfolders/m2_pizza.xlsx"
run;
I'm getting this error message:
ERROR: Server Name is invalid or missing
Thanks! I wound up adding the DBMS option as well as the other option where Output where it created a dataset. Seemed to work.
Try adding the DBMS option:
proc import datafile= "/folders/myfolders/m2_pizza.xlsx" dbms = xlsx;
run;
Thanks! I wound up adding the DBMS option as well as the other option where Output where it created a dataset. Seemed to work.
Your proc import statement is also missing the necessary semicolon.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.