cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cool1993
‎09-28-2019
  • 20 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Inputs of a characteristic variable are included in another characteri...

by Fluorite | Level 6 in SAS Programming
‎09-28-2019 09:46 AM
‎09-28-2019 09:46 AM
Hello,   I want to determine whether CHAR2 variable is included in CHAR1 variable.   If CHAR2's inputs are all included in CHAR1, then want variable has a value of 1. Otherwise, it has a value of 0.   The data and the desired results are as follows:   Data: Obs CHAR1 CHAR2 1 A001940, A007280 . 2 A001940, A007280 . 3 A001940, A007280 A001940, A007280 4 A001940 A001940, A007280 5 A001940, A007280 A001940 6 A001940, A007280 A001940 7 A001940, A007280 A001940, A007280 8 A001940, A007280 A001940, A007280 9 A001940, A007280, A104700 A001940, A007280 10 A001940, A007280, A104700 A001940, A007280 11 A001940, A007280, A104700 A001940, A007280 12 A001940, A007280, A012160, A104700 A001940, A007280, A104700 13 A001940, A007280, A012160, A104700 A001940, A007280, A104700 14 A001940, A007280, A012160, A104700 A001940, A007280, A012160, A104700 15 A001940, A007280, A012160, A104700 A001940, A007280, A012160, A104700 16 A001940, A012160, A104700 A001940, A007280, A012160, A104700 17 A001940, A012160, A104700 A001940, A007280, A012160, A104700   Desired result: Obs CHAR1 CHAR2 want 1 A001940, A007280 . 0 2 A001940, A007280 . 0 3 A001940, A007280 A001940, A007280 1 4 A001940 A001940, A007280 0 5 A001940, A007280 A001940 1 6 A001940, A007280 A001940 1 7 A001940, A007280 A001940, A007280 1 8 A001940, A007280 A001940, A007280 1 9 A001940, A007280, A104700 A001940, A007280 1 10 A001940, A007280, A104700 A001940, A007280 1 11 A001940, A007280, A104700 A001940, A007280 1 12 A001940, A007280, A012160, A104700 A001940, A007280, A104700 1 13 A001940, A007280, A012160, A104700 A001940, A007280, A104700 1 14 A001940, A007280, A012160, A104700 A001940, A007280, A012160, A104700 1 15 A001940, A007280, A012160, A104700 A001940, A007280, A012160, A104700 1 16 A001940, A012160, A104700 A001940, A007280, A012160, A104700 0 17 A001940, A012160, A104700 A001940, A007280, A012160, A104700 0 I tried the following solution, but it doesn't apply because the order of input is different.   Want = (indexw(CHAR1,CHAR2,', ')>0); If you know the solution, please help me. ... View more

Including character inputs in a variable.

by Fluorite | Level 6 in SAS Programming
‎09-27-2019 10:14 AM
‎09-27-2019 10:14 AM
Hello,   I want to determine whether CHAR2 variable is included in CHAR1 variable.   The data and the desired results are as follows:   Data: NAME YEAR CHAR1 CHAR2 JOY 2009 A, B, C, D A, B, D JOY 2009 A, B, D A, B, D JOY 2010 A, D A, B, D JOY 2011 A, B, C, D B     Desired result: NAME YEAR INCLUDE JOY 2009 1 JOY 2009 1 JOY 2009 0 JOY 2009 1   I tried the following solution, but it doesn't apply because the order of input is different.   INCLUDE = (indexw(CHAR1,CHAR2,', ')>0); If you know the solution, please help me.     ... View more

A character variable in another characteristic variable

by Fluorite | Level 6 in SAS Programming
‎09-26-2019 08:43 AM
‎09-26-2019 08:43 AM
Hello,   I want to determine whether one character variable(Char1) is included in another character variable(Char2).   The data and the desired results are as follows:   data   NAME YEAR Char1 Char2 JOY 2011 AA AA, BB JOY 2011 BB AA, BB JOY 2012 AA AA, BB, CC JOY 2012 BB AA, BB, CC JOY 2012 CC AA, BB, CC JOY 2013 CC CC JOY 2013 BB CC   desired result   NAME YEAR Including JOY 2011 1 JOY 2011 1 JOY 2012 1 JOY 2012 1 JOY 2012 1 JOY 2013 1 JOY 2013 0   If you know how, please help me. ... View more

Creating a variable with multiple values

