About Saba1

Saba1 · ‎01-09-2019

@Kurt_Bremser: I have updated the sample data. You can see now. Thanks

Saba1 · ‎01-09-2019

@andreas_ldsPlease see the updated data sample. Thanks

Saba1 · ‎01-08-2019

@PeterClemmensen: Thanks but in my dataset2 managers' names are repeating so when I run "proc format" statement, I receive the following Error: "ERROR: For format $MNGFMT, this range is repeated, or values overlap:". Also is there a way to replace all the statements like "Manager1=input(put(Manager1, $MngFmt.), 8.);" with something else, because I have around 100 columns in Dataset1 i.e. Manager1 - Manager100.

Saba1 · ‎01-08-2019

@Kurt_Bremser : Thanks for your reply. But when I run "proc format cntlin=cntlin;" statement, the Error says: "ERROR: For format $MYGENDER, this range is repeated, or values overlap". Therefore, for "Want" dataset when I run data step, the Error is as follows: " The format $MYGENDER was not found or could not be loaded". Actually, several managers' names are repeated in dataset2. So there can be cases with same manager name but different ID or in few cases even with the same ID the name is repeated twice. Is there a way to solve this issue?

Saba1 · ‎01-08-2019

@Ksharp: your help will be really appreciated.

Saba1 · ‎01-08-2019

Hi I have a dataset1 where columns are basically managers' names attached to various dates. This is my master/main dataset. The other dataset2 has a gender column of these managers, so one column is names of these managers and parallel column is the gender (converted in numeric i.e. 0 and 1). I want to create a "New_dataset" which should be similar to Dataset1, but the names (character variable) must be replaced with the gender variable from Dataset2. Please see a sample below: Data Dataset1; infile datalines dlm="," missover DSD; input ID : $10. Date_Month : mmddyy10. Manager1 : $60. Manager2 : $60. Manager3 : $60. ; format Date_Month mmddyy10. ; datalines; AB00046,06-30-2016,Ronald Baron,Bill F. Baron, AB00046,07-31-2016,Ronald Baron,Bill F. Baron, AB00046,08-31-2016,Ronald Baron,Bill F. Baron, AB00046,09-30-2016,Ronald Baron,Bill F. Baron, AB00046,10-31-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,11-30-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,12-31-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,01-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,02-28-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,03-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,04-30-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,05-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,06-30-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,07-31-2017,Ronald Baron,Bill F. Baron, AB00046,08-31-2017,Ronald Baron,Bill F. Baron, AB00050,04-30-2016, AB00050,05-31-2016, AB00050,06-30-2016,Sharon AB00050,07-31-2016,Sharon,Tim S. AB00050,08-31-2016,Sharon,Tim S. AB00050,09-30-2016,Sharon,Tim S. ; run; Data Dataset2; infile datalines dlm="," missover DSD; input ID : $10. Name_Manager : $60. Gender ; datalines; AB00046,Ronald Baron,0 AB00046,Bill F. Baron,0 AB00046,Tim S.,0 AB00050,Sharon,1 AB00050,Tim S.,0 ; run; Data Dataset_Want; infile datalines dlm="," missover DSD; input ID : $10. Date_Month : mmddyy10. Manager1 Manager2 Manager3 ; format Date_Month mmddyy10. ; datalines; AB00046,06-30-2016,0,0, AB00046,07-31-2016,0,0, AB00046,08-31-2016,0,0, AB00046,09-30-2016,0,0, AB00046,10-31-2016,0,0,0 AB00046,11-30-2016,0,0,0 AB00046,12-31-2016,0,0,0 AB00046,01-31-2017,0,0,0 AB00046,02-28-2017,0,0,0 AB00046,03-31-2017,0,0,0 AB00046,04-30-2017,0,0,0 AB00046,05-31-2017,0,0,0 AB00046,06-30-2017,0,0,0 AB00046,07-31-2017,0,0, AB00046,08-31-2017,0,0, AB00050,04-30-2016, AB00050,05-31-2016, AB00050,06-30-2016,1 AB00050,07-31-2016,1,0 AB00050,08-31-2016,1,0 AB00050,09-30-2016,1,0 ; run; Please Guide me in this regard. Thanks.

Saba1 · ‎11-02-2018

@Ksharp: Thank you so much. It works perfectly well now.

Saba1 · ‎11-01-2018

