About CPAZ

kritima · ‎10-08-2016

Hello Sunjay, I did as your instruction. But i strugged on Error transcode as picutre below. And i try to use another Non-space-breaking but it's not work. Would you mind to suggest?

GraphGuy · ‎07-03-2014

One other possible alternative that could work in 9.3 - if you could rewrite your graph using SAS/Graph procs, that will allow you to manually create your drilldown string, and include whatever html tags you want (including target=).

SveinE · ‎09-13-2013

Sorry, forget about this %nrstr suggesting. In this contex it did not work. Maybe this will do: %if &c = 1 %then %do; /* if I find a specific column, then execute macro prodrow_lookup */ *call execute('%prodrow_lookup(prod=&&&v)'); %prodrow_lookup(prod=&&&v); %put **** returnCode = &returnCode; /* print the output of prodrow_lookup */ %end;

Vince28_Statcan · ‎07-25-2013

Try using title move=(x,y) "Normality Test - &tname2" font="Calibri"; /* replace x,y until you find a positioning that suits your need. */ I can't figure out what scale x and y are using but anyway it should do the trick with some trial and error. Vincent

gvsunick · ‎03-27-2013

The data source has to be a registered data file on the SAS meta server. You can't use local work datasets.

SASKiwi · ‎11-18-2012

The usual way to force a database connection is to use the NOPROMPT option. This is how you do it via a CONNECT statement if you are using ODBC to connect to SQL Server and are using Windows authentification, assuming your SAS server runs on Windows: connect to odbc (noprompt = "server=MySQLserver;DRIVER=SQL Server;Trusted Connection=yes;DATABASE=Mydatabase;" readbuff = 32767); If you want more specific help then you need to provide details of how you connect to your SQL Server database.

CPAZ · ‎11-17-2012

I have tried ODBC but with no luck. SAS technical help states the only way to connect is with SAS/ACCESS to OLEDB. It has built in functionality for MSOLAP. Thanks.

FriedEgg · ‎04-18-2012

LOL, Specifically I was referring to the following ominous piece of the documentation for SAS under the POKE<LONG> Call routine: CAUTION:The CALL POKE routine is intended only for experienced programmers in specific cases. If you plan to use this routine, use extreme care both in your programming and in your typing. Writing directly into memory can cause devastating problems. This routine bypasses the normal safeguards that prevent you from destroying a vital element in your SAS session or in another piece of software that is active at the time. http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000127816.htm That was very funny though

Tom · ‎08-18-2014

Perhaps you need to redesign your program. Why are you using macro language to open the dataset anyway? Can you convert that logic to normal SAS code instead. In practice SAS will normally just assign integers 1,2,3,etc to the file handles. If your SAS sessions is still open then you might just try brute force to close it. data _null_; do dsid=1 to 256; rc=close(dsid); end; run;

CPAZ · ‎09-14-2011

Thanks, I know abut the reset statement, all this does is reset the index back to an appendage of 1. Here is my current output. In this case it was the fifth time I ran the code in the same session, so it appends 5. I gues I can always reset it back to 1 and use it that way for my future html code. Thanks, Chris

CPAZ · ‎07-27-2011

Hi, I have SAS EM installed on a server, EGUIDE installed on my PC with a profile setup run all EGuide stuff on the server. I also have predictive modeler installed on the server. Question is how do I install the interface in EGUIDE? EGUIDE: 4.3 EM: 6.2 Thanks for any help, Chris

twocanbazza · ‎07-06-2011

Does using "Tools->Project Maintenance " do what you want? I think you can "replace" a server for the project Barry

ChrisHemedinger · ‎05-12-2011

Yes, if you use SAS/ACCESS to ODBC to define a SAS library to access the table. Otherwise, you have to use File->Open->ODBC -- and that pulls all of the data into your session via the EG client. That can be slow for large data. Chris

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: ODS Graphics imagemap target='_blank'

ODS Graphics imagemap target='_blank'

Returning a value from another macro from within a macro

ODS HTML and PROC UNIVARIATE Histogram not showing correct title

Dynamic Prompt using generated dataset in WORK library as data source

Scheduled job with OLAP connectivity

Re: Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS in...

Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS interf...

Re: Stacked, Grouped Bar Chart with Multiple Y2-Axis lines

Re: Stacked, Grouped Bar Chart with Multiple Y2-Axis lines

Re: taking a single string and converting that to single column in tab...

Re: taking a single string and converting that to single column in tab...

Re: taking a single string and converting that to single column in tab...

Re: Stacked, Grouped Bar Chart with Multiple Y2-Axis lines

Re: ODS Graphics imagemap target='_blank'

Re: Returning a value from another macro from within a macro

Re: ODS HTML and PROC UNIVARIATE Histogram not showing correct title

Re: Dynamic Prompt using generated dataset in WORK library as data sou...

Re: Scheduled job with OLAP connectivity

Re: Accessing Microsoft OLAP cubes (server side) without SAS/ACCESS in...

Re: taking a single string and converting that to single column in tab...

Re: %sysfunc(open) causes table to be locked if error occurs

EGUIDE and ODS

Rapid Modeler interface install in EGUIDE 4.3

Re-Assigning a Server from Local with already saved program

Re: Query Builder in 4.3 and ODBC connectivity