About d0816

d0816 · ‎04-10-2019

HI, I have following dataset where I want to do a unduplicated count of ID if During or After is a "yes". With this logic unduplicated ID count that satisfy this condition is 8. would appreciate any help. Thanks. ID During After 1 Yes 2 Yes 2 Yes 2 Yes 2 Yes 3 3 Yes 3 3 Yes 4 4 Yes 4 Yes 4 Yes 5 6 Yes 7 8 Yes 8 Yes 9 9 Yes 9 Yes 10 10 11 Yes 12

d0816 · ‎01-22-2019

ID Type Has_A1_in_Type 1 A1 A3 A1 2 A1 A3 A1 3 A1 A3 A1 4 A1 A3 A1 5 A1 A3 A1 6 A1 A3 A1 7 8 A3 9 A1 A3 A1 10 A3 11 A1 A3 A1 12 A3 A1 A1 13 A2 14 A3 15 A1 A1 In this table I want to create a third column which will be A1 if 2nd column has A1 anywhere or else blank . Any one has any idea how to do this? I used index function but did not work. Thank you.

d0816 · ‎11-20-2018

My variable was a string variable , so first I converted to numeric, as Reeza suggested. That did the trick. And then applied the format.

d0816 · ‎11-20-2018

I have following dataset "Have". I want to create a table "want" where the ID is only counted once in a category ClassStartQuarter. If the ClassStartQuarter is missing then the individual did not take a class and therefore do not count in any quarter. Proc freq will give duplicated count, is there other option to get a distinct count for each quarter? Thank you. Dataset: Have ID ClassStartQuarter 1 1 1 1 1 2 2017Q3 2 2017Q3 2 2017Q3 2 2017Q3 3 2018Q1 3 2018Q1 3 2018Q1 3 2018Q1 3 2018Q1 3 2018Q1 3 2018Q1 3 2018Q1 4 2018Q2 4 2018Q2 4 2018Q2 4 2018Q2 4 2018Q2 4 2018Q2 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 5 2015Q4 5 2017Q1 5 2017Q3 5 2018Q1 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 6 2017Q2 7 2017Q2 7 2017Q3 7 2018Q3 7 2017Q2 7 2017Q3 7 2018Q3 7 2017Q2 7 2017Q3 7 2018Q3 7 2017Q2 7 2017Q3 7 2018Q3 7 2017Q2 7 2017Q3 7 2018Q3 8 8 8 8 8 8 9 2016Q1 9 2017Q1 9 2017Q4 9 2016Q1 9 2017Q1 9 2017Q4 9 2016Q1 9 2017Q1 9 2017Q4 9 2016Q1 9 2017Q1 9 2017Q4 9 2016Q1 9 2017Q1 9 2017Q4 9 2016Q1 9 2017Q1 9 2017Q4 10 2017Q4 10 2017Q4 10 2018Q2 10 2018Q2 10 2017Q4 10 2017Q4 10 2018Q2 10 2018Q2 11 2017Q4 11 2017Q4 11 2017Q4 11 2017Q4 12 2014Q3 12 2017Q1 12 2014Q3 12 2017Q1 12 2014Q3 12 2017Q1 12 2014Q3 12 2017Q1 Table: Want (This is just an example) Quarter No.of Distinct ID 2013Q1 0 2013Q2 0 2013Q3 12 2013Q4 4 2014Q1 4 2014Q2 3 2014Q3 16 2014Q4 28 2015Q1 20 2015Q2 21 2015Q3 0 2015Q4 15 2016Q1 28 2016Q2 29 2016Q3 0 2016Q4 0 2017Q1 28 2017Q2 27 2017Q3 60 2017Q4 25 2018Q1 27 2018Q2 33 2018Q3 13 2018Q4 13

d0816 · ‎11-02-2018

I got this error with the suggested code: The format $YYQ was not found or could not be loaded.

d0816 · ‎11-02-2018

