Hi Team,
I want to create hyperlink on a column values (example: proc contents output) to find within the pdf document.
example: Contents table
varname type
NAME CHR
SEX CHR
AGE NUM
HEIGHT NUM
In the above example, I want to create hyperlinks on the "varname" column which will take me to the pdf page where the name variable or value present within the pdf document.
Regards,
VJ
... View more
Hi Snoopy, Once again thank you for your input. Issue got resolved. We created the stored proc and call it from SAS sql. Thank you, Vijay
... View more
Hi Snoopy, Thank you for your response. I am getting error for both the statements. I tried even using %bquote. But, didn't work either. For the first statement The error msg is " ORA 00922 missing or invalid option". second the error msg is " ORA 06550 execute error" The second statement was execute(declare dte date:=('&1', 'DDMMYYYY') by ORACLE; Vijay Message was edited by: Vijay Kumar
... View more
Hi , I want to pass the Oracle option "set serveroutput off" from SQL SAS pass through.and another declare the variable Like: Proc sql; connect to ORACLE (user=&usr pw=&pw); execute(set serveroutput off) by ORACLE; execute( dte date:=('&1', 'DDMMYYYY')) by ORACLE; disconnect from ORACLE; quit; But it is throughing error. Please help me how I can execute the above steps. Thanks in advance.
... View more