DATA Step, Macro, Functions and more

concetenate stringr and variable to generate a new variable

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 127
Accepted Solution

concetenate stringr and variable to generate a new variable

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

 

 


Accepted Solutions
Solution
‎02-22-2017 11:49 AM
PROC Star
Posts: 307

Re: concetenate stringr and variable to generate a new variable

Posted in reply to Sir_Highbury

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?

 

View solution in original post


All Replies
Solution
‎02-22-2017 11:49 AM
PROC Star
Posts: 307

Re: concetenate stringr and variable to generate a new variable

Posted in reply to Sir_Highbury

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?

 

Contributor
Posts: 44

Re: concetenate stringr and variable to generate a new variable

Posted in reply to Sir_Highbury

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 ;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 3 in conversation