About d0816

d0816 · ‎10-11-2018

I am using this code to graph a histogram, but the barlabels are overlapping eachother. Like in excel , is there a way to change orientation of the barlabels? I have been trying to look for the ans for the past 1 hour. I found orient and rotate option but don't seem to work here. Thanks. proc univariate data = have noprint; histogram variable1 / vscale=percent barlabel = percent midpoints = -50 to 50 by 2; INSET N MEAN (8.2) MEDIAN (8.2) STD = 'Std. Dev' (8.3)/ POSITION = ne; label variable1= ""; run;

d0816 · ‎10-08-2018

Hello, I want to subset a dataset into two datasets where in one dataset I want to keep all rows for an ID if the value for another variable is a certain value. For eg. Dataset I have: ID class status 1 1 complete 1 2 Incomplete 1 3 complete 2 1 Incomplete 2 2 Incomplete 2 3 Incomplete 3 1 Incomplete 3 2 Incomplete 4 1 complete 4 2 complete 4 3 complete 4 4 complete Datasets I want are: Dataset 1: status is all "Incomplete" for an ID. ID class status 2 1 Incomplete 2 2 Incomplete 2 3 Incomplete 3 1 Incomplete 3 2 Incomplete Dataset 2: status is all "Complete" or combination of "Complete/ Incomplete" for an ID. ID class status 1 1 complete 1 2 Incomplete 1 3 complete 4 1 complete 4 2 complete 4 3 complete 4 4 complete Thank you for your help.

d0816 · ‎08-22-2018

Thank you so much Reeza. This worked.

d0816 · ‎08-22-2018

