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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.