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;
Thank you. I missed RUN after ENCOMP. Now it can run
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
Thank you. I missed RUN after ENCOMP. Now it can run
@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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.