I want to add a disclaimer that pertains to the data being dicplayed in the report. In the doc I see that this is done to the localproperties xml file by adding : MyDisclaimer Is the TableandGraph populated with the name of the table and the graph I want to add the disclaimer. Or , if this is not changed, the disclaimer will be applied to all reports surfaced? even if the disclaimer I want to add is to an especific report(s)? Thanks, jp ... View more

Hi: I am trying to create a drill down and a tip to display with a stored process and proc gplot , in particular. The thing is, the drill down should output differently depending on the which bar selected. I was using the samples but I got lost when it was using a macro. Any examples? thanks, jp ... View more

Hi: question: I know that indexes are automatically built when creating , say, a FK to PK relation. And it is clear that indexes allow for the enforcement of rules when incoming rows are getting updated or coming in. My question is if having a FK to PK relation will increase performance when querying versus having plain indexes in both tables without IC. If there is a performance increase that the table with the FK does not need to consult its index but uses the PK index? Is there any performance boost when having IC as opposed to simple indexes? Thanks jp ... View more

I want to search through a bunch of sas programs and find one word strings. The ouput dataset called found contains the job that has the matching string. This is one way I approached it but get stock when trying to output or using the filevar: I created a proglist text file that contains all my programs ( more than a 100) which I loaded them into a sas data set named progs. I take this progs set and data progs; infile proglist; input @1 program $88.; run; filename name '/dir/'; data found; set progs; prog = '/dir/'||program; infile name filevar=prog end=done; do while (not done); if index(_INFILE_, "FINDTHIS") > 0 then do; found = 1;output; end; end; run; ... View more

How could I ftp a file sequentially. FOr example: First job run outputs file1.1.csv 2nd time output file1.2.csv 3rd time 1.3.csv ..... 1.x.csv ... View more

I have a stp that outputs in Excel. One type of character value that it outputs is MAR2011. Eventhough this is character , Excel transforms this into a date of Mar/20/2011. Is there a way to output an STP in text ? Or someway for the character value not to be converted into this Excel date? code in STP: proc sql; select column_name label = '00'x /*no column headers* from table A quit; ... View more