I am using query builder and would like to use a counter for duplicate fields   600277 600277 600277   Would like the column next to this to have 1,2,3   Is there a way to do this?   I am very much a beginner at this   ... View more

Hey folks I am have read and tried many of the suggestions for the time between 2 dates excluding weekends and have been unsuccessful.   I am a beginner SAS user and all of my data has been done in query builder.  I have a min date and a max date and I am looking at getting the difference between the dates excluding weekends.    Can this be done in query builder?  I do not want to have to export to excel to do this.   Thanks for any help you can provide.     ... View more

I am trying to add a "Case When" statement to my table with contains.  I have 2 stings that are alike and it calculates both.  How do I distinguish   1)  Review and Discussion 2)  Review and Discussion Client   Thanks   ... View more

I am trying to add days to a date field if another column meets a criteria of Yes.   I am doing this in enterprise guide.    if the column has Yes than add 30 days to the date field column.     Any suggestions?   ... View more