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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: