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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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: