Dear SAS Community -   Please bear with me as I try to explain the situation and what I'm trying to accomplish...   Preface: Currently, I am creating new tables from old ones by converting many character fields to date fields using SAS DI Studio. I'm basically just making a new column and writing the input(old_field, yymmdd8.) and changing the format to mmddyys10. The reason I am doing this is because we want to make all the fields that have date values into a date field (They are currently character fields.). So far, everything is working as far as converting them.    Situation: When I open these new tables in SAS EG and Excel (using the SAS tab) and test them with queries and date prompts, everything is working fine. However, when I open these new tables in Brio or Access, the new fields are not converting properly into the format (mmddyys10.) that I assigned them. They are showing number values like 1,974 (or something like that) where in EG/Excel, that same value would be the correct format of something like 08/21/1998.    What I Know: I was told that when passing the data through Access and Brio, it's done through an ODBC server. Through SAS EG and other SAS modules, it's through an IOM server. I think this has something to do with it. I could be wrong...   Problem: I need these new date fields I created to transfer as date fields with the format I have assigned them into Access and Brio. How do I accomplish this? Is this something done on the backend by a person who can modify settings for the server and how data is transferred? Do I need to format my dates differently in DI Studio so they can convert properly when I open the tables in Access and Brio? Or do I have to just manually code them in Access and Brio? Or a combination of some/all of these?   Any help on the issue would be much appreciated. Thanks. ... View more

Hey all - Ok, I actually created a nice process flow that contains a few queries. I basically take a table of data, prompt the user for a value that they want to search (there are two choices) and allow them to choose a date range. These two choices - prompted value and prompted date range - are the only queries. Now, since I have two queries that are conditional on whether the user choices choice A or B, I have two reports that are visible in my process flow (**only 1 should show due to the user having to choose between A or B in the beginning**). The process flow works and the reports are great, exactly the way I want. I have one problem. When I run the process flow for choice A, the report runs but it doesn't pop up automatically. I know it runs because I can view it in the process flow and change around the date range from the prompt. The only problem is that it doesn't physically pop up on my screen. When I run choice B, everything pops up just fine - like it should. With all of that said, is there a setting I am forgetting to modify so that when I run the query, choose option A at the prompt, etc., it will auto pop-up the report that uses the option A flow? Like I said, it works fine when I choose choice B. Just to re-iterate: the report runs perfect and i get the report pop-up for choice B; for choice A, the report runs perfect but it doesn't physically show the report pop up on my screen (only in the process flow). Thanks for the help. - knadel ... View more