I have a date variable in YYMMDD10. format. e.g. 2017-06-26, I want to create another variable with Quarter and Year of the date variable .e.g Q2 2017 (please note the space in between). Some of the values for the date variable is missing and I cant delete rows with missing values. Following code only works when there is no missing date values and returns quarter as Year-Quarter . eg. 2017Q2 data want; set have; EndQuarter=put(EndDate, yyq.); run; But For missing date values, following code did not work. data want; set have; if EndDate=. then EndQuarter=.; else EndQuarter=put(EndDate, yyq.); run; Any suggestion for changes? Thank you.

d0816 · ‎10-17-2018

I still got the same note: The query requires remerging summary statistics back with the original data. Dataset Want_2 should be smaller but I got same no. of observation in Want_1 and Want_2.

d0816 · ‎10-17-2018

HI, I have created another sample dataset have. In dataset Want_1, I would like to calculate the "Total Days in Class" for each "Class" type for an ID, put that operation output in a row with the earliest "ClassBeginDate" for a "Class" type for an ID and keep those rows. In dataset Want_2, I would like to calculate the "Total Days in Class" of all " Class" type for an ID, put that operation output in a row with the earliest "ClassBeginDate" for all "Class" type for an ID and keep that row for an ID. Dataset: Have ID Class ClassStartDate DaysinClass MonthsInCollege Variable1 Variable2 1 AAA 8/13/2018 63 20 2 BBB 8/22/2018 40 1 3 CCC 10/2/2017 21 0 3 BBB 10/23/2017 37 0 3 BBB 11/30/2017 91 1 3 BBB 3/2/2018 71 4 4 BBB 7/1/2018 20 6 4 BBB 7/23/2018 10 7 4 AAA 8/7/2018 25 8 4 AAA 9/8/2018 23 9 5 BBB 3/8/2017 5 1 5 CCC 3/13/2017 80 1 5 AAA 7/2/2018 61 8 6 CCC 3/15/2017 58 0 7 AAA 3/26/2018 159 72 7 AAA 9/3/2018 3 78 8 BBB 6/5/2017 26 1 8 CCC 10/23/2017 101 1 Dataset: Want_1 ID Class ClassStartDate DaysinClass MonthsInCollege Variable1 Variable2 Operations Needed (TotalDaysInClass) 1 AAA 8/13/2018 63 20 63 2 BBB 8/22/2018 40 1 40 3 CCC 10/2/2017 21 0 21 3 BBB 10/23/2017 199 0 37+91+71=199 4 BBB 7/1/2018 30 6 20+10=30 4 AAA 8/7/2018 48 8 25+23=48 5 BBB 3/8/2017 5 1 5 5 CCC 3/13/2017 80 1 80 5 AAA 7/2/2018 61 8 61 6 CCC 3/15/2017 58 0 58 7 AAA 3/26/2018 162 72 159+3=162 8 BBB 6/5/2017 26 1 26 8 CCC 10/23/2017 101 1 101 Dataset: Want_2 ID Class ClassStartDate DaysinClass MonthsInCollege Variable1 Variable2 Operations Needed (TotalDaysInClass) 1 AAA 8/13/2018 63 20 63 2 BBB 8/22/2018 40 1 40 3 CCC 10/2/2017 220 0 21+37+91+71=220 4 BBB 7/1/2018 48 6 25+23+20+10=78 5 BBB 3/8/2017 146 1 5+80+61=146 6 CCC 3/15/2017 58 0 58 7 AAA 3/26/2018 162 72 159+3=162 8 BBB 6/5/2017 127 26 26+101=127 Thank you.

d0816 · ‎10-16-2018

