topic preserving (or adding single 'quotes') around a computed macro rolling date variable in SAS Programming

preserving (or adding single 'quotes') around a computed macro rolling date variable

SASguyCO — Wed, 06 Feb 2013 19:21:15 GMT

All-

Due to the way our database is set up, I need to pull a weeks worth of data at a time in the format 'YYYY-MM-DD' and it has to be enclosed in single quotes. I've never been really good at the whole reading or not reading those strange characters with macro variables so I thought I'd ask the experts! I'm fairly certain this is an easy solution.

Here is what I have so far. This gives me the two macro date variables &date1 and &date2. However, I need to have single 'quotes' around them so that it resolves to '2013-01-28' and '2013-02-03' respectively. I know I can't just put single quotes '&date1' and '&date2' like such but I'm not sure how to go about this. Your input is always really appreciated!

%let datem=today();

data _null_;

date1=put(intnx('week.2',&datem,-1,'b'),yymmddd10.);

date2=put(intnx('week.2',&datem,-1,'e'),yymmddd10.);

call symputx('date1',date1);

call symputx('date2',date2);

run;

%put &date1 &date2;

Re: preserving (or adding single 'quotes') around a computed macro rolling date variable

DBailey — Wed, 06 Feb 2013 19:26:51 GMT

%let datem=today();

data _null_;

date1=put(intnx('week.2',&datem,-1,'b'),yymmddd10.);

date2=put(intnx('week.2',&datem,-1,'e'),yymmddd10.);

call symputx('date1',"'"||date1||"'");

call symputx('date2',"'"||date2||"'");

run;

%put &date1 &date2;

Re: preserving (or adding single 'quotes') around a computed macro rolling date variable

SASguyCO — Wed, 06 Feb 2013 20:02:17 GMT

Works like a charm! Thanks so much for the quick reply.