How to concatenate string and numeric SAS Macro and use it in where statement
so I have a code like below
%let THIS_YEAR=2020;
%macro programall;
%do i = 2016 %to &THIS_YEAR;
%let num2 =%eval(&i-2000);
%let xxx= CAT("MP",&num2);
data t_&i.;
set table1;
where GROUP in ("&xxx");
run;
%end;
for example
when i=2016
num2 = 2016-2000;
num2 = 16;
and try to concatenate with "MP", so it should create xxx=MP16.
and try to use in where statement.
but it is causing error.
how can I create Macro Variable like "MP16"correctly, so I can use it in where clause?
Thanks
You cannot use functions in macro code, they are just treated as any other text to the macro processor. But there is no need to use a function to concatenate text in macro code. Just expand the macro variable where you want to use the text it contains.
%let xxx= MP&num2 ;
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How do I make sure my apache Ignite 2.x distributed cache puts are asynchornous
- Next: How to add commas in between words in string in Javascript
Related
Related Related
- 1
SAS How to name file with Macro Numeric and String concatenated?
- 2
How to concatenate number to string in macro?
- 3
SAS Macro, passing value as string to where clause
- 4
SAS Macro, passing value as string to where clause
- 5
SAS how to use a macro variable as a date
- 6
How to Use sas macro to sampling multiple datasets
- 7
How to i use %include to invoke a SAS macro
- 8
How to use arithmetic operators with SAS macro variables
- 9
Concatenate formatted string in macro
- 10
Concatenate formatted string in macro
- 11
Store result of numeric expression in SAS macro variable
- 12
Concatenate string using the Excel Macro
- 13
how to pass a string to a macro sas without special char
- 14
How do I use a macro variable in R? (Similar to %LET in SAS)
- 15
How to use table names that have spaces in a SAS macro?
- 16
How to write conditional where statement in SAS Proc SQL?
- 17
SAS : How to iterate a dataset elements within the proc sql WHERE statement?
- 18
SAS: Selecting string list in macro
- 19
How to concatenate numeric columns in R?
- 20
macro variable is uninitialized after %let statement in sas
- 21
SAS macro to resolve in proc sql into statement
- 22
How to use comparison operator for numeric string in mysql?
- 23
How to concatenate formatted values in SAS
- 24
How do I properly concatenate this PHP echo statement with a string and a function?
- 25
How to use/convert string defined in macro to integer?
- 26
SAS : how to test if a variable is numeric
- 27
concatenate string inside a select statement
- 28
Can I concatenate numeric constant with string in C?
- 29
Concatenate all non numeric strings in String array
Comments