by Fluorite | Level 6 in SAS Programming
‎09-26-2019 07:18 AM
‎09-26-2019 07:18 AM
Hello. I want to make a variable to have multiple inputs. The data and the desired results are as follows:   Data   NAME YEAR Char JOY 2011 AA JOY 2011 BB JOY 2012 AA JOY 2012 BB JOY 2012 CC   Desired result NAME YEAR Find JOY 2011 AA, BB JOY 2012 AA, BB, CC   If you know how, please help me. ... View more

Re: one variable with multiple inputs and subset of the same input

by Fluorite | Level 6 in SAS Programming
‎09-26-2019 02:22 AM
‎09-26-2019 02:22 AM
Want   Condition 1   0 0   1 0   1 0   4 0   4 0   1 0   1 1   0 0   4 0   4 1   2 0   1 0   1 1   0 1   0 0   1 0   1 0   3 0   1 0   1 0   1 0   1 0   4 0   4 0   3 0   1 1   0 0   1 1   5 0   1 0   1 1   5 0   1 ... View more

Re: one variable with multiple inputs and subset of the same input

by Fluorite | Level 6 in SAS Programming
‎09-26-2019 02:21 AM
‎09-26-2019 02:21 AM
Thanks for your comments. I revised some points. Please check the following:   Person Person_num Year Firstyear Company Year_save Previous_year_save   Save Lag_save Want   Condition A 1 2005 1 aa aa .   aa . 1   0 A 1 2006 0 aa aa aa   aa aa 0   1 A 1 2007 0 aa aa aa   aa aa 0   1 A 1 2008 0 aa {aa, bb} aa   aa aa 0   4 A 1 2008 0 bb {aa, bb} aa   aa aa 0   4 A 1 2009 0 aa {aa, bb} {aa, bb}   aa aa 0   1 A 1 2009 0 bb {aa, bb} {aa, bb}   aa aa 0   1 B 2 2008 1 cc cc .   cc . 1   0 B 2 2009 0 dd {cc, dd} cc   cc       cc 0   4 B 2 2009 0 cc {cc, dd} cc   cc cc 0   4 B 2 2010 0 dd dd {cc, dd}   dd cc 1   2 B 2 2011 0 dd dd dd   dd dd 0   1 B 2 2012 0 dd dd dd   dd dd 0   1 C 3 2002 1 ee {ee, ff} .   {ee, ff} . 1   0 C 3 2002 1 ff {ee, ff} .   {ee, ff} . 1   0 C 3 2003 0 ee {ee, ff} {ee, ff}   {ee, ff} {ee, ff} 0   1 C 3 2003 0 ff {ee, ff} {ee, ff}   {ee, ff} {ee, ff} 0   1 C 3 2004 0 ff ff {ee, ff}   ff {ee, ff} 0   3 C 3 2008 0 ff ff ff   ff ff 0   1 C 3 2009 0 ff ff ff   ff ff 0   1 C 3 2010 0 ff ff ff   ff ff 0   1 C 3 2011 0 ff ff ff   ff ff 0   1 C 3 2012 0 ff {ff, gg} ff   ff ff 0   4 C 3 2012 0 gg {ff, gg} ff   ff ff 0   4 C 3 2013 0 ff ff {ff, gg}   ff ff 0   3 C 3 2014 0 ff ff ff   ff ff 0   1 D 4 2005 1 hh hh .   hh . 1   0 D 4 2006 0 hh hh hh   hh hh 0   1 D 4 2010 0 ii ii hh   ii hh 1   5 D 4 2011 0 ii ii ii   ii ii 0   1 D 4 2012 0 ii ii ii   ii ii 0   1 D 4 2014 0 jj jj ii   jj ii 1   5 D 4 2015 0 jj jj jj   jj jj 0   1   “Year_save” includes all companies in each year.   Previous_year_save represents the previous “Year_save” value. (“Previous” means the closest past year observation in the same “Person”.)   “Lag_save” is the lag1 variable of “Save”.   Want variable is a dummy variable.   Condition represents the logic below corresponding to the “want” value.   If firstyear = 1, then save = year_save and want = 1; If firstyear = 0 and Year_save = Previous_year_save, then save = Year_save and want = 0; If want = . and the Year_save ne Previous_year_save but Year_save is included in Previous_year_save and company is not included in lag_save, then save = Year_save and want = 1; Else if want = . and the Year_save ne Previous_year_save but Year_save is included in Previous_year_save, then save = Year_save and want = 0; If want = . and, Year_save includes Previous_year_save, then save = Previous_year_save and want = 0; If want = . then save = code and want = 1;   First of all, I want to create "Year_save" and "Previous_year_save" value. Is there an easy way?   Thanks. ... View more

