@GrizzlyDee wrote:
With this program, I am trying to use an existing Sas table (sasuser.Vehicles.xlsx) to create a new table (vehicles_info) containing a subset of that original data.
I don't believe that statement is correct. Please make sure you have correctly imported the Excel data set into SAS. There is a video recently posted on the SAS Analytics U page on how to import an Excel file. Once the file is imported correctly, you reference it with a two level name, LIBNAME.DATA_SET_NAME
If your dataset is called Vehicles, it would be:
data vehicles_info;
set sasuser.Vehicles;
where make='Ford' and year='2015';
run;
The other possibility is that you have validvarnames=ANY set, which means you would refer to the dataset as:
data vehicles_info;
set sasuser.'Vehicles.xlsx'n;
where make='Ford' and year='2015';
run;
... View more