topic Re: subset observation in New SAS User

subset observation

fighting123 — Fri, 23 Oct 2020 09:49:35 GMT

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

Re: subset observation

fighting123 — Fri, 23 Oct 2020 10:01:09 GMT

Re: subset observation

Amir — Fri, 23 Oct 2020 10:45:13 GMT

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.

Re: subset observation

andreas_lds — Fri, 23 Oct 2020 12:24:49 GMT

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