Search results for query: *

Hey I have a standard proc graph gplot, with By groups. I find it very usefull but I cannot control the naming convention. They graphs are output graph1.gif, graph2.gif etc. I want to be able to control the graph name using the by group contents, something like graph_US_AL.gif...

Hey, I make a lot of html pages and use the ODS HTML TEXT a lot. 1. Does anyone know how to remove the <p></p> from around the text it produces. 2. How can I force text into the header, eg <script>. Ive used the no_top_matter and added in the text from a file before but its very messy. I...

Hey, I am looking to make a 2d scatter plot but to use a gradient for the third dimension. Ive seen some gradients used for a proc gmap but I dont know if I can use this for a scatter??? My dataset looks like a b c x y N N is from 0 to 50, so I need 50 colors but I need it displayed as a...

proc tabulate data=xx; var amount; table amount*(n sum); run; Two Questions: 1. How can I order by the "sum"? 2. How can I display only the top ten rows ordered by the sum variable? I know I can use order=freq to order by N, but thats not what I want. Thanks, N

Hey, I have a proc tabulate with 3 cols of different vars. And I want to be able to add a single row on the top of the table that spans the entire width of the table, and I want to center text within it. Proc tabulate data=C_Data.dataplot; Var Num_Loans Customer_number total_nla_per_cust_open...

Hey, Any ideas on how to draw a gchart of freq using a continous line? This doesnt work. symbol i=join; proc gchart data=data; vbar dateyymm/freq discrete; run; If I use gplot, how do I use FREQ? Thanks, Niall

Hey, I am trying to set all the styles in my stylesheet, however I cannt set the /Box or title2, title3 etc? This is what I am trying. Tried /box=[label='<div id="boxname">blah</div>' I am using Proc template and tagattr for the rest, but I cannot find the box or titles. Thanks.... N

Hey, I want to make a table like this: E F Tot % A 2 4 6 60% B 2 2 4 40% Total 4 6 10 100% % 40% 60% 100% I have 2 class variables: Ive tried the obvious: doesnt work. TABLE CLASS1 all PCTN<CLASS2>,CLASS2*n all...

Hey, I tried all these and only one worked: 1.Using excel loses formatting, particularly when there are many tables. 2.Using css doesn't work, because it is impossible to set up an external style sheet to colour each cell of a row, (unless you set up each cell as a <div id="xx">but SAS cant do...

Hey, Thanks Chris, Ive been making Excel format those cells that I want, however when I open the file in a browser afterwards, it has lost most of the other formatting, like <center> etc... How can I use that traffic lighting and also maintain the contents of the cell (the value of the cell...

Thanks Larry, What if I only want to center a few tables? N

Hey, Whats the most simple way to center a table using the ODS HTML commands? N

Hey, I create a table say 5cells by 5cells. I can use the code below to colour the background of a column of cells however I want to colour just particular cells. (I dont want to colour on a condition of the contents of a cell). For example I want to colour the first 2 cells of the first 2...

Excels returns "Cannot find file output..xls

Why cant I use proc format in a macro I call. I keep getting errors with this? %macro R061_Key_Summary_output_Subseg(Datain=, Dataout=, Seg=, Subseg=, Provider=&ProviderText, ReportDateText=,); Data &Datain; Set &Datain; PROC FORMAT; VALUE picture p8r low - < 5 = '0009.99%' 5 - high =...