Hi, I'm trying to reproduce a client graph from Excel to VA 7.3.    Y axis is numeric measure, fine. X axis is character data representing week ranges for example row 1 is “Jul 6 – Jul 12” Row 2 is “Jul 13- Jul 19”, etc. There are 82 weeks like this. The current line chart in Excel has the X axis in the order the rows occur in the spreadsheet. When I bring the data into VA it sorts alphabetically by name which isn't appropriate.   I wrote a data step to add a new character column that is W01 for week 1, W02 for week 2, etc. This creates the appropriate graph line but doesn’t give any indication that W02 is Jul 13-Jul 19. Any suggestions, apart from creating a stored process, to be able to use the fully spelled out week name on the X axis?  I’m essentially looking for something similar to the order=data option in proc freq. Other suggestions though would be fine.    ETA: Tried user-defined formats, but decided that won't work as the format will get outdated as rows are added or deleted. Tried custom sort, that was pretty cumbersome and only allows for 20-some-odd sort values.    The users are not programmers and will have to do this themselves exclusively in VA. Thanks! ... View more

Hi, I know that the default output style for EG is SAS Report and the code works fine. But when I run the same code in batch (Linux), it's failing with a message of : ERROR: The width of InstanceName is not between 1 and 115. Adjust the column width or line size. NOTE: This affects LISTING output.   Is the ODS destination of DOCUMENT the same as EGs' SAS Report?  If not, what do I use to mimic what EG is doing? I don't need the style to be LISTING. TIA! ... View more

Hi, my paper Kicking and Screaming Your Way to SAS EG is now online at http://support.sas.com/resources/papers/proceedings16/9000-2016.pdf Here is the abstract if you want to know if this paper is right for you: You are a skilled SAS® programmer. You can code circles around those “newbies” who point and click in SAS® Enterprise Guide®. And yet… there are tasks you struggle with on a regular basis, such as “Is the name of that data set DRUG or DRUGS?” and “What intern wrote this code? It’s not formatted well at all and is hard to read.” In this presentation you learn how to program, yes program, more efficiently. You learn the benefits of autocomplete and inline help, as well as how to easily format the code that intern wrote that you inherited. In addition, you learn how to create a process flow of a program to identify any dead ends, i.e., data sets that get created but are not used in that program.   Feel free to contact me with any questions.   Great seeing those of you who I met at #SASGF.  ... View more