Reading Parameter Midword

ccaudillo100 — Mon, 12 Dec 2022 15:36:23 GMT

Hello,

Currently I am trying to plug in the parameter midword and was wondering if anyone had any advice. I will attach the code below

%Let Num = 2

Proc SQL; 
Create Table Test as 
Select Name&NumFull,
Year&NumLast
From xx;
Quit;

Ideally the columns that would be selected would be Name2Full and Year2Last.

Currently this is not working and it just trying to pull columns with the same exact names typed. I have tried " " and ' ' around them and it does not work. Any advice would be much appreciated.

Re: Reading Parameter Midword

PeterClemmensen — Mon, 12 Dec 2022 15:40:50 GMT

Try this instead.

This is a classic example of when to use the dot (.) de delimit macro variables. In your code, SAS looks for the macro variables &NumFull and &NumLast in the symbol tables. You want SAS to look for the macro variable &Num 🙂

%Let Num = 2

Proc SQL; 
Create Table Test as 
Select Name&Num.Full,
Year&Num.Last
From xx;
Quit;

topic Reading Parameter Midword in SAS Enterprise Guide

Reading Parameter Midword

Re: Reading Parameter Midword