One strongly suspects something in your data set named companys. Either their are missing values or the variable names are spelled differently than you used in the template.
I also would suggest running your Sgrender code without any macro variables.
dynamic year="&year;"; /* Pass the year to the template */
Do you need the semicolon in the quotes? I suspect that's an issue. You may not even need quotes if it's defined as numeric value. EDIT: You do need the quotes though.
dynamic year="&year";
One strongly suspects something in your data set named companys. Either their are missing values or the variable names are spelled differently than you used in the template.
I also would suggest running your Sgrender code without any macro variables.
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 25. 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.