I have code using order by if not first. and last. then output unique else output duplicate I would like to do the same thing using sql but don't know how.  I cannot use 'group by count > 1' because the dataset has a lot of variables and I only want to 'order by' and 'group by' two of the variables. I'll attach the code if that helps, look at the bottom, that little 'group by' is what I'm trying, I know it won't work but that general idea is what I'd like.  I need the second column, if duplicated within the first column,  to spit out to another dataset, so I'll be forming two datasets instead of one.  One of them will be 'having count>1', the other will be 'having count=1'. Hopefully that makes sense. ... View more

Hello,  I am using enterprise guide in a unix and oracle environment.  I would like to build a user interface for someone to update specific records, they should have limited choices within those fields.  One user will have access to SAS the other will not.  Is this possible within EG?  If not what applications will I need?  The UI will need to communicate back to SAS, is this a job for ODS?  If you can provide any guidance or a place to find literature on the topic I will appreciate that. Thank You, Mark Go Pens ... View more

I am looking through the advanced cert study guide and came across the following: data profit; set cert.dnunder; set work.sale2000 (keep=routeid flightid date rev1st revbusiness revecon revcargo) key=flightdate; Profit=sum(rev1st,revbusiness,revecon,revcargo,-expenses); run; There is one record that is pulled from 'cert.dnunder' that is not in 'work.sale2000'.  The fields for the sum function are not in that final record but it seems like joining using the 'key=' option retains the variables in the sum function.  If I run the following code the two data sets do not match because of that final record, profit's final record has rev variables, profitII's final record does not have the rev variables.  Is this acting accordingly, or am I correct in thinking the extra field should not have the rev variables populated?  I'll attach the entire code in case that is helpful. data profitII; merge  dnunder (in=a)   sale2002(in=b keep=routeid flightid date rev1st revbusiness revecon revcargo); by flightid date; if a; Profit=sum(rev1st,revbusiness,revecon,revcargo,-expenses); run; Thanks, Mark ... View more