Hi all, I have a data set like below. I would like to delete all duplicate course values for an ID. For e.g. For ID 2, course E,U and W is duplicated. I want to keep only one row for each course. So for ID 2, I would like to have 4 rows showing courses E,J,U and W in each row. It does not matter which duplicate course is deleted. However If the course is missing, I would like to keep those blank courses. for eg. ID 6 and 16 have missing courses. Dataset I have: ID Status StatusBeginDate StatusEndDate Course CourseBeginDate CourseEndDate 1 WW 5/3/2017 9/30/2017 C 4/19/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 E 8/16/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 P 4/19/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 S 4/19/2017 11/7/2017 2 JJ 11/22/2017 2/16/2018 E 12/11/2017 12/18/2017 2 JJ 11/22/2017 2/16/2018 E 12/19/2017 2/27/2018 2 JJ 11/22/2017 2/16/2018 J 12/11/2017 12/15/2017 2 JJ 11/22/2017 2/16/2018 U 1/14/2014 2 JJ 11/22/2017 2/16/2018 U 7/17/2017 2 JJ 11/22/2017 2/16/2018 W 11/22/2017 12/8/2017 2 JJ 11/22/2017 2/16/2018 W 12/11/2017 12/15/2017 2 JJ 11/22/2017 2/16/2018 W 12/18/2017 2/27/2018 3 C1 10/27/2017 10/30/2017 B 10/17/2017 10/29/2017 3 C1 10/27/2017 10/30/2017 X 10/30/2017 10/30/2017 3 CC 9/1/2017 10/26/2017 B 10/17/2017 10/29/2017 3 CC 9/1/2017 10/26/2017 X 8/14/2017 10/16/2017 4 JJ 12/25/2017 3/1/2018 W 12/26/2017 2/25/2018 4 JJ 12/25/2017 3/1/2018 X 12/20/2017 1/29/2018 4 C3 12/16/2017 12/24/2017 W 10/23/2017 12/20/2017 4 C3 12/16/2017 12/24/2017 X 12/20/2017 1/29/2018 4 JJ 10/29/2017 12/15/2017 W 10/23/2017 12/20/2017 5 JJ 12/8/2017 E 12/28/2017 1/25/2018 5 JJ 12/8/2017 W 12/8/2017 12/27/2017 5 JJ 12/8/2017 W 12/28/2017 1/24/2018 5 CC 12/1/2017 12/7/2017 A 10/25/2017 12/7/2017 6 JJ 1/31/2017 1/31/2017 6 CC 12/6/2016 1/30/2017 W 1/17/2017 1/17/2017 7 WW 4/5/2017 7/31/2017 L 5/19/2017 7/31/2017 7 WW 4/5/2017 7/31/2017 M 5/19/2017 7/31/2017 7 WW 4/5/2017 7/31/2017 U 5/28/2014 7 WW 4/5/2017 7/31/2017 U 11/26/2014 8 FF 9/18/2017 4/30/2018 R 9/18/2017 6/7/2018 8 FF 9/18/2017 4/30/2018 Z 9/25/2015 8 FF 9/18/2017 4/30/2018 U 3/12/2014 8 FF 9/18/2017 4/30/2018 U 9/23/2015 8 FF 9/18/2017 4/30/2018 D 9/18/2017 6/7/2018 9 FF 3/20/2017 8/31/2017 R 1/26/2017 8/3/2017 9 FF 3/20/2017 8/31/2017 D 1/26/2017 8/3/2017 9 FF 3/20/2017 8/31/2017 R 8/4/2017 9/19/2017 9 FF 3/20/2017 8/31/2017 D 8/4/2017 9/19/2017 10 JJ 10/16/2017 10/31/2017 T 10/19/2017 12/7/2017 10 JJ 10/16/2017 10/31/2017 E 10/17/2017 12/7/2017 10 JJ 10/16/2017 10/31/2017 R 7/7/2017 10/16/2017 10 JJ 10/16/2017 10/31/2017 W 10/18/2017 12/7/2017 10 FF 7/7/2017 10/15/2017 R 7/7/2017 10/16/2017 10 FF 7/7/2017 10/15/2017 D 7/7/2017 10/11/2017 11 JJ 6/22/2017 E 10/30/2017 12/13/2017 11 JJ 6/22/2017 W 10/30/2017 12/12/2017 11 JJ 6/22/2017 W 12/13/2017 2/6/2018 12 FF 12/29/2017 5/31/2018 R 6/29/2017 12/29/2017 12 FF 12/29/2017 5/31/2018 U 7/26/2016 12 FF 12/29/2017 5/31/2018 Q 7/26/2016 12 FF 12/29/2017 5/31/2018 W 7/6/2017 12/29/2017 12 FF 12/29/2017 5/31/2018 X 8/4/2016 2/6/2018 12 C1 9/11/2017 12/28/2017 R 6/29/2017 12/29/2017 12 C1 9/11/2017 12/28/2017 U 7/26/2016 12 C1 9/11/2017 12/28/2017 Q 7/26/2016 12 C1 9/11/2017 12/28/2017 W 7/6/2017 12/29/2017 12 C1 9/11/2017 12/28/2017 X 8/4/2016 2/6/2018 13 WW 6/28/2016 M 6/28/2016 13 WW 6/28/2016 S 6/28/2016 13 WW 6/28/2016 U 7/6/2015 13 WW 6/28/2016 U 11/23/2015 13 WW 6/28/2016 U 6/20/2016 14 FF 12/13/2017 3/23/2018 R 12/4/2017 3/23/2018 14 FF 12/13/2017 3/23/2018 D 12/4/2017 3/23/2018 14 CC 11/3/2017 12/12/2017 R 12/4/2017 3/23/2018 14 CC 11/3/2017 12/12/2017 A 11/3/2017 12/4/2017 14 CC 11/3/2017 12/12/2017 D 12/4/2017 3/23/2018 15 JJ 3/28/2017 10/31/2017 E 8/1/2017 11/1/2017 16 WW 12/22/2017 4/30/2018 N 12/22/2017 1/22/2018 16 WW 12/22/2017 4/30/2018 O 12/22/2017 1/22/2018 16 CC 11/3/2017 12/21/2017 16 JJ 10/15/2017 11/2/2017 Dataset I Want: ID Status StatusBeginDate StatusEndDate Course CourseBeginDate CourseEndDate 1 WW 5/3/2017 9/30/2017 C 4/19/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 E 8/16/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 P 4/19/2017 10/3/2017 1 WW 5/3/2017 9/30/2017 S 4/19/2017 11/7/2017 2 JJ 11/22/2017 2/16/2018 E 12/19/2017 2/27/2018 2 JJ 11/22/2017 2/16/2018 J 12/11/2017 12/15/2017 2 JJ 11/22/2017 2/16/2018 U 7/17/2017 2 JJ 11/22/2017 2/16/2018 W 12/18/2017 2/27/2018 3 C1 10/27/2017 10/30/2017 B 10/17/2017 10/29/2017 3 C1 10/27/2017 10/30/2017 X 10/30/2017 10/30/2017 4 JJ 12/25/2017 3/1/2018 W 12/26/2017 2/25/2018 4 JJ 12/25/2017 3/1/2018 X 12/20/2017 1/29/2018 5 CC 12/1/2017 12/7/2017 A 10/25/2017 12/7/2017 5 JJ 12/8/2017 E 12/28/2017 1/25/2018 5 JJ 12/8/2017 W 12/28/2017 1/24/2018 6 JJ 1/31/2017 1/31/2017 6 CC 12/6/2016 1/30/2017 W 1/17/2017 1/17/2017 7 WW 4/5/2017 7/31/2017 L 5/19/2017 7/31/2017 7 WW 4/5/2017 7/31/2017 M 5/19/2017 7/31/2017 7 WW 4/5/2017 7/31/2017 U 11/26/2014 8 FF 9/18/2017 4/30/2018 D 9/18/2017 6/7/2018 8 FF 9/18/2017 4/30/2018 R 9/18/2017 6/7/2018 8 FF 9/18/2017 4/30/2018 U 9/23/2015 8 FF 9/18/2017 4/30/2018 Z 9/25/2015 9 FF 3/20/2017 8/31/2017 D 8/4/2017 9/19/2017 9 FF 3/20/2017 8/31/2017 R 8/4/2017 9/19/2017 10 FF 7/7/2017 10/15/2017 D 7/7/2017 10/11/2017 10 JJ 10/16/2017 10/31/2017 E 10/17/2017 12/7/2017 10 JJ 10/16/2017 10/31/2017 R 7/7/2017 10/16/2017 10 JJ 10/16/2017 10/31/2017 T 10/19/2017 12/7/2017 10 JJ 10/16/2017 10/31/2017 W 10/18/2017 12/7/2017 11 JJ 6/22/2017 E 10/30/2017 12/13/2017 11 JJ 6/22/2017 W 12/13/2017 2/6/2018 12 FF 12/29/2017 5/31/2018 Q 7/26/2016 12 FF 12/29/2017 5/31/2018 R 6/29/2017 12/29/2017 12 FF 12/29/2017 5/31/2018 U 7/26/2016 12 FF 12/29/2017 5/31/2018 W 7/6/2017 12/29/2017 12 FF 12/29/2017 5/31/2018 X 8/4/2016 2/6/2018 13 WW 6/28/2016 M 6/28/2016 13 WW 6/28/2016 S 6/28/2016 13 WW 6/28/2016 U 6/20/2016 14 CC 11/3/2017 12/12/2017 A 11/3/2017 12/4/2017 14 FF 12/13/2017 3/23/2018 D 12/4/2017 3/23/2018 14 FF 12/13/2017 3/23/2018 R 12/4/2017 3/23/2018 15 JJ 3/28/2017 10/31/2017 E 8/1/2017 11/1/2017 16 WW 12/22/2017 4/30/2018 N 12/22/2017 1/22/2018 16 WW 12/22/2017 4/30/2018 O 12/22/2017 1/22/2018 16 CC 11/3/2017 12/21/2017 16 JJ 10/15/2017 11/2/2017

