Relative Content

Tag Archive for sas

SAS Proc Report variable columns

I am trying to automate a daily report using Proc Report (instead of Excel). The report is a running 8-day report with the dates being the column names. How do I reference the date columns in the COLUMN and DEFINE statements, so that I can format the cell values?

Find a number in a list that is closest to another number

I have some sample data below and I need to find the scenario where the value is closest to but no greater than 94,000,100. The answer would be 12. How do I accomplish this in SAS? This is a piece of code within a large SAS program. Any input is greatly appreciated!