I have a liat of students. For each student at a particular tine there is a flag which takes value 0 or 1. The data is sorted in ascending order. Student time flag; A. 1:20 0 A. 1:35. 1 A 2:40 0 B. 5:30. 0 B. 5:35. 0 B. 6:10. 1 I want to keep only those observations for a student where the flag is 1, and the observation prior to that. Like for this example I want to keep the first two obs for student A and last two for B. How fo I achieve this? Please help ... View more

I have a list of students and a list of devices they have used for various sessions, all in a sorted form: Student Device A. Mac A. Tablet A. Laptop B. PC B. ANDROID B. ANDROID C. TABLET C. TABLET C. IPHONE I need to create a flag for those students for whom the device in their last session doesn't match with the device in the previous session. So for the above data, the flag will be created for student A and C. How do I proceed? Please help ... View more

I have a data set for students and various time points. Student time A 12:10 A 12:11 A 12:20 A 12:45 B 3:10 B 3:16 B 3:32 C 8:05 C 8:54 C 9:10 I want the difference between the first and last observation for a particular student. I want the result as A 00:35 B 00:22 C 00:55 How do I do this? ... View more

I have a list of numbers belonging to some groups. Dataset is sorted in descending order: Group A 10 Group A 5 Group A 3 Group A 2 Group A 1 Group B 15 Group B 7 Group B 2 How do I pick those observations which belong within the top 95% or more within a particular group? Like the total of group A is 21, so the first four observations in group A will contribute to the top 95% and the first 2 observations of Group B I want to create a flag against observations which satisfy this criteria . So in this case there will be a flag for first 4 obs of Group A and first 2 of Group B. ... View more

I have a dataset containing country, state, city and total population within each: Data popn; Input country$ state$ city$ population; Cards; US California LA 100 US California SD 50 US Texas Houston 10 US Texas Austin 5 INDIA MH Mumbai 10 INDIA MH Pune 5 INDIA MH Nasik 7 INDIA WB Kol 6 INDIA UP Bs 4 What I require is state wise cumulative percentage of population, that is by the second column as groups: US California LA 100 67% US California SD 50. 100% US Texas Houston 10 67% US Texas Austin 5. 100% INDIA MH Mumbai 10. 45% INDIA MH Pune 5. 68% INDIA MH Nasik 7. 100% INDIA WB Kol 6. 100% INDIA UP Bs 4. 100% How do I get this ? ... View more

I have a list of customers and their monthly ratings ranging from 0 to 9 for all the months. I want to select only those customers for whom once the rating reached value 2 or above, it kept on increasing thereafter and never fell back to a lower rating(0 or 1), or stayed the same. In other words, I want those customers for whom their rating has been 2 or above, with monotonously increasing in the later months. I am using Sas 9.4. Data sample; Input customer$8. Rating month date9.; Cards; A 0 Jan19 A 1 Feb19 A 2 Mar19 A 2 Apr19 A 3 May19 A 4 Jun19 B 2 Apr19 B 3 May19 B 4 Jun19 B 5 Jul19 B 6 Aug19 B 5 Sep19 B 4 Oct19 C 2 Jan19 C 2 Feb19 C 3 Mar19 C 4 Apr19 C 5 May 19 ; Run; As per requirement, I will want the result to contain customer A and Customer C ... View more