On P125 of the Prep Guide 4th ed, it said "The Excel worksheet names have the special character ($) at the end... You must assign a name literal to the data set name." A follow-up example shows the Excel work sheet name is 'tests', so the name literal is 'tests$'n when running the DATA step, it's like DATA STRESS; SET RESULTS.'tests$'n; RUN; I used my local file to practice. I found that I can run the DATA step successfully without '$' at the end (still name literal like 'tests'n), but cannot make it with '$' at the end ('tests$'n). My Excel version is Excel2016. If I get a question in the real test, how should I answer it? Thanks, Eric
... View more
