Thank you all for valuable suggestions, But this is not working for me; libname out "/home/u19696098/EPG1V2/data" ; data out.fox; set pg1.np_species; where Category="Mammal" and Common_Names like '%Fox%' and Common_Names not like '%Squirrel%'; drop Category Record_Status Occurrence Nativeness; run; proc sort data=out.fox; by Common_Names; run; 69 70 libname out "/home/u19696098/EPG1V2/data" ; NOTE: Libref OUT refers to the same physical library as PG1. NOTE: Libref OUT was successfully assigned as follows: Engine: V9 Physical Name: /home/u19696098/EPG1V2/data 71 72 73 74 data out.fox; 75 set pg1.np_species; 76 where Category="Mammal" and Common_Names like '%Fox%' 77 and Common_Names not like '%Squirrel%'; ERROR: Variable Category is not on file PG1.NP_SPECIES. 78 drop Category Record_Status Occurrence Nativeness; 79 run; WARNING: The variable Category in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Record_Status in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Occurrence in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Nativeness in the DROP, KEEP, or RENAME list has never been referenced.
... View more