d0816 · ‎08-01-2018

This code worked too. Thank you. Appreciate your help.

d0816 · ‎08-01-2018

After adding descending to the code, the code worked. Thank you so much. Appreciate your help.

d0816 · ‎08-01-2018

In the sample dataset below, I want to select all rows for an ID if the begin date with the most recent date value has status W. I am trying to include date condition in the following code, but its not working. Any suggestions? proc sql; create table want as Select * From have where ID in (select ID From have where status in ('W')); quit; sample data ID status begin date end date 1 W 12/5/2017 1/31/2018 1 W 12/5/2017 1/31/2018 1 W 12/5/2017 1/31/2018 1 J 11/1/2017 12/4/2017 2 F 4/6/2017 4/6/2017 2 W 11/16/2016 4/5/2017 3 C 12/11/2017 2/4/2018 3 C 12/11/2017 2/4/2018 3 W 10/26/2017 12/10/2017 3 W 10/26/2017 12/10/2017 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 5 C 12/23/2017 2/7/2018 5 W 12/7/2017 12/22/2017 5 W 12/7/2017 12/22/2017 6 W 12/15/2017 1/10/2018 6 W 12/15/2017 1/10/2018 6 W 12/15/2017 1/10/2018 6 F 5/3/2017 12/14/2017 6 F 5/3/2017 12/14/2017 7 S 4/26/2017 4/30/2017 7 S 4/26/2017 4/30/2017 7 W 11/9/2016 4/25/2017 7 W 11/9/2016 4/25/2017 7 W 11/9/2016 4/25/2017 8 F 12/16/2017 3/29/2018 8 F 12/16/2017 3/29/2018 8 W 4/17/2017 12/15/2017 8 W 4/17/2017 12/15/2017 9 W 8/18/2016 9 W 8/18/2016 10 W 12/8/2017 10 J 10/31/2017 12/7/2017 11 W 9/25/2017 2/20/2018 Dataset I want ID status begin date end date 1 W 12/5/2017 1/31/2018 1 W 12/5/2017 1/31/2018 1 W 12/5/2017 1/31/2018 1 J 11/1/2017 12/4/2017 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 4 W 5/1/2016 5/31/2018 6 W 12/15/2017 1/10/2018 6 W 12/15/2017 1/10/2018 6 W 12/15/2017 1/10/2018 6 F 5/3/2017 12/14/2017 6 F 5/3/2017 12/14/2017 9 W 8/18/2016 9 W 8/18/2016 10 W 12/8/2017 10 J 10/31/2017 12/7/2017 11 W 9/25/2017 2/20/2018

