I need to do a running count.  How do you do this in SAS Enterprise Guide 4.3?  I need specifics as I am fairly new to this tool.  Thank you. ... View more

I created a user defined link.  How do I edit the link so it is using the correct linking fields?  Can you join one query to another using a calculated column.  I am sure there is a way to do this but due to my lack of experience using SAS Enterprise Guide, I am at a loss.  I created these two queries and now I want to join them using a calculated column. Maybe if I explain more of what I am trying to do, someone can point me in the right direction.  I bring in 4 oracle tables.  I take each table and filter what I need and run the query for each table. Now I want to take the results from each table and join them with the appropriate joining fields.  I did export the results of each of the tables and them brought them back in and joining to one of the results query.  That works but there must me a better way. ... View more

I have SAS Enterprise Guide 3.4.  I am trying to change the date format to 1/1/2013.  Every format I pick the results are ********.  Is there another place to change the date format to 1/1/2013 -  MMDDYYYYY ... View more

I have some date fields in an Oracle table that I am trying to filter on in Enterprise Guide 4.1.  The dates come in with date and time.  I want to reformat the fields (maybe create a new column) to get rid of the time portion of the date field.  I don't know the syntax to do this. The filtering on the date field goes something like this: Eff_frm_Dt <= current date Eff_to_Dt is missing or eff_to_Dt >= current date For current date I have been using intnx('day',date(),0) When I use the above filter on the date fields, I get no results. When I remove the filtering, I get results but I need to be able to filter on the dates. Since the date comes in as date and time, I thought I should reformat the date field to remove the time portion creating new columns.  Then use those columns to filter on.  ... View more