Hi, I modified your code as following. Basically I selected all variables because I needed other variables in the original dataset which I did not show in the sample dataset. proc sql; create table want1 as select *, sum(DaysInSession) as DaysInSession from have group by id,SessionName order by id,sessionname; quit; proc sql; create table want2 as select *, sum(DaysInSession) as DaysInSession from have group by id; quit; As a result, I got the following sample dataset from the first set of code. How to subset this dataset to keep only the rows with the " Keep" for an ID? So keep all rows with different session for an ID and If an ID have multiple rows with same session name then, keep the row with the earliest session begin date for an ID. For e.g for ID #3,5,7 having multiple rows with same session name, keep the row with the earliest begin date. For ID #6, with different session name, keep both the rows. Any suggestion? Date ID Session SessionBeginDate TotalDaysinSession Keep or Delete 2018-08 1 MMM 2018-08-13 63 Keep 2018-08 2 OOO 2018-08-22 40 Keep 2017-11 3 OOO 2017-11-30 199 Keep 2018-03 3 OOO 2018-03-02 199 2017-10 3 OOO 2017-10-23 199 2018-03 4 MMM 2018-03-07 41 Keep 2018-08 5 MMM 2018-08-07 48 Keep 2018-09 5 MMM 2018-09-08 48 2018-07 6 MMM 2018-07-02 61 Keep 2017-03 6 OOO 2017-03-08 5 Keep 2017-10 7 OOO 2017-10-16 194 Keep 2017-12 7 OOO 2017-12-04 194 2017-11 8 OOO 2017-11-20 244 Keep 2017-05 8 OOO 2017-05-12 244

d0816 · ‎10-16-2018

HI, I have similar problem but here I am trying to keep all rows with different session for an ID . IF an ID have multiple rows with same session name then, keep the row with the earliest session begin date for an ID. For e.g for ID #3,5,7 having multiple rows with same session name, keep the row with the earliest begin date. For ID #6, with different session name, keep both the rows. Any suggestion? Date ID Session SessionBeginDate TotalDaysinSession Keep or Delete 2018-08 1 MMM 2018-08-13 63 Keep 2018-08 2 OOO 2018-08-22 40 Keep 2017-11 3 OOO 2017-11-30 199 Keep 2018-03 3 OOO 2018-03-02 199 2017-10 3 OOO 2017-10-23 199 2018-03 4 MMM 2018-03-07 41 Keep 2018-08 5 MMM 2018-08-07 48 Keep 2018-09 5 MMM 2018-09-08 48 2018-07 6 MMM 2018-07-02 61 Keep 2017-03 6 OOO 2017-03-08 5 Keep 2017-10 7 OOO 2017-10-16 194 Keep 2017-12 7 OOO 2017-12-04 194 2017-11 8 OOO 2017-11-20 244 Keep 2017-05 8 OOO 2017-05-12 244

d0816 · ‎10-16-2018

The "Operation Needed" Column is just to show the operation that needs to happen. I do not need that column in my dataset Want_1 and Want_2. Thanks.

d0816 · ‎10-16-2018

The sample dataset Have has multiple rows for an ID with the same or different session name. Dataset: Have ID SessionName DaysInSession 1 AAA 63 2 BBB 40 3 CCC 21 3 BBB 37 3 BBB 91 3 BBB 71 4 AAA 25 4 AAA 23 4 BBB 20 4 BBB 10 5 BBB 5 5 CCC 80 5 AAA 61 6 CCC 58 7 AAA 159 7 AAA 3 8 BBB 26 8 CCC 101 How to create two datasets where, In dataset Want_1, I need three columns where operation I need to do is to add "DaysInSession" for the SAME "SessionName" for an ID. Operation Needed is shown in the 4th column. In dataset Want_2, I need two columns where operation I need to do is add " "DaysInSession" for the ANY "SessionName" for an ID. Operation Needed is shown in the 3rd column. Dataset: Want_1 ID SessionName DaysInSession Operations Needed 1 AAA 63 63 2 BBB 40 40 3 CCC 21 21 3 BBB 199 37+91+71=199 4 AAA 48 25+23=48 4 BBB 30 20+10=30 5 BBB 5 5 5 CCC 80 80 5 AAA 61 61 6 CCC 58 58 7 AAA 162 159+3=162 8 BBB 26 26 8 CCC 101 101 Dataset: Want_2 ID DaysInSession Operations Needed 1 63 63 2 40 40 3 220 21+37+91+71=220 4 78 25+23+20+10=78 5 146 5+80+61=146 6 58 58 7 162 159+3=162 8 127 26+101=127 Thank you for the help.

