Hello,
I'm have a problem with no highlighting in my results. I get results as expected (and yes, there is a 31Aug2022 in my dates) but nothing highlights. My code is as follows:
%let asofdt = '31Aug2022'd;
%let newfile = Newfile_data.xlsx;
ods excel file = "&newfile."
options (Sheet_Name = 'Focus_Results');
I think you are missing DEFINE statement usage options (eg. DISPLAY); Do you have a clean log?
See the modification below and try it.
define date_asof / "As of Date" f=weekdate17. width = 10 display;
define ATM_results / "ATM Results" f=comma10. width = 10 display;
I think you are missing DEFINE statement usage options (eg. DISPLAY); Do you have a clean log?
See the modification below and try it.
define date_asof / "As of Date" f=weekdate17. width = 10 display;
define ATM_results / "ATM Results" f=comma10. width = 10 display;
@A_Kh wrote:
I think you are missing DEFINE statement usage options (eg. DISPLAY); Do you have a clean log?
See the modification below and try it.define date_asof / "As of Date" f=weekdate17. width = 10 display; define ATM_results / "ATM Results" f=comma10. width = 10 display;
Bet his log has:
NOTE: Variable date_asof is uninitialized.
By default numeric variables, which include dates, would be SUMMED. Which is why with my small example data set (HINT HINT HINT @SASGeek ) of:
data work.newvals; input date_asof :date9. atm_results; format date_asof date9.; datalines; 31Aug2022 123456 01Sep2022 34555 02Oct2022 11111 ;
The result looked like the following. Please note the displayed date.
Thank you so much. Using the display worked.
To answer your question: I did have a clean log and the output looked fine, it's just that it didn't highlight.
Thank you!
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.