I definitely share everyone's frustration with this. In my experience, whenever I use the "Program Maintenance" function to change settings in a process flow (which are rather large with my projects as well), the auto-arrange setting flips back on -- annoyingly scattering my programs and results around the grid. And you're right on with the point about valuable time. I spend much of my time putting things back in order after this.
... View more
Hi Cynthia. Apologies for the delay in response. Ultimately I'd like to just develop and format the entire report in SAS and just export it to the location I need it in. This is more of a bridge process to that point. I will, however, give your suggestion a shot -- and let you know how it goes. Much appreciated!
... View more
I'd like to export a SAS query result to an existing Excel spreadsheet on a specific sheet tab. I have a pre-formatted template in my spreadsheet on Sheet1, that is linked to a range of cells on Sheet2. Sheet2 is where I want my data to be inserted. Is there a way to do that without creating a new spreadsheet document each time? Seems like it would be simple -- but I've spoken too soon before.
... View more
I'm a new convert from Access and very green on EG. I'm trying a simple query formula where I need records from the past 60 days. The criteria in Access was simply Date()-60. What does the filter look like in a SAS EG query?
... View more