PROC IMPORT DATAFILE = 'C:\Users\TSE\s208034\Vegas_edit.xlsx'
/*read the dataset */
DBMS=XLSX OUT = Vegas_edit REPLACE;
/* file type extension .xlsx is excel file */
RUN;
PROC PRINT DATA = vegas; /*Print the result*/
TITLE 'vega\';
RUN;
DATA vegas_new;
SET vega;
IF _type ='Couples' THEN DELETE;
PROC PRINT DATA = vegas_new; /*Print the result*/
TITLE 'vegas_new';
RUN;
![fighting123_0-1603446353468.png fighting123_0-1603446353468.png](/t5/image/serverpage/image-id/50931iCD01E3DBBE1F7685/image-size/medium?v=v2&px=400)
after input an excel file into sas, i want to subset the observation 'couples' from the data
but why there is an error that the vegas data didn't not exit