SAS: How to repeat calculation and change values?
For the following data, I want to create several new variables that combine Australia and Canada with different weights. In total, I would like to examine 10 different weight combinations.
Is there a way to do this where I can use the one formula and just change the weight values?
For example, rather than calculate Weight_1 to Weight_etc, can I just list the weights I want and then create the variables based on this list?
data Weighted_returns; set returns;
Weight_1 = (Australia*0.6)+(Canada*0.4);
Weight_2 = (Australia*0.5)+(Canada*0.5);
Weight_3 = (Australia*0.4)+(Canada*0.6);
run;
sas sas-macro
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
add a comment |
For the following data, I want to create several new variables that combine Australia and Canada with different weights. In total, I would like to examine 10 different weight combinations.
Is there a way to do this where I can use the one formula and just change the weight values?
For example, rather than calculate Weight_1 to Weight_etc, can I just list the weights I want and then create the variables based on this list?
data Weighted_returns; set returns;
Weight_1 = (Australia*0.6)+(Canada*0.4);
Weight_2 = (Australia*0.5)+(Canada*0.5);
Weight_3 = (Australia*0.4)+(Canada*0.6);
run;
sas sas-macro
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
add a comment |
For the following data, I want to create several new variables that combine Australia and Canada with different weights. In total, I would like to examine 10 different weight combinations.
Is there a way to do this where I can use the one formula and just change the weight values?
For example, rather than calculate Weight_1 to Weight_etc, can I just list the weights I want and then create the variables based on this list?
data Weighted_returns; set returns;
Weight_1 = (Australia*0.6)+(Canada*0.4);
Weight_2 = (Australia*0.5)+(Canada*0.5);
Weight_3 = (Australia*0.4)+(Canada*0.6);
run;
sas sas-macro
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
For the following data, I want to create several new variables that combine Australia and Canada with different weights. In total, I would like to examine 10 different weight combinations.
Is there a way to do this where I can use the one formula and just change the weight values?
For example, rather than calculate Weight_1 to Weight_etc, can I just list the weights I want and then create the variables based on this list?
data Weighted_returns; set returns;
Weight_1 = (Australia*0.6)+(Canada*0.4);
Weight_2 = (Australia*0.5)+(Canada*0.5);
Weight_3 = (Australia*0.4)+(Canada*0.6);
run;
sas sas-macro
sas sas-macro
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
asked Nov 28 '18 at 0:35
wazza2013wazza2013
797
797
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
DATA Step does not have any sort of vector math syntax. You can use one array to arrange and reference the target variables and another to hold the weights.
Your result variables weight* would be a little conflicting with an array of weights, so I named the result variables result*
data have;
input australia canada;
datalines;
0.07 0.08
0.02 -0.001
0.05 0.01
run;
data want;
set have;
array results result_1-result_3;
array weights (3) _temporary_ (0.6 0.5 0.4);
do _n_ = 1 to dim(results);
results(_n_) = australia * weights(_n_) + canada * (1 - weights(_n_));
end;
run;
Use two weight arrays if the transformation is such that the sum of the weights to apply are not unity.
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
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%2f53510387%2fsas-how-to-repeat-calculation-and-change-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
DATA Step does not have any sort of vector math syntax. You can use one array to arrange and reference the target variables and another to hold the weights.
Your result variables weight* would be a little conflicting with an array of weights, so I named the result variables result*
data have;
input australia canada;
datalines;
0.07 0.08
0.02 -0.001
0.05 0.01
run;
data want;
set have;
array results result_1-result_3;
array weights (3) _temporary_ (0.6 0.5 0.4);
do _n_ = 1 to dim(results);
results(_n_) = australia * weights(_n_) + canada * (1 - weights(_n_));
end;
run;
Use two weight arrays if the transformation is such that the sum of the weights to apply are not unity.
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
add a comment |
DATA Step does not have any sort of vector math syntax. You can use one array to arrange and reference the target variables and another to hold the weights.
Your result variables weight* would be a little conflicting with an array of weights, so I named the result variables result*
data have;
input australia canada;
datalines;
0.07 0.08
0.02 -0.001
0.05 0.01
run;
data want;
set have;
array results result_1-result_3;
array weights (3) _temporary_ (0.6 0.5 0.4);
do _n_ = 1 to dim(results);
results(_n_) = australia * weights(_n_) + canada * (1 - weights(_n_));
end;
run;
Use two weight arrays if the transformation is such that the sum of the weights to apply are not unity.
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
add a comment |
DATA Step does not have any sort of vector math syntax. You can use one array to arrange and reference the target variables and another to hold the weights.
Your result variables weight* would be a little conflicting with an array of weights, so I named the result variables result*
data have;
input australia canada;
datalines;
0.07 0.08
0.02 -0.001
0.05 0.01
run;
data want;
set have;
array results result_1-result_3;
array weights (3) _temporary_ (0.6 0.5 0.4);
do _n_ = 1 to dim(results);
results(_n_) = australia * weights(_n_) + canada * (1 - weights(_n_));
end;
run;
Use two weight arrays if the transformation is such that the sum of the weights to apply are not unity.
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
DATA Step does not have any sort of vector math syntax. You can use one array to arrange and reference the target variables and another to hold the weights.
Your result variables weight* would be a little conflicting with an array of weights, so I named the result variables result*
data have;
input australia canada;
datalines;
0.07 0.08
0.02 -0.001
0.05 0.01
run;
data want;
set have;
array results result_1-result_3;
array weights (3) _temporary_ (0.6 0.5 0.4);
do _n_ = 1 to dim(results);
results(_n_) = australia * weights(_n_) + canada * (1 - weights(_n_));
end;
run;
Use two weight arrays if the transformation is such that the sum of the weights to apply are not unity.
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
answered Nov 28 '18 at 1:11
RichardRichard
9,47221329
9,47221329
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%2f53510387%2fsas-how-to-repeat-calculation-and-change-values%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
