SAS Support Communities

Enterprise Guide 5.1, I'm using (and only able to use) the Export as Step in Project Wizard.  It's started adding an extra blank line at the end of the .csv file.   The result is that when I import the data into Excel I get a "(blank)" option in my slicers, which is untidy, but all my page headings and explanations of what's visible is linked to a filtered pivot table that takes a value if there's only one value in the column - the "(blank)" shows as a second option here and breaks my formulas.   I've tested the issue and I can open the .csv files in Notepad and delete the extra line, once I've done this for 7 .csv files and updated the data in Excel the issue goes away, so it looks like the issue is the export, rather than the import.    This has just started today, having been fine in the past.  The manual fix isn't practical as I'm exporting 7 files and running the process 20 times to get different data cuts, so I need a fix!   Thanks ... View more

I have a complicated setup with some data I need to pull into Enterprise Guide.  I basically get a new table created on the server each month by a process, it contains all the information created in just that month.  There is information there that relates to a huge number of entities, I'm interested in a subset of those entities only.   I need to get that subset of information for the 60 latest tables.  There's a lot of data so I can't practically pull the data from 60 tables and then filter it, I need to only pull the data I need in the first place.   Each entity has an ID, I have a table in EG that lists the IDs I'm interested in.   I have used Excel to generate SQL that will combine the tables I'm interested in, but I'm stuck when trying to filter the data at the same time.  The SQL I have is in this format:   select * from TABLE.MONTH1 union all select * from TABLE.MONTH2 union all select * from TABLE.MONTH3 etc etc etc   How can I modify the query so that it only takes values where ID is in WORK.IDs?   Thanks! ... View more

I have two servers, I have a complex process running on one server that uses data that is currently only available by importing from an Excel Spreadsheet.   It's going to become available directly on the SAS server, but on the other server.  I need to modify my process to access that data, but as I understand it I can't do that in any way other than by manually recreating my entire process flow because the two servers can't talk to each other and I can't tell a Step in a process to run on the other server without breaking it's relationship with the rest of the process.   Does anyone have any thoughts on how best to achieve the change without setting aside a couple of weeks to manually recreate the flow? ... View more

I have a process flow, it's quite complex with about 60 steps from start to finish.  Some of the steps have the same names.   The first step is to import an Excel spreadsheet, which takes about 50% of the processing time.  Then I run the process flow about 20 times, with different filters applied each time to give me different outputs.    I want to setup an Ordered List that I can run so that I can run the import once and then run everything else the 20 times through to save a load of time.   It's going to take a bit of messing around to create the list in the right order from the obvious selection menu because they're in alphabetical order and some have the same names.    Is there another way to create the Ordered List that would let me add everything, in the order it runs on my process flow, then I can just delete the first step to get what I'm after?   Thanks! ... View more

I've got a dataset that I'm exporting from EG 5.1 using the Export Wizard, it has one large percentage in one of the columns,  220831262559%   The number appears correctly in the dataset that is exported, but in the resulting .csv file it is written as ***%  This opens in Excel as text and causes a Excel to throw a wobbly when averaging the results in a Pivot Table.   Along similar lines I have a number of percentages that are coming out as 4.00E+07 or similar, these open in Excel as 40000000, which is fine, but it loses all of the resolution in the number.  So there are 10 values of 1.00E+01, and I could do with knowing what the actual numbers are so they can be compared properly.   What's going on and how do I fix it?   Cheers ... View more

I have a process that produces a large dataset.  I have to deliver the data to Excel, but cut down into different subsets.  I can do this easily enough fully automatically, however I have some statistics that I'm adding in that create rankings within each subset.  I can do this as well, but the result is I end up with around 20 different columns for each statistic that I'm asked to produce.    I'm basically being asked to identify whether an entity sits in the top 10 by whatever measure nationally, within it's sector, within it's region and a few other things.   It's all very messy.   What I would like to do is build the dataset for the whole population, with just one ranking column per statistic and then use prompts to control the population, so the data is filtered at the start and the rankings relate to just that population.  But I don't want to lose the automatic running that I have wit the first method.   Is there a way to setup a table with columns for each prompt variable and the variables for each subset of data I want to produce and then loop through the process flow so that it runs once for each subset I require using the correct prompt values?   Ideally I'd like to use Export as Step in Process to drop the results out as .csv files, but I'd like to modify the file name to reflect the prompts being applied, so I end up with 20 .csv files correctly named automatically.  I can't use any other method of outputting data as I have no write access to the SAS server, so I'm not sure this is possible.  I know if I don't tick the over-write option I'll end up with the files, just with annoying names.   Cheers!   PS - SAS 5.1. ... View more

Hello,   I have a table containing various Entities, each entity can have up to 5 reference numbers and each reference number can have an unlimited number of amounts associated with it.  So 3 columns, Entity, Reference, Amount   I want to extract a table that contains one result for each Entity and Reference combination and the largest Amount.    I've done this before using the Sort task, but I can't get it to work where I'm grouping by more than one column in the Sort.   Does anyone have any top tips?   Thanks! ... View more