@Ksharp: You are right. The name is correct. Actually, the issue highlighted in my last question is regarding the repetition of this manager's name according to bracket dates. As per the bracket dates, I want the output dataset where Tim S. is stating from 10/31/2016 and this name must finish on 06/30/2017 of Date_Month column. However, when I use your developed code, this name ends on 05/31/2017 and does not appear on 06/30/2017. So the issue of missing one month (ending date) is there. I hope now my question is understandable. Kindly guide me in this regard. Thanks.

Saba1 · ‎10-31-2018

@s_lassen: Thank you so much for this favor. The code is really useful. However, I encounter two issues: First, the names of managers are not full in new variables. Second, for all the cases like "[2016-10-26 -- 2017-06-01] Tim S." where End date of the bracket is 2017-06-01, in the result dataset manager's name is reported till 2017-05-31, which means laps of one month. Can you figure out the reason and guide me accordingly? Thanks.

Saba1 · ‎10-31-2018

@Ksharp: Thanks a lot. The code is really useful and giving the required dataset. The only issue is with the cases like "[2016-10-26 -- 2017-06-01] Tim S.", where End date of the bracket is 2017-06-01, but in the resulting dataset manager's name is reported till 2017-05-31.This means laps of one month. Can you figure out the reason and guide me accordingly? Thanks.

Saba1 · ‎10-30-2018

@Ksharp: I shall be highly grateful if you can guide me in solving this issue.

Saba1 · ‎10-30-2018

I have a dataset where the first column is based on unique IDs and the second column contains regular monthly dates from 01-31-2016 till 12-31-2017 for each unique ID. Then there are several columns containing some dates (in brackets) and names of managers associated with these dates. I have around 90 columns for Managers and 3500 unique IDs. Below is the sample dataset: Data Have; infile datalines dlm="," missover DSD; input ID : $10. Date_Month : mmddyy10. Manager1 : $60. Manager2 : $60. Manager3 : $60. ; format Date_Month mmddyy10. ; datalines; AB00046,01-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,02-28-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,03-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,04-30-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,05-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,06-30-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,07-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,08-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,09-30-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,10-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,11-30-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,12-31-2016,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,01-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,02-28-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,03-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,04-30-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,05-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,06-30-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,07-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,08-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,09-30-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,10-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,11-30-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00046,12-31-2017,[2012-01-23 -- ] Ronald Baron,[2016-01-23 -- ] Bill F. Baron,[2016-10-26 -- 2017-06-01] Tim S. AB00050,01-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,02-28-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,03-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,04-30-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,05-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,06-30-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,07-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,08-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,09-30-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,10-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,11-30-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,12-31-2016,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,01-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,02-28-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,03-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,04-30-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,05-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,06-30-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,07-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,08-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,09-30-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,10-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,11-30-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, AB00050,12-31-2017,[2010-05-20 -- 2014-01-02] Tom T.,[2016-06-29 -- 2018-06-06] Sharon, ; run; I want the following: 1- In all the columns where bracket dates' "year" and "month" match with the "year" and "month" of Date_month column, keep the names of managers. The bracket of dates should not be displayed in "want" dataset. 2- If the starting date in the bracket is earlier than the starting date of Date_month column i.e. 01-31-2016, then manager's name should start from 01-31-2016, all previous dates in the bracket must be ignored. 3- If the ending date in the bracket is either greater than the ending date of Date_month column i.e. 12-31-2017 or is not given and shown as dashes e.g. [2016-01-23 -- ], then manager name must be continued till 12-31-2017. 4- When month and year of these two dates are not matched, such manager's name must be ignored. Please see below the required output dataset: Data Want; infile datalines dlm="," missover DSD; input ID : $10. Date_Month : mmddyy10. Manager1 : $60. Manager2 : $60. Manager3 : $60. ; format Date_Month mmddyy10. ; datalines; AB00046,01-31-2016,Ronald Baron,Bill F. Baron, AB00046,02-28-2016,Ronald Baron,Bill F. Baron, AB00046,03-31-2016,Ronald Baron,Bill F. Baron, AB00046,04-30-2016,Ronald Baron,Bill F. Baron, AB00046,05-31-2016,Ronald Baron,Bill F. Baron, AB00046,06-30-2016,Ronald Baron,Bill F. Baron, AB00046,07-31-2016,Ronald Baron,Bill F. Baron, AB00046,08-31-2016,Ronald Baron,Bill F. Baron, AB00046,09-30-2016,Ronald Baron,Bill F. Baron, AB00046,10-31-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,11-30-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,12-31-2016,Ronald Baron,Bill F. Baron,Tim S. AB00046,01-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,02-28-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,03-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,04-30-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,05-31-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,06-30-2017,Ronald Baron,Bill F. Baron,Tim S. AB00046,07-31-2017,Ronald Baron,Bill F. Baron, AB00046,08-31-2017,Ronald Baron,Bill F. Baron, AB00046,09-30-2017,Ronald Baron,Bill F. Baron, AB00046,10-31-2017,Ronald Baron,Bill F. Baron, AB00046,11-30-2017,Ronald Baron,Bill F. Baron, AB00046,12-31-2017,Ronald Baron,Bill F. Baron, AB00050,01-31-2016, AB00050,02-28-2016, AB00050,03-31-2016, AB00050,04-30-2016, AB00050,05-31-2016, AB00050,06-30-2016,Sharon AB00050,07-31-2016,Sharon AB00050,08-31-2016,Sharon AB00050,09-30-2016,Sharon AB00050,10-31-2016,Sharon AB00050,11-30-2016,Sharon AB00050,12-31-2016,Sharon AB00050,01-31-2017,Sharon AB00050,02-28-2017,Sharon AB00050,03-31-2017,Sharon AB00050,04-30-2017,Sharon AB00050,05-31-2017,Sharon AB00050,06-30-2017,Sharon AB00050,07-31-2017,Sharon AB00050,08-31-2017,Sharon AB00050,09-30-2017,Sharon AB00050,10-31-2017,Sharon AB00050,11-30-2017,Sharon AB00050,12-31-2017,Sharon ; run; Please suggest some solution. Thanks.

