This is an update on the progress, or lack of, to find the way to subset date and datetime variables.  The syntax is created by a point and click interface for filtering.  For date/datetime you have to use the Advanced Filtering.  You can edit the created syntax but still must follow a non-SAS like syntax. I have been able to subset two datetime variables in a dataset but still have to manually edit the right hand portion of the selection. Not being able to subset on a date/datetime variable and comparing it to a user entered date has escaped me for now. The last I heard from SAS Support they wanted a dataset, so I sent them my code that created a test two observation, two variable dataset with a datetime and a character variable. I haven't heard from them since sending it.   If I get a useable way to do the subsetting I will post it here.  ... View more

I really appreciate you takeing the time to submit a solution.  Unfortunately the SAS Universal Viewer doesn't use SAS syntax, it is strickly point and click process to create the commands to be submitted.  You can edit it's created  syntax but it has to follow the format that I submitted with this track.  I have tried all the known proper SAS date formats including those used with various database packages.  I have a problem track on SAS support. I am hoping they  can find a solution to how to subset dates in the Universal Viewer. ... View more

The date as you presented is not recognized in the univ viewer.  I can subset using the numeric value of the date but that is such a klutzy way to do it.  If I actually have a specific date that I want to use, it has to be highlighted and then remove formating to see the value.  The syntax is created by the point and click, it can be editted but still has to conform to the viewer syntax rules.  The Universal Viewer is great to just browse a dataset and the subsetting on numeric and text is sort of straight forward.  The date subsetting, except for the numeric conversion, just doesn't work.  I do have a SAS support track on it but thought I would also reach out to anyone that may use the viewer and figured out a way to use the date without converting to the numeric value.  Thanks.  If I get a resolution I will post it here.   ... View more

I don't see where you are using DDE but with it you can use the 'select' command to navigate to specific rows and columns. Instead of the second tab command you can have DDE position to the correct cell to put the value for sales. ... View more

Without looking up the exact syntax I believe you could find which ODS object is outputting the line you don' t want then you could suppress it automatically whenever you run. ... View more