topic concetenate stringr and variable to generate a new variable in SAS Programming

concetenate stringr and variable to generate a new variable

Sir_Highbury — Wed, 22 Feb 2017 16:24:11 GMT

Dear experts,

I have a variable called as follows:

%let date=200907;

And a table containing the following variables:

AA_200901, AA_200902, AA_200903, AA_200904, B, C, D

In the proc sql; I would like to select:

B, C, D and AA_+&date.

Any idea on how to do it? I would like to keep it as simple as possible.

Thanks a lot in advance. SH

Re: concetenate stringr and variable to generate a new variable

collinelliot — Wed, 22 Feb 2017 16:29:29 GMT

I guess I don't understand the issue, because it seems like your %let gives you what you want:

This:

%let date=200907;

proc sql;

CREATE TABLE want AS

SELECT b, c, d, aa_&date

FROM have;

quit;

Will give you this:

proc sql;

CREATE TABLE want AS

SELECT b, c, d, aa_200907

FROM have;

quit;

Is that not what you want?

Re: concetenate stringr and variable to generate a new variable

anoopmohandas7 — Wed, 22 Feb 2017 16:32:39 GMT

Hope the below helps.

%let date=200907 ;

data have ;
input AA_200901 $ AA_200902 $ AA_200907 $ ;
datalines ;
TES LO WE
;
run ;

proc sql ;
select AA_&date.  as test1 
from have ;
quit ;