Saba1 · ‎09-30-2018

Thanks a lot.

Saba1 · ‎09-30-2018

Thanks. It is so helpful.

Saba1 · ‎09-30-2018

Hi I have a dataset with a variable of "Comp_Name", it consists of the long names of various companies. I want to delete the observations where "company_name" includes specific strings e.g. ‘IDX’, ‘S&P’, ‘DOW JONES’ and ‘MSCI’. Please see the sample below: Data have; input ID Comp_Name $; datalines; 105246 AARI Growth S&P: Social Principl Inst. 105246 AARI Growth S&P: Social Principl Inst. 105290 Atlas Assets Inc. Health Servc 105290 Atlas Assets Inc. Health Servc 105290 Atlas Assets Inc. Health Servc 116020 AARE Income: Invst IDX 147001 Evergreen Select: Dow Jones: Diversified Value 147001 Evergreen Select: Dow Jones: Diversified Value ; run; I want the following: Data want; input ID Comp_Name $; datalines; 105290 Atlas Assets Inc. Health Servc 105290 Atlas Assets Inc. Health Servc 105290 Atlas Assets Inc. Health Servc ; run; Need your guidance. Thanks

Online Status	Offline
Date Last Visited	‎07-18-2020 08:41 PM

Re: dates of trading days

dates of trading days

Re: Repeating numbers

Repeating numbers

Re: Finding Week Number of a Month

Finding Week Number of a Month

Combine two datasets

Re: rename multiple variables with a series of numbers

rename multiple variables with a series of numbers

Re: Proc Syslin with Fixed Effects and Robust Standard Errors

Re: dates of trading days

Re: dates of trading days

Re: Repeating numbers

Re: Proc Syslin with Fixed Effects and Robust Standard Errors

Re: Finding Week Number of a Month

dates of trading days

Wald test for proc glm

Re: SAS monthly and daily Date formatting

Re: Replacing observations of one dataset with the values of another d...

Re: Replacing observations of one dataset with the values of another d...

Re: Replacing observations of one dataset with the values of another d...

Re: Replacing observations of one dataset with the values of another d...

Re: Replacing observations of one dataset with the values of another d...

Replacing observations of one dataset with the values of another datas...

Re: Dealing with Character Variable with matched dates

Re: Dealing with Character Variable with matched dates

Re: Dealing with Character Variable with matched dates

Re: Dealing with Character Variable with matched dates

Re: Dealing with Character Variable with matched dates

Dealing with Character Variable with matched dates

Re: Deleting particular strings from variable's names

Re: Deleting particular strings from variable's names

Deleting particular strings from variable's names