Thanks Sanjay. This worked: XAXIS DISCRETEORDER=DATA. For splitting the graph, I used your suggestion of using a by statement. Proc sgplot split the chart as desired, but included the building ids with missing data depending on the group. So the second half of the first chart is a list of the group 2 buildings with no data. Also, I would want to suppress the group=1 notation in the title as this has no meaning to user.
... View more
I'd like to show my data (percentages of building performance 0-100%) in a vertical bar chart. The x-axis is the building ID number and so proc sgplot is ordering the x-axis by the ID number, but I'd like to order the bars in ascending order. Is there an ascending option in proc sgplot? Also, I have a large chart and I'd like to split into two charts. Is there a way to do this so that exactly half of the data fits onto one chart and the other half onto another chart? Or will I need to tell SAS the Building ID numbers I want on chart 1 and those I want on chart 2? Thanks!
... View more
Thanks Dan. Your answer made me realize that I need help with proc transpose more than the plotting procedures. I do not get the dataset I want when I do proc transpose data=have out=want; id building; var _all_; run; Can you suggest a better way to transpose than I have?
... View more
I would like to create a horizontal bar chart that charts time in days. The x-axis would be total days. The bars would be the sum of 4 different times or phases, and color coded by phase. For example, building S3677 below would have a bar totaling 215 days, with each phase color coded within that bar. The data is formatted like this: Building phase1 phase2 phase3 phase4 S212 201 165 35 46 O254 198 144 120 58 S3677 100 25 36 54 Any suggestions? Thanks.
... View more
Thanks Anca, this worked well. However, the City column shows the variables as Chicago, Chicago1 Chicago2, DC, DC1, DC2, etc. Is there a way to get rid of the _# after the city?
... View more
Hi All, I have a dataset from my client that I need to reformat so that I can do some analysis and create some reports with it. It is in Excel in the following structure: Chicago DC Building 25156 54885 2665 Phase 1 5/27/2011 7/5/2012 3/30/2012 Phase 2 6/30/2011 8/10/2012 4/4/2012 Phase 3 7/15/2011 8/1/2012 4/11/2012 Time from Phase 1 to Phase 3 18 25 12 I want it in this format (I will calculate the time in days myself) Building Phase 1 Phase 2 Phase 3 City 25156 5/27/2011 6/30/2011 7/15/2011 Chicago 54885 7/5/2012 8/10/2012 8/1/2012 Chicago 2665 3/30/2012 4/4/2012 4/11/2012 DC Thanks!
... View more
I'd like to create a graph in a PDF that links to other tables in the same file. For example, if the 1st graph on page 1 of the PDF is total sales data for 4 regions, I want each region in that chart to link to a separate data table for that region in the same PDF file. Any suggestions?
... View more
Hi Reeza, I get the following error when I run the libname statement. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. I googled it, and found that I need to download and install Microsoft's Data Connectivity Components, which I have done. I'm running SAS 9.3 on a Windows 7 machine. That download should have fixed it, correct?
... View more
Thanks Cynthia. Is there any way to merge the cells labeled Day1-Day12. I'd either like to keep those cells blank or label it "Length of time in days." thanks!
... View more
I have SAS 9.3 installed, but SAS seems to ignore the sheet= statement because the resulting dataset 'test' is made up of data from the first sheet in my excel file. Any idea how to fix this? PROC IMPORT OUT=work.test FILE='C;\user\test.xlsx' DBMS=EXCEL REPLACE; sheet='sheet4'; getnames=yes; RUN;
... View more
I'd like to create something like the chart below, where there is a table with data on the left and something like a horizontal bar chart on the right. The boxes represent days and each stage of the building process is charted. For instance, building 1201 had the longest Stage 1 time (of 10 days) and Permitting took 5 days at building 2215. Building # Address Data Type Time to Build – Length of Time (in Days) 1201 1111 Water Street TS Office 1578 12 Spring Street HV Residential 1785 1526 Fern Avenue TS Office 2215 2900 Wayne Street TF Office Negotiation Stage 1 Stage 2 Permits I looked online and Robert Allison's horizontal bar chart comes the closest: http://robslink.com/SAS/democd32/survey.htm I just need to add 3 columns of data to the left. Any suggestions? Or, could I use proc tabulate or proc report to shade in the length of time data?
... View more