Re: one variable with multiple inputs and subset of the same input

by Fluorite | Level 6 in SAS Programming
‎09-26-2019 12:36 AM
‎09-26-2019 12:36 AM
1. What's the CODE variable? A) code = company; Sorry for your uncomfortableness. (I corrected it.)   2. Please explain how you derive the last 2 WANT with value=1.   A) In case of [D 4 2010 0 ii], code(=ii) is different with lag(save)(=hh) and is not included in lag(save). Also, there is no observation which has code(=hh) in 2010 because of single-year observation in 2010. Therefore, by the logic 3, the want variable of the corresponding observation has the value of 1. Actually, [D 4 2014 0 jj] case is same as the aforementioned case. code(=jj) is different with lag(save)(=ii) and not included in lag(save). Also, there is no observation which has code(=ii) in 2014 because of single-year observation in 2014. Therefore, by the logic 3, the want variable of the corresponding observation has the value of 1.   3. Please ensure that you provide test data and results covering all the test cases you mention. A) Test data is the uploaded dataset and the result is also the uploaded expected result.   Thanks for your help!! ... View more

Re: Retain multiple variables and use subset within do loop

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 07:55 PM
‎09-25-2019 07:55 PM
I added the detailed info. and B 2010 dd has the value of 1 by the rule 3. ... View more

one variable with multiple inputs and subset of the same input

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 01:03 PM
‎09-25-2019 01:03 PM
Retain multiple variables and use subset within do loop   Hello everyone,   My dataset is the following:   Person Person_num Year Firstyear Company A 1 2005 1 aa A 1 2006 0 aa A 1 2007 0 aa A 1 2008 0 aa A 1 2008 0 bb A 1 2009 0 aa A 1 2009 0 bb B 2 2008 1 cc B 2 2009 0 dd B 2 2009 0 cc B 2 2010 0 dd B 2 2011 0 dd B 2 2012 0 dd C 3 2002 1 ee C 3 2002 1 ff C 3 2003 0 ee C 3 2003 0 ff C 3 2004 0 ff C 3 2008 0 ff C 3 2009 0 ff C 3 2010 0 ff C 3 2011 0 ff C 3 2012 0 ff C 3 2012 0 gg C 3 2013 0 ff C 3 2014 0 ff D 4 2005 1 hh D 4 2006 0 hh D 4 2010 0 ii D 4 2011 0 ii D 4 2012 0 ii D 4 2014 0 jj D 4 2015 0 jj   The expected outcome is the following:   Person Person_num Year Firstyear Company Save Want A 1 2005 1 aa aa 1 A 1 2006 0 aa aa 0 A 1 2007 0 aa aa 0 A 1 2008 0 aa aa 0 A 1 2008 0 bb aa 0 A 1 2009 0 aa aa 0 A 1 2009 0 bb aa 0 B 2 2008 1 cc cc 1 B 2 2009 0 dd cc 0 B 2 2009 0 cc cc 0 B 2 2010 0 dd dd 1 B 2 2011 0 dd dd 0 B 2 2012 0 dd dd 0 C 3 2002 1 ee {ee, ff} 1 C 3 2002 1 ff {ee, ff} 1 C 3 2003 0 ee {ee, ff} 0 C 3 2003 0 ff {ee, ff} 0 C 3 2004 0 ff ff 0 C 3 2008 0 ff ff 0 C 3 2009 0 ff ff 0 C 3 2010 0 ff ff 0 C 3 2011 0 ff ff 0 C 3 2012 0 ff ff 0 C 3 2012 0 gg ff 0 C 3 2013 0 ff ff 0 C 3 2014 0 ff ff 0 D 4 2005 1 hh hh 1 D 4 2006 0 hh hh 0 D 4 2010 0 ii ii 1 D 4 2011 0 ii ii 0 D 4 2012 0 ii ii 0 D 4 2014 0 jj jj 1 D 4 2015 0 jj jj 0   The logic behind is the following:   If firstyear = 1 then want = 1;  If firstyear = 1, save = {companies}. That is, save include all companies when firstyear = 1. (Is it possible to save multiple variables into the save variable?) If firstyear ne 0 and company = lag(save), then save = lag(save) and want = 0;     else if the company in save then save = lag(save) and want = 0;     else if, among the same year observations, there is an observation whose company is equal to the current observation's save variable, then save = lag(save) and want = 0;     else save = company and want = 1;   My attempt is the following: data have; input Person $ Person_num Year Firstyear Company $; datalines; A 1 2005 1 aa A 1 2006 0 aa A 1 2007 0 aa A 1 2008 0 aa A 1 2008 0 bb A 1 2009 0 aa A 1 2009 0 bb B 2 2008 1 cc B 2 2009 0 dd B 2 2009 0 cc B 2 2010 0 dd B 2 2011 0 dd B 2 2012 0 dd C 3 2002 1 ee C 3 2002 1 ff C 3 2003 0 ee C 3 2003 0 ff C 3 2004 0 ff C 3 2008 0 ff C 3 2009 0 ff C 3 2010 0 ff C 3 2011 0 ff C 3 2012 0 ff C 3 2012 0 gg C 3 2013 0 ff C 3 2014 0 ff D 4 2005 1 hh D 4 2006 0 hh D 4 2010 0 ii D 4 2011 0 ii D 4 2012 0 ii D 4 2014 0 jj D 4 2015 0 jj ; data want; set have; do i = 1 to 4; if person_num = i then do; if firstyear = 1 then want = 1 and save = company; *How can assign multiple variables into the save variable when Person = C; if firstyear ne 0 and company = lag(save) then save = lag(save) and want = 0; else if company in save then save = lag(save) and want = 0; else if; *I have no idea in this part.; else save = company and want = 1; end; end; run;   Is there a way to reflect my logic in SAS?    If you know the way, please let me know.   Thank you for your help. ... View more

