When I try to do a proc metalib, I get this error: ERROR: No metadata objects found matching the specified URI. ERROR: The value TABLE is not a valid SAS name. ERROR: The value is not a valid SAS name. This is my code: proc metalib; omr (library="RF300L3"); exclude ("IMPORT_L3"); update_rule(delete); noexec; run; I have been running this code already a 100 times without any problem. And suddenly the code is not working anymore. Anybody an idea what happend? thanks! ... View more

Hello, I make a bar chart by proc gchart vbar with subgroups. The grouptotals are written in the bars (clipref). They are printed very small. I am looking for a way to make them bigger. I have tried 'goptions htext = ...' but this affects only the letters at the x-axis. There is no effect on the numbers in the graph. How can I adapt the size of the numbers within the graph? thanks Sara ... View more

lI have a startdataset in Data Integration Studio 4.21. Based on this startdataset, I make a derived dataset. For one numeric variables, I change the length. I have a numeric variable with lentgh 8 from which I want to make a numeric variable with length 5. I make a job for this. When I ran the job, I get of course a warning that the values will be truncated. (But that is not a problem for me.) When I check the properties of the derived dataset, I see that the variable has a length of 5, like I have asked. So far, so good. Now I need to move the derived dataset from Data Integration Studio 4.21 on a Windowsmachine to SAS Base 9.1 on a Unixmachine. Therefore, I use proc cport and proc cimport. This works fine except one thing. The length of the numeric variable is not 5 (as defined) but 6. I did a test. When I define 6 as length in the derived dataset, after the proc cport/cimport, the length is 7. So the length is always one more after the proc cport/cimport then before. How is this possible? How can I solve this? I guess it has something to do with the fact that I have changed the length. For an other numeric variable for which I did not changed the length, I don't see this. length is 8 before and after proc cport/cimport. ... View more

I use: SAS Base 9.1 Linux Server Interactive mode I would like to output a html-file which is later called by an other program. (This progam is not compatible with activex, so I can not use activex as device. That is why I use PNG.) In this html-file there need to be 2 things: 1) a clickable link to an other file 2) a graph I used this code: /*-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/ goptions DEV=PNG cback=white noborder; ods html file="&export_path.&GraphName._&sitename_title_2..html"; ods html text="&titlestatement"; ods html text='<a HREF="file..."> click here </a>' ods html close;ods markup    style=SASWEB   path="&export_path" (URL=NOne)   file="&GraphName._&sitename_title_2..html"    tagset=HTML4 ;   proc gplot data = ...;    where ...;    plot ...; run; ods markup close; /*-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/ The problem is that the output of the markup part overwrites the output of the html part. So i see my graph, but not my title and link. Is there a way to add (not overwrite) the output from the markup part to the html part? Something like the file is kept open and completed in stead of overwritten? Other things I have tried: a) no ods html. print link with title statement within ods markup. problem: link is not clickable. html code itself is printed literally. b) no ods markup part. proc gplot within ods html. For device PNG (or GIF), the graph is not readable. It works for activex but that I can not use because my client program is not compatible with activex. What can I do to have a clickable link and a PNG-graph in one outputfile? Many thanks! ... View more

I create a vbar with proc gchart. When I use OPTIONS DEV=activex; the output is ok, the graph is shown. (file= _webout) But when I use OPTIONS DEV=actximg; I don't get any graph in my output. The only thing I see is a white square with a little red cross and there is written 'bar chart of class'. How come and how to solve this? Thanks ... View more