topic Re: Using a Macro Variable inside a proc export in SAS Programming

Using a Macro Variable inside a proc export

sgtrun — Wed, 21 Jun 2017 18:27:53 GMT

I am trying to create a sequence number to be placed at the end of a file name for a proc export.

Work.seq_nbr will contain the number I want to start with and then the datastep increment will increment that number by one and put a leading zero before it. If the seq_nbr starts off at say 270 then I want 0271 to be &seq_nbr_pad in my proc export.

I just can't figure out how to make it a macro variable in my datastep or I need help in finding a way to do this.

data increment(keep=seq_nbr_pad);

length seq_nbr_txt $ 4 seq_nbr_pad $ 4;

set work.seq_nbr;

/* read charvar as number, then format with leading zeroes */

/* then put result into padded */

seq_nbr = seq_nbr+1;

seq_nbr_txt = put(seq_nbr,4.);

seq_nbr_pad = put(input(seq_nbr_txt,best4.),z4.);

%let seq_nbr=seq_nbr_pad;

run;

PROC EXPORT

DATA=increment

OUTFILE="\\Home1\userid\GMF_&SEQ_NBR_PAD..csv"

DBMS=CSV REPLACE;

RUN;

Re: Using a Macro Variable inside a proc export

Astounding — Wed, 21 Jun 2017 18:53:51 GMT

%LET can't be part of a DATA step. Here's an alternative method to create your macro variable:

data _null_;

set work.seq_nbr (keep=seq_nbr);

call symput('seq_nbr_pad', put(seq_nbr+1, z4.));

run;

Re: Using a Macro Variable inside a proc export

ballardw — Wed, 21 Jun 2017 18:58:55 GMT

Are you actually going to export the exact same data set to multiple files? Unless you change your Increment data set that will be the likely effect.

Re: Using a Macro Variable inside a proc export

sgtrun — Wed, 21 Jun 2017 18:59:09 GMT

Works perfectly. Thank you so much.