Retain multiple variables and use subset within do loop

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 12:42 PM
‎09-25-2019 12:42 PM
Hello everyone,   My dataset is the following:   Person Person_num Year Firstyear Company A 1 2005 1 aa A 1 2006 0 aa A 1 2007 0 aa A 1 2008 0 aa A 1 2008 0 bb A 1 2009 0 aa A 1 2009 0 bb B 2 2008 1 cc B 2 2009 0 dd B 2 2009 0 cc B 2 2010 0 dd B 2 2011 0 dd B 2 2012 0 dd C 3 2002 1 ee C 3 2002 1 ff C 3 2003 0 ee C 3 2003 0 ff C 3 2004 0 ff C 3 2008 0 ff C 3 2009 0 ff C 3 2010 0 ff C 3 2011 0 ff C 3 2012 0 ff C 3 2012 0 gg C 3 2013 0 ff C 3 2014 0 ff D 4 2005 1 hh D 4 2006 0 hh D 4 2010 0 ii D 4 2011 0 ii D 4 2012 0 ii D 4 2014 0 jj D 4 2015 0 jj   The expected outcome is the following:   Person Person_num Year Firstyear Company Save Want A 1 2005 1 aa aa 1 A 1 2006 0 aa aa 0 A 1 2007 0 aa aa 0 A 1 2008 0 aa aa 0 A 1 2008 0 bb aa 0 A 1 2009 0 aa aa 0 A 1 2009 0 bb aa 0 B 2 2008 1 cc cc 1 B 2 2009 0 dd cc 0 B 2 2009 0 cc cc 0 B 2 2010 0 dd dd 1 B 2 2011 0 dd dd 0 B 2 2012 0 dd dd 0 C 3 2002 1 ee {ee, ff} 1 C 3 2002 1 ff {ee, ff} 1 C 3 2003 0 ee {ee, ff} 0 C 3 2003 0 ff {ee, ff} 0 C 3 2004 0 ff ff 0 C 3 2008 0 ff ff 0 C 3 2009 0 ff ff 0 C 3 2010 0 ff ff 0 C 3 2011 0 ff ff 0 C 3 2012 0 ff ff 0 C 3 2012 0 gg ff 0 C 3 2013 0 ff ff 0 C 3 2014 0 ff ff 0 D 4 2005 1 hh hh 1 D 4 2006 0 hh hh 0 D 4 2010 0 ii ii 1 D 4 2011 0 ii ii 0 D 4 2012 0 ii ii 0 D 4 2014 0 jj jj 1 D 4 2015 0 jj jj 0   The logic behind is the following:   1. If firstyear = 1 then want = 1;  2. If firstyear = 1, save = {companies}. That is, save include all companies when firstyear = 1. (Is it possible to save multiple variables into the save variable?) 3. If firstyear ne 0 and company = lag(save), then save = lag(save) and want = 0;     else if the company in save then save = lag(save) and want = 0;     else if, among the same year observations, there is an observation whose company is equal to the current observation's save variable, then save = lag(save) and want = 0;     else save = code and want = 1;   My attempt is the following:   data have; input Person $ Person_num Year Firstyear Company $; datalines; A 1 2005 1 aa A 1 2006 0 aa A 1 2007 0 aa A 1 2008 0 aa A 1 2008 0 bb A 1 2009 0 aa A 1 2009 0 bb B 2 2008 1 cc B 2 2009 0 dd B 2 2009 0 cc B 2 2010 0 dd B 2 2011 0 dd B 2 2012 0 dd C 3 2002 1 ee C 3 2002 1 ff C 3 2003 0 ee C 3 2003 0 ff C 3 2004 0 ff C 3 2008 0 ff C 3 2009 0 ff C 3 2010 0 ff C 3 2011 0 ff C 3 2012 0 ff C 3 2012 0 gg C 3 2013 0 ff C 3 2014 0 ff D 4 2005 1 hh D 4 2006 0 hh D 4 2010 0 ii D 4 2011 0 ii D 4 2012 0 ii D 4 2014 0 jj D 4 2015 0 jj ; data want; set have; do i = 1 to 4; if person_num = i then do; if firstyear = 1 then want = 1 and save = code; *How can assign multiple variables into the save variable when Person = C; if firstyear ne 0 and company = lag(save) then save = lag(save) and want = 0; else if company in save then save = lag(save) and want = 0; else if; *I have no idea in this part.; else want = 1; end; end; run;   ... View more

