Dear all, I'd like to display on a pdf first some text (my heading) and then a graph which should follow the text on the same page. Unfortunately SAS does a page break after the text and puts the Graph on a new page although I stated ods pdf startpage=no; Here is my code (I use SAS 9.2 and the graph is correctly displayed yet on the wrong page): ods pdf open; ods pdf text = "mytext"; ods pdf startpage = no; goptions device = sasprtc; proc gchart data=mydata;      vbar mynumericvalue / group = mygrouping freq = mynumber patternid = midpoint freq discrete raxis = axis1 maxsi = axis2 gaxis = axis3;      axis1 label=(h=10 angle=90 'my text') minor=none;      axis2 label=none;      axis3 label=none; run; ods pdf close; Is there anything with which I can stop SAS from putting the graph on a new page? Best wishes Eva ... View more

Dear all, I's like to create a new data set that has exactely the same fields as an existing data set. And the fields should all have the same definitions, i.e. char/num and their lengths. How can I do this? Is it possible to "copy" a dataset without its data rows? (After I have this empty new dataset I'd like to insert just one row with the values I assign.) Best wishes, Eva ... View more

Dear all, I have a proc report with a computed variable for which I need a total in the last row. options missing = ''; proc report data=mydata;      column firstfield hiddenfield myfield [some more fields];      define firstfield / display noprint;      define hiddenfield / display noprint;      define myfield / computed;      [some more fields]      compute myfield;              if firstfield eq 1 then do;                       myfield = hiddenfield;              end;              else do;                       myfield = . ;              end;         endcomp; run; The data behind this looks like this (first 2 columns - and the third column should be the computed field): the idea behind this is to suppress repeated values and sum in the total only the distinct values per firstfield = 1 firstfield hiddenfield myfield 1 92 92 0 92 0 92 1 236 236 0 236 0 236 0 236 Now when I do a rbreak the total for hiddenfield is 3*92 + 4*236. But for myfield I need the total 1*92 + 1*236. Unfortunaltely the SAS automatism does a missing value. I'd love to have the rbreak just as a sum of the myfield values. The only idea I had was using the trick of aggregating the values by temporary variables: compute before;      mytotal = 0; endcomp; compute myfield;      mytotal = myfield + mytotal;      if _break_ eq "_RBREAK_ then do;          myfield = mytotal;      end; endcomp; Does anybody know some other solution? Best wishes Eva ... View more

Dear all, my customer wants me to create a grouped bar graph where the is a line from one bar to the other from the top value of each group to the top value of the corresponding group of the next bar. Does SAS offer this kind of graph? The customer wants even a second bar graph which is also grouped but where the groups are not stacked but displayed next to each other and with a line betwwen each and a value on the line which indicates the value of the group. Best wishes Eva ... View more

Dear all, I have two Stored Processes. The first one basically displays an HTML page where the user is allowed to select parameters for his report. The report will be displayed by the second Stored Process. On the first page I have a multiselect field: <select name="myfield" multiple="multiple">      <option>all</option>      <option>first option</option>      <option>second option</option>      <option>third option</option> </select> When the user says "submit" (via an HTML button" a javascripts checks out which option has been selected by the user and writes these as a comma separated list in another input field: <input type="hidden" name="multi_myfield" value=""> (i.e. the value of this hidden field is filled with the comma separated list) The next STP has a parameter called "multi_myfield". In the second STP I use the macro facility to determine whether the selection the user has made needs to be reflected in the where statement of my data step. %let mywhere =; %if "&myfield" ne "all" %then %do;      %let mywhere = "where field_x in (&multi_myfield)"; %end; This works perfectly. The problem is that the performance is not good when the user selects "all". I had the same thing befor without the multiselect. I.e. the same HTML select as a simple drop down menue. and without the javascript. And when the user select "all" here, the performance is much better. Even if I have th HTML select field as a multiselect and klick on each option (so that I have the selection of all options) this is faster than selecting the option "all". And no, my data set does not have an index. The Javascript which writes the comma separated list is fast. The problem can't be here. So my question is if anybody has an idea why the performace is worse now. Is there maybe a hidden process when two STPs exchance the HTML multiselect field? And maybe that takes time? Best regards, Eva ... View more