Hi, there To set up an ODBC Data Source, select the Start Menu, click on Settings Æ Control Panel and choose Administrative Tools. From there, choose Data Sources (ODBC). This will open the Data Source Administrator. See You ... View more

ods excel file="YOURS.xlsx" options(sheet_label="Column" ); ... View more

Hi,   ODS excel file= "~/YOURS.xlsx" ; proc report data=DB.TABLE nowd ; column name VALUE; define CITY/ "" display style={cellwidth=3.0in}; define POPULATION/ "" display style={cellwidth=3.0in}; compute CITY; if age LESS 50000 then call define(_row_,"Style","Style={background=BLUE}"); end comp; run; ... View more