Good evening all, I have an question in inner join , I have performed inner join like this  proc sql; create table combine as select distinct n.apple, p.vegges from  fruits as n inner join  vegetables as p on  n.key=p.key; quit;     Now in vegges column I have carrots,beans,brocoli,beets--I like my data only to have carrot and beans , how will I apply this condition here. Thank you S  ... View more

Hello my friends, I have an question pertaining to appending the data to dataset. Example : every week an file comes into the folder - which needs to be appended to the dataset. I have 35 files --where in I have used infile * and created the dataset till this week -- which is all good. Now next week if the file (.csv) come in - I want the new file to directly append to the dataset which is ready rather then reading entire 35 files+ new file and appending to the dataset. In short question is : How can I append the data to existing dataset without reading previous files. Thank you, S   ... View more