It's taken me a while to figure out what was going on, but I have proc report code that was generating tons of messages that said
WARNING: Illegal argument to function
Turns out I was using leading_zero='yes' option on my msoffice2k_x tagset and it generates the warning when a variable has a missing value. Perhaps not for all variables but at least presumably for those which could have a leading zero. Consider the code.
data temp ;
input Var1 $2. ;
datalines ;
00
01
00
00
;
run ;
ods tagsets.msoffice2k_x file="Temp.xls" style = sasweb
options(leading_zero="yes") ;
proc report data=temp nowd missing ;
columns var1 ;
run ;
ods _all_ close ;
It generates one such message. However when I ran it on the real code I was using it generated enough messages that I had to break out of it. Any way around it?
I'm running SAS 9.3 on a Windows 64 server.
thanks,
Steve
Steve, this was an issue that was corrected with the latest version of the tagset. I hope to have it posted on the web for download in the next week. I can also forward you a copy.
Thanks,
Chevell
Steve, this was an issue that was corrected with the latest version of the tagset. I hope to have it posted on the web for download in the next week. I can also forward you a copy.
Thanks,
Chevell
Thanks Chevell,
I would appreciate a copy.
It appears that I can also use htmlstyle=mso-number-format as well. Don't know if one is preferable to another except using the tagset is easier to understand and use.
Steve
Yes, you can use the htmlstyle= as well as you mentioned and can handle various other style issues that arise, however, the optionss was added just for convenience.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.