Hi,
In the past we’ve used a DDE to update a spreadsheet via SAS.
It gradually started failing on us and now will just not run.
Errors differ from user to user. We’ve seen everything from “Access Denied. Please contact admin” to “File is locked by another user”. Now it just causes the SAS session to freeze.
Has anyone had any issues with DDE?
... View more
Hi all,
I can't seem to find the answer to this question. Is there an option in proc sql that would dump into the log the sql procedure that was sent to the server?
I have an sql generated sql string and I want to see what is actually being sent to the server.
... View more
Hi all,
Why wont the ODS Graphics Designer recognize my mapped library or read the datasets I created in the WORK directoty?
I am using this call:
%sgdesign(refresh=Y);
%sgdesign();
... View more
Not sure where this goes but this seems like a good place.
Has anyone successfully queries, from SAS, the inbox of an Outlook email account?
... View more
Of the objects within the div created by the tagset.
I am using it to create a report similar to this http://robslink.com/SAS/democd22/tele.htm
... View more
Let me try and simplyfy,
I have the output of a proc report enclosed with ods tagsets.htmlpanel.
Is there a way i can specify, to that ods tagset, a specific alignment(left, center, right, etc...)
... View more
Hi All,
I am using the tagset.htmlpanel to crreate a dashboard report in Information Delivery Portal.
Is there a way I can control the allignment of the tagset. For instance, say I wanted to right align everything that falls within the tagset.
Thanks.
... View more
Thanks all,
As per DanH's post, I think I might have to listen to Robert and dust off the old gchart procedure. The only problem is that I ned to overlay the bars. I dont remember if gchart allows that.
... View more
Hi all,
Using a sgplot to display 3 bars. I want each bar to link to a different URL. For some reason my sgplot only creates the link for the lasst bar.
Below is my code. The 3rd bar, reponse=Handled, is the only one working.
proc sgplot data=Current_Pipeline (where=(Week_Ending_On>today()-15*7 and Week_Ending_On
vbar Week_Ending_On/ response=Created nooutline barwidth=.9 fillattrs=(color=cxA6D96A) datalabel url=urlString;
vbar Week_Ending_On/ response=StillOpen nooutline barwidth=.9 fillattrs=(color=black) datalabel url=urlOpen;
vbar Week_Ending_On/ response=Handled nooutline barwidth=.9 fillattrs=(color=cxF46D43) datalabel url=urlHandled;
yaxis display=(nolabel) ;
xaxis display=(nolabel) grid;
keylegend /location =inside position=topright noborder location=outside ;
format Week_Ending_On mmddyy5.;
run;
... View more
Here is a link to the type of heatmap. http://learnr.wordpress.com/2010/01/26/ggplot2-quick-heatmap-plotting/
Good to here GTL will get the heatmap function.
I've troed the examples above in the past and found the sizing of the scatter dots a bit messy.
... View more
