Help using Base SAS procedures

Proc Export to Specific Columns

Reply
Occasional Contributor
Posts: 15

Proc Export to Specific Columns

Hi there,

I have a proc export procedure that works fine.  It deletes and replaces the adl_data tab in excel daily.  However, I would like it to delete and replace only columns B to N on this tab.  There is a formula in column A that I would like to remain.  Anybody have any ideas on how I can modify the code below???

PROC EXPORT DATA = adl

OUTFILE= "X:\SOP\adl.xlsx"

DBMS=EXCEL REPLACE;

SHEET = "adl_data";

RUN;

Ask a Question
Discussion stats
  • 0 replies
  • 266 views
  • 0 likes
  • 1 in conversation