assign macro variable output of tranwrd in macro function
I can't figure out this seemingly trivial problem - expect macro variable to be assigned mpg_city.
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, 'extra_', ''));
%put &id;
%mend test;
%test(col=extra_mpg_city);
Current output is extra_mpg_city.
sas
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
add a comment |
I can't figure out this seemingly trivial problem - expect macro variable to be assigned mpg_city.
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, 'extra_', ''));
%put &id;
%mend test;
%test(col=extra_mpg_city);
Current output is extra_mpg_city.
sas
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
Also, if you're just creating macro variables you should look into adata _null_step andCALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.
– Reeza
Nov 21 '18 at 23:48
1
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --%local id;
– Richard
Nov 22 '18 at 0:04
add a comment |
I can't figure out this seemingly trivial problem - expect macro variable to be assigned mpg_city.
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, 'extra_', ''));
%put &id;
%mend test;
%test(col=extra_mpg_city);
Current output is extra_mpg_city.
sas
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
I can't figure out this seemingly trivial problem - expect macro variable to be assigned mpg_city.
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, 'extra_', ''));
%put &id;
%mend test;
%test(col=extra_mpg_city);
Current output is extra_mpg_city.
sas
sas
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
asked Nov 21 '18 at 22:23
CPakCPak
9,4241723
9,4241723
Also, if you're just creating macro variables you should look into adata _null_step andCALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.
– Reeza
Nov 21 '18 at 23:48
1
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --%local id;
– Richard
Nov 22 '18 at 0:04
add a comment |
Also, if you're just creating macro variables you should look into adata _null_step andCALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.
– Reeza
Nov 21 '18 at 23:48
1
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --%local id;
– Richard
Nov 22 '18 at 0:04
Also, if you're just creating macro variables you should look into a
data _null_ step and CALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.– Reeza
Nov 21 '18 at 23:48
Also, if you're just creating macro variables you should look into a
data _null_ step and CALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.– Reeza
Nov 21 '18 at 23:48
1
1
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --
%local id;– Richard
Nov 22 '18 at 0:04
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --
%local id;– Richard
Nov 22 '18 at 0:04
add a comment |
2 Answers
2
active
oldest
votes
Arguments listed in a function invoked through %sysfunc are implicitly text and should not be quoted. Placing quotes in a sysfunc invoked function is like nesting quotes in a DATA step invocation.
Try
%let id = %sysfunc(tranwrd(&col, extra_, %str()));
The DATA Step analog is
id = tranwrd("&col", "extra_", "");
Your original code in DATA Step analog (below) should show why the tranwrd did not operate as you expected.
id = tranwrd("&col", "'extra_'", "''");
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
add a comment |
You don't need the quotes when using string functions with %sysfunc, unless you expect to find them in the input. Try this:
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, extra_, ));
%put &id;
%mend test;
%test(col=extra_mpg_city);
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53421284%2fassign-macro-variable-output-of-tranwrd-in-macro-function%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Arguments listed in a function invoked through %sysfunc are implicitly text and should not be quoted. Placing quotes in a sysfunc invoked function is like nesting quotes in a DATA step invocation.
Try
%let id = %sysfunc(tranwrd(&col, extra_, %str()));
The DATA Step analog is
id = tranwrd("&col", "extra_", "");
Your original code in DATA Step analog (below) should show why the tranwrd did not operate as you expected.
id = tranwrd("&col", "'extra_'", "''");
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
add a comment |
Arguments listed in a function invoked through %sysfunc are implicitly text and should not be quoted. Placing quotes in a sysfunc invoked function is like nesting quotes in a DATA step invocation.
Try
%let id = %sysfunc(tranwrd(&col, extra_, %str()));
The DATA Step analog is
id = tranwrd("&col", "extra_", "");
Your original code in DATA Step analog (below) should show why the tranwrd did not operate as you expected.
id = tranwrd("&col", "'extra_'", "''");
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
add a comment |
Arguments listed in a function invoked through %sysfunc are implicitly text and should not be quoted. Placing quotes in a sysfunc invoked function is like nesting quotes in a DATA step invocation.
Try
%let id = %sysfunc(tranwrd(&col, extra_, %str()));
The DATA Step analog is
id = tranwrd("&col", "extra_", "");
Your original code in DATA Step analog (below) should show why the tranwrd did not operate as you expected.
id = tranwrd("&col", "'extra_'", "''");
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
Arguments listed in a function invoked through %sysfunc are implicitly text and should not be quoted. Placing quotes in a sysfunc invoked function is like nesting quotes in a DATA step invocation.
Try
%let id = %sysfunc(tranwrd(&col, extra_, %str()));
The DATA Step analog is
id = tranwrd("&col", "extra_", "");
Your original code in DATA Step analog (below) should show why the tranwrd did not operate as you expected.
id = tranwrd("&col", "'extra_'", "''");
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
answered Nov 21 '18 at 22:34
RichardRichard
8,45721227
8,45721227
add a comment |
add a comment |
You don't need the quotes when using string functions with %sysfunc, unless you expect to find them in the input. Try this:
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, extra_, ));
%put &id;
%mend test;
%test(col=extra_mpg_city);
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
add a comment |
You don't need the quotes when using string functions with %sysfunc, unless you expect to find them in the input. Try this:
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, extra_, ));
%put &id;
%mend test;
%test(col=extra_mpg_city);
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
add a comment |
You don't need the quotes when using string functions with %sysfunc, unless you expect to find them in the input. Try this:
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, extra_, ));
%put &id;
%mend test;
%test(col=extra_mpg_city);
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
You don't need the quotes when using string functions with %sysfunc, unless you expect to find them in the input. Try this:
%macro test(col=);
%let id = %sysfunc(tranwrd(&col, extra_, ));
%put &id;
%mend test;
%test(col=extra_mpg_city);
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
answered Nov 21 '18 at 22:29
user667489user667489
7,93221227
7,93221227
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53421284%2fassign-macro-variable-output-of-tranwrd-in-macro-function%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Also, if you're just creating macro variables you should look into a
data _null_step andCALL SYMPUTX(). IMO it's usually a lot easier than messing around with macro functions. In general, you don't want to have too many macros cluttering your code it makes it harder to debug.– Reeza
Nov 21 '18 at 23:48
1
Best practice is to ensure your macro variables are localized within the macro (unless your coding design is working with global variables or within a framework) --
%local id;– Richard
Nov 22 '18 at 0:04