Grab string from the last cell that isn't missing in SAS
up vote
0
down vote
favorite
HAVE is a dataset of authors on pubs:
^note that auth50 is the last variable in the dataset.
WANT is a dataset where the first and last authors for each observation ofHAVE are their own variables:
I do the following in a data step to create lastauth...
array auths {*} auth1:auth50;
do i=1 to dim(auths);
if auths{1} NE " " then firstauth = auths{1};
if auths{i} = " " then lastauth = auths{i-1};
else lastauth = auths{i};
end;
...which I thought would iteratively write over lastauth until encountering the last authX variable, but the code does not retrieve the last non-missing value. Any thoughts on what I'm misunderstanding? Thanks!
arrays loops sas data-manipulation
asked Nov 20 at 17:12
JMQ
365414
add a comment |
up vote
0
down vote
favorite
HAVE is a dataset of authors on pubs:
^note that auth50 is the last variable in the dataset.
WANT is a dataset where the first and last authors for each observation ofHAVE are their own variables:
I do the following in a data step to create lastauth...
array auths {*} auth1:auth50;
do i=1 to dim(auths);
if auths{1} NE " " then firstauth = auths{1};
if auths{i} = " " then lastauth = auths{i-1};
else lastauth = auths{i};
end;
...which I thought would iteratively write over lastauth until encountering the last authX variable, but the code does not retrieve the last non-missing value. Any thoughts on what I'm misunderstanding? Thanks!
arrays loops sas data-manipulation
asked Nov 20 at 17:12
JMQ
365414
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
HAVE is a dataset of authors on pubs:
^note that auth50 is the last variable in the dataset.
WANT is a dataset where the first and last authors for each observation ofHAVE are their own variables:
I do the following in a data step to create lastauth...
array auths {*} auth1:auth50;
do i=1 to dim(auths);
if auths{1} NE " " then firstauth = auths{1};
if auths{i} = " " then lastauth = auths{i-1};
else lastauth = auths{i};
end;
...which I thought would iteratively write over lastauth until encountering the last authX variable, but the code does not retrieve the last non-missing value. Any thoughts on what I'm misunderstanding? Thanks!
arrays loops sas data-manipulation
asked Nov 20 at 17:12
JMQ
365414
HAVE is a dataset of authors on pubs:
^note that auth50 is the last variable in the dataset.
WANT is a dataset where the first and last authors for each observation ofHAVE are their own variables:
I do the following in a data step to create lastauth...
array auths {*} auth1:auth50;
do i=1 to dim(auths);
if auths{1} NE " " then firstauth = auths{1};
if auths{i} = " " then lastauth = auths{i-1};
else lastauth = auths{i};
end;
...which I thought would iteratively write over lastauth until encountering the last authX variable, but the code does not retrieve the last non-missing value. Any thoughts on what I'm misunderstanding? Thanks!
arrays loops sas data-manipulation
arrays loops sas data-manipulation
asked Nov 20 at 17:12
JMQ
365414
asked Nov 20 at 17:12
JMQ
365414
asked Nov 20 at 17:12
JMQ
365414
asked Nov 20 at 17:12
JMQ
365414
asked Nov 20 at 17:12
JMQ
365414
365414
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
3
down vote
accepted
Check the logic carefully. You want to set the value of FIRST when FIRST is missing and set the value of LAST when the current is NOT missing.
array auths auth1-auth50;
firstauth=auths(1);
do i=1 to dim(auths);
if missing(firstauth) then firstauth = auths{i};
if not missing(auths{i}) then lastauth = auths{i};
end;
Note: The extra assignment before the DO loop is to force SAS to define the new variable since otherwise the first use will be in the IF condition. If you already have a LENGTH or other statement that defines FIRSTAUTH then the extra assignment statement is not needed.
Or skip the array and just use the COALESCEC() function to find the first value. And just reverse the order of the variables to also use it to find the last value.
firstauth = coalescec(of auth1-auth50);
lastauth = coalescec(of auth50-auth1);
answered Nov 20 at 17:33
Tom
22.5k2718
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%2f53398139%2fgrab-string-from-the-last-cell-that-isnt-missing-in-sas%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
up vote
3
down vote
accepted
Check the logic carefully. You want to set the value of FIRST when FIRST is missing and set the value of LAST when the current is NOT missing.
array auths auth1-auth50;
firstauth=auths(1);
do i=1 to dim(auths);
if missing(firstauth) then firstauth = auths{i};
if not missing(auths{i}) then lastauth = auths{i};
end;
Note: The extra assignment before the DO loop is to force SAS to define the new variable since otherwise the first use will be in the IF condition. If you already have a LENGTH or other statement that defines FIRSTAUTH then the extra assignment statement is not needed.
Or skip the array and just use the COALESCEC() function to find the first value. And just reverse the order of the variables to also use it to find the last value.
firstauth = coalescec(of auth1-auth50);
lastauth = coalescec(of auth50-auth1);
answered Nov 20 at 17:33
Tom
22.5k2718
add a comment |
up vote
3
down vote
accepted
Check the logic carefully. You want to set the value of FIRST when FIRST is missing and set the value of LAST when the current is NOT missing.
array auths auth1-auth50;
firstauth=auths(1);
do i=1 to dim(auths);
if missing(firstauth) then firstauth = auths{i};
if not missing(auths{i}) then lastauth = auths{i};
end;
Note: The extra assignment before the DO loop is to force SAS to define the new variable since otherwise the first use will be in the IF condition. If you already have a LENGTH or other statement that defines FIRSTAUTH then the extra assignment statement is not needed.
Or skip the array and just use the COALESCEC() function to find the first value. And just reverse the order of the variables to also use it to find the last value.
firstauth = coalescec(of auth1-auth50);
lastauth = coalescec(of auth50-auth1);
answered Nov 20 at 17:33
Tom
22.5k2718
add a comment |
up vote
3
down vote
accepted
up vote
3
down vote
accepted
Check the logic carefully. You want to set the value of FIRST when FIRST is missing and set the value of LAST when the current is NOT missing.
array auths auth1-auth50;
firstauth=auths(1);
do i=1 to dim(auths);
if missing(firstauth) then firstauth = auths{i};
if not missing(auths{i}) then lastauth = auths{i};
end;
Note: The extra assignment before the DO loop is to force SAS to define the new variable since otherwise the first use will be in the IF condition. If you already have a LENGTH or other statement that defines FIRSTAUTH then the extra assignment statement is not needed.
Or skip the array and just use the COALESCEC() function to find the first value. And just reverse the order of the variables to also use it to find the last value.
firstauth = coalescec(of auth1-auth50);
lastauth = coalescec(of auth50-auth1);
answered Nov 20 at 17:33
Tom
22.5k2718
Check the logic carefully. You want to set the value of FIRST when FIRST is missing and set the value of LAST when the current is NOT missing.
array auths auth1-auth50;
firstauth=auths(1);
do i=1 to dim(auths);
if missing(firstauth) then firstauth = auths{i};
if not missing(auths{i}) then lastauth = auths{i};
end;
Note: The extra assignment before the DO loop is to force SAS to define the new variable since otherwise the first use will be in the IF condition. If you already have a LENGTH or other statement that defines FIRSTAUTH then the extra assignment statement is not needed.
Or skip the array and just use the COALESCEC() function to find the first value. And just reverse the order of the variables to also use it to find the last value.
firstauth = coalescec(of auth1-auth50);
lastauth = coalescec(of auth50-auth1);
answered Nov 20 at 17:33
Tom
22.5k2718
edited Nov 20 at 19:01
answered Nov 20 at 17:33
Tom
22.5k2718
answered Nov 20 at 17:33
Tom
22.5k2718
answered Nov 20 at 17:33
Tom
22.5k2718
22.5k2718
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53398139%2fgrab-string-from-the-last-cell-that-isnt-missing-in-sas%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
