subset observation

[fighting123]

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;

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

[fighting123 · Accepted solution]

[Amir]

Hi @fighting123 ,

It looks like you have specified "vega" (without an "s" on the end). Change this to "vegas" on your set statement and try again.

Kind regards,

Amir.

[andreas_lds]

Please post the complete log as text using the "Insert Code" button.