Is there an easy way to solve my problem?

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 06:33 AM
‎09-25-2019 06:33 AM
Hello,   I am stuck to solve the difficulty.   I need your knowledge..   The dataset and the expected result("Want variable" is the following:   Person Year Company Want A 2005 aa 1 A 2006 aa 0 A 2007 aa 0 A 2008 aa 0 A 2008 bb 0 A 2009 aa 0 A 2009 bb 0 B 2008 cc 1 B 2009 dd 0 B 2009 cc 0 B 2010 dd 1 B 2011 dd 0 B 2012 dd 0 C 2002 ee 1 C 2002 ff 1 C 2003 ee 0 C 2003 ff 0 C 2004 ff 0 C 2008 ff 0 C 2009 ff 0 C 2010 ff 0 C 2011 ff 0 C 2012 ff 0 C 2012 gg 0 C 2013 ff 0 C 2014 ff 0 D 2005 hh 1 D 2006 hh 0 D 2010 ii 1 D 2011 ii 0 D 2012 ii 0 D 2014 jj 1 D 2015 jj 0   The logic to determine the "want variable" is like this: 1. if first.person then want = 1; if year = lag(year) and lag(want) = 1 then want = 1; 2. When the want variable =1, I would like to save the company as a new "save variable". (Is it possible to save multiple variables into the save variable?) 3. If the company of current observation equals to the save variable, then want = 0; else if there is an observation which has the same company with the save variable in the same year, then want = 0; else want = 1; 4. And everytime the want variable changes from 0 to 1, I would like to update the save variable to the company with the corresponding value of 1.   If you know an easy way to solve this problem, please let me know.   Thanks for your help. ... View more

Re: Is there any built-in function in order to find my 'want' result?

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 01:40 AM
‎09-25-2019 01:40 AM
WOW!! Thank you for your help.   ... View more

Re: Is there any built-in function in order to find my 'want' result?

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 01:18 AM
‎09-25-2019 01:18 AM
I want to make a set which, by person, has the observations after first.flag.   For example, in case of person B, the observation 5 (year 2011) and 6 (year 2012) are left in the set since the first.flage is 2011 ... View more

Re: Is there any built-in function in order to find my 'want' result?

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 01:15 AM
‎09-25-2019 01:15 AM
OH. Thanks. When I upload this file, the invalid HTML error has occurred so that the data is messed up. Now, it is revised. Please check it. ... View more

Is there any built-in function in order to find my 'want' result?

by Fluorite | Level 6 in SAS Programming
‎09-25-2019 12:56 AM
‎09-25-2019 12:56 AM
Hello,   I need your help to find what I want.   My dataset is the following:   Person Company Year Flag A aa 2005 1 A bb 2007 0 A bb 2008 0 B B yy uu 2010 2011 0 1 B C cc ee 2012 1998 1 0 C ee 2002 1 C ee 2015 0 C pp 2016 0 C pp 2017 1   From this set, I want to extract the subset behind which includes the observations after flag = 1 for each person.    Person Company Year Flag A aa 2005 1 A bb 2007 0 A bb 2008 0 B uu 2011 1 B cc 2012 1 C ee 2002 1 C ee 2015 0 C pp 2016 0 C pp 2017 1   If you know the easy way to solve the problem, please let me know.   Thanks.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-28-2019 05:05 PM
Likes given to
View All
Quick links