d0816 · ‎10-16-2018

Thank you so much. It worked.

d0816 · ‎10-16-2018

I have following sample dataset that is sorted by ID and Class Start Date. For an "ID", I would like to keep those rows whenever ID has a NEW "Class Start Date" for the same or different "Class". When doing this, I want to keep the row with the earliest "Date".I have added a column to show which rows I need to keep for an ID. Any help is much appreciated. Thank You. Date ID Class Class Start Date Class End Date Days in Class Months in College Month Category Keep or Delete 2018-08 1 AAA 2018-08-13 9999-12-31 63 20 13-24 Months Keep 2018-09 1 AAA 2018-08-13 9999-12-31 63 21 13-24 Months 2018-10 1 AAA 2018-08-13 9999-12-31 63 21 13-24 Months 2018-08 2 BBB 2018-08-22 2018-09-30 40 1 0-12 Months Keep 2018-09 2 BBB 2018-08-22 2018-09-30 40 2 0-12 Months 2017-10 3 CCC 2017-10-02 2017-10-22 21 0 0-12 Months Keep 2017-10 3 BBB 2017-10-23 2017-11-28 37 0 0-12 Months Keep 2017-11 3 BBB 2017-10-23 2017-11-28 37 1 0-12 Months 2017-11 3 BBB 2017-11-30 2018-02-28 91 1 0-12 Months Keep 2017-12 3 BBB 2017-11-30 2018-02-28 91 2 0-12 Months 2018-01 3 BBB 2017-11-30 2018-02-28 91 3 0-12 Months 2018-02 3 BBB 2017-11-30 2018-02-28 91 4 0-12 Months 2018-03 3 BBB 2018-03-02 2018-05-11 71 4 0-12 Months Keep 2018-04 3 BBB 2018-03-02 2018-05-11 71 6 0-12 Months 2018-05 3 BBB 2018-03-02 2018-05-11 71 7 0-12 Months 2018-08 4 AAA 2018-08-07 2018-08-31 25 8 0-12 Months Keep 2018-09 4 AAA 2018-09-08 2018-09-30 23 9 0-12 Months Keep 2017-03 5 BBB 2017-03-08 2017-03-12 5 1 0-12 Months Keep 2017-03 5 CCC 2017-03-13 2017-05-31 80 1 0-12 Months Keep 2017-04 5 CCC 2017-03-13 2017-05-31 80 1 0-12 Months 2017-05 5 CCC 2017-03-13 2017-05-31 80 1 0-12 Months 2018-07 5 AAA 2018-07-02 2018-08-31 61 8 0-12 Months Keep 2018-08 5 AAA 2018-07-02 2018-08-31 61 9 0-12 Months 2017-10 6 BBB 2017-10-16 2017-11-30 46 1 0-12 Months Keep 2017-11 6 BBB 2017-10-16 2017-11-30 46 2 0-12 Months 2017-12 6 BBB 2017-12-04 2018-04-30 148 3 0-12 Months Keep 2018-01 6 BBB 2017-12-04 2018-04-30 148 4 0-12 Months 2018-02 6 BBB 2017-12-04 2018-04-30 148 5 0-12 Months 2018-03 6 BBB 2017-12-04 2018-04-30 148 6 0-12 Months 2018-04 6 BBB 2017-12-04 2018-04-30 148 7 0-12 Months 2018-01 7 CCC 2018-01-12 2018-01-31 20 0 0-12 Months Keep 2017-03 8 CCC 2017-03-15 2017-05-11 58 0 0-12 Months Keep 2017-04 8 CCC 2017-03-15 2017-05-11 58 0 0-12 Months 2017-05 8 CCC 2017-03-15 2017-05-11 58 1 0-12 Months 2017-05 8 BBB 2017-05-12 2017-08-31 112 1 0-12 Months Keep 2017-06 8 BBB 2017-05-12 2017-08-31 112 2 0-12 Months 2017-07 8 BBB 2017-05-12 2017-08-31 112 3 0-12 Months 2017-08 8 BBB 2017-05-12 2017-08-31 112 4 0-12 Months 2017-11 8 BBB 2017-11-20 2018-03-31 132 5 0-12 Months Keep 2017-12 8 BBB 2017-11-20 2018-03-31 132 6 0-12 Months 2018-01 8 BBB 2017-11-20 2018-03-31 132 7 0-12 Months 2018-02 8 BBB 2017-11-20 2018-03-31 132 8 0-12 Months 2018-03 8 BBB 2017-11-20 2018-03-31 132 8 0-12 Months 2017-11 9 AAA 2017-11-10 2017-12-31 52 12 0-12 Months Keep 2017-12 9 AAA 2017-11-10 2017-12-31 52 13 13-24 Months 2018-04 9 AAA 2018-04-30 2018-07-05 67 16 13-24 Months Keep 2018-05 9 AAA 2018-04-30 2018-07-05 67 17 13-24 Months 2018-06 9 AAA 2018-04-30 2018-07-05 67 18 13-24 Months 2018-07 9 AAA 2018-04-30 2018-07-05 67 19 13-24 Months 2018-03 10 AAA 2018-03-26 2018-08-31 159 72 61+ Months Keep 2018-04 10 AAA 2018-03-26 2018-08-31 159 73 61+ Months 2018-05 10 AAA 2018-03-26 2018-08-31 159 74 61+ Months 2018-06 10 AAA 2018-03-26 2018-08-31 159 75 61+ Months 2018-07 10 AAA 2018-03-26 2018-08-31 159 76 61+ Months 2018-08 10 AAA 2018-03-26 2018-08-31 159 77 61+ Months 2018-09 10 AAA 2018-09-03 2018-09-05 3 78 61+ Months Keep 2017-06 11 BBB 2017-06-05 2017-06-30 26 1 0-12 Months Keep 2017-10 11 CCC 2017-10-23 2018-01-31 101 1 0-12 Months Keep 2017-11 11 CCC 2017-10-23 2018-01-31 101 1 0-12 Months 2017-12 11 CCC 2017-10-23 2018-01-31 101 1 0-12 Months 2018-01 11 CCC 2017-10-23 2018-01-31 101 1 0-12 Months 2017-05 12 BBB 2017-05-30 2017-06-04 6 1 0-12 Months Keep 2017-06 12 BBB 2017-05-30 2017-06-04 6 2 0-12 Months 2017-06 12 CCC 2017-06-05 2017-07-28 54 2 0-12 Months Keep 2017-07 12 CCC 2017-06-05 2017-07-28 54 2 0-12 Months

d0816 · ‎10-11-2018

Thanks for the reply. How do you change orientation with proc SGPLOT?

Online Status	Offline
Date Last Visited	‎11-24-2020 01:22 PM

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Multiple row per ID to one row per ID

Re: rename column

Re: rename column

Re: rename column

Re: rename column

rename column

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Re: Multiple row per ID to one row per ID

Re: spliting a dataset based on conditions

Re: subset a dataset based on variable obs of another dataset

How to do distinct count of ID across variables

Extract and keep part of a character

Re: Convert date to a quarter-Year when some dates are missing

Count ID once in a Category

Re: Convert date to a quarter-Year when some dates are missing

Convert date to a quarter-Year when some dates are missing

Re: How to add numbers of a variable conditionally

Re: How to add numbers of a variable conditionally

Re: How to add numbers of a variable conditionally

Re: How to keep rows conditionally for an ID

Re: How to add numbers of a variable conditionally

How to add numbers of a variable conditionally

Re: How to keep rows conditionally for an ID

How to keep rows conditionally for an ID

Re: how to change orientation of barlabels in histogram