topic Re: how to link to a html file in computer correctly? in SAS Programming

how to link to a html file in computer correctly?

lindamtl — Mon, 19 Feb 2024 06:24:26 GMT

hlink="C:\Business_Data_Analysis\Idataglobal\Financial project\report\"
||trim(YR_MONTH)||"_"||trim(credit_group)||".html";

I use this code to point to a html file on 'C', but ODS did not print the report. path is correct, file name is correct. Maybe the way i wrote above need adjust?

proc report data= RATE_with_crdt_v3 nowd split="/";
column yr_month credit_group churn_rate active terminated;
define yr_month/"Month" left ;
define credit_group/"Credit Group" center ;
define churn_rate/"Churn Rate" center format=percent11.2;
define active/"Active /Account Count" right ;
define terminated/"Cancelled /Account Count" right ;

compute credit_group;
hlink="C:\Business_Data_Analysis\Idataglobal\Financial project\report\"
||trim(YR_MONTH)||"_"||trim(credit_group)||".html";

call define (_col_, 'url',hlink);
call define (_col_, 'Style',
'style={flyover="Click to see '||strip(credit_group)||' report"}');
endcomp;

ODS tagsets.HTMLpanel event = column_panel (finish);
ODS tagsets.HTMLpanel event = row_panel (finish);

ODS TAGSETS.HTMLPANEL EVENT=PANEL(FINISH);
ODS TAGSETS.HTMLPANEL CLOSE;

Re: how to link to a html file in computer correctly?

Sajid01 — Tue, 20 Feb 2024 01:53:35 GMT

Hello @lindamtl
Your code needs change. Please have a look at the examples here https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_ods_examples01.htm

Re: how to link to a html file in computer correctly?

lindamtl — Tue, 20 Feb 2024 01:59:07 GMT

Thank you. I missed RUN after ENCOMP. Now it can run

Re: how to link to a html file in computer correctly?

mkeintz — Tue, 20 Feb 2024 04:09:14 GMT

@lindamtl wrote:

Thank you. I missed RUN after ENCOMP. Now it can run

Then mark your own response as the solution - no need to be shy. That way, the problem will accurately be seen as solved.