d0816 · ‎07-27-2018

This worked in my original dataset. Thank you so much.

d0816 · ‎07-27-2018

HI, here is the sample dataset which I want to subset into dataset A and B. In dataset B, keep PINs if all obs for session is blank. If one of the Obs in "Session" for a PIN is not blank then keep all the obs for that PIN in dataset B. Please suggest. dataset ID Level Session 1 Z 2 X 2 Y 2 Z 3 Z 3 X 4 X A 4 X 4 Y B dataset B ID Level Session 1 Z 2 X 2 Y 2 Z 3 Z 3 X dataset A ID Level Session 4 X A 4 X 4 Y B

d0816 · ‎07-03-2018

Thank you SuryaKiran for your help!

d0816 · ‎07-03-2018

You are right. I reran in the morning again. It worked. Big Big Thank you for this help!!!

d0816 · ‎07-02-2018

I ran code after removing that one duplicated ID and the code worked for unduplicated IDs and Date in Dataset 1. Thanks so very much.

d0816 · ‎07-02-2018

Thanks so much for providing this explanation. I looked further into my dataset 1 (x), the list of unique IDs and Date. I found that there was one ID (JUST ONE) that was duplicated. In the sample dataset, I had not included all the variables in the dataset 1. But the duplication of the ID occurred due to these other variables. This duplication may have caused the code to not work for me, which worked in the explanation you gave. This duplication may be presenting difficulty for the subsetting of dataset 2 with the code. ID Date Company Exam type 0000000333 2017-06-05 A IVA 0000000333 2017-10-10 B GA

d0816 · ‎07-02-2018

Let me work on the test dataset that I can share.

d0816 · ‎07-02-2018

In the resulting dataset what I want to do is: First, in Dataset 2 (y), keep only those IDs that are in Dataset 1 (x). and remove all IDs that are not in Dataset 1. Then Second, apply the date condition for a matched/common IDs. To your question, Do you get "observations for unmatched ID" or observations where (non-missing) x.date is before y.SessionBeginDate I am getting both.

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 change orientation of barlabels in histogram

subset dataset if all records for an ID is same

Re: Deleting duplicate values of a variable for an ID in multiple rows

Deleting duplicate values of a variable for an ID in multiple rows

Re: REURN ALL ROWS FOR AN ID IF ANY ONE ROW MEETS CONDITION FOR TWO OT...

Re: REURN ALL ROWS FOR AN ID IF ANY ONE ROW MEETS CONDITION FOR TWO OT...

REURN ALL ROWS FOR AN ID IF ANY ONE ROW MEETS CONDITION FOR TWO OTHER ...

Re: subset dataset if all obs for a variable is not missing for an ID

subset dataset if all obs for a variable is not missing for an ID

Re: Keep obs in one dataset based on ID match and other variables matc...

Re: Keep obs in one dataset based on ID match and other variables matc...

Re: Keep obs in one dataset based on ID match and other variables matc...

Re: Keep obs in one dataset based on ID match and other variables matc...

Re: Keep obs in one dataset based on ID match and other variables matc...

Re: Keep obs in one dataset based on ID match and other variables matc...