Hi , Sorry I shared the same code which I got from sas team. Now here is the code which I tried. I am attaching the new excel so that it can help you to understand my actual requirement. A bit change with the requirement. I am trying to write down what extactly I am looking for. In the Excel sheet , Input tab for category F2, Category 4, I would like to select the continuous 6 rows from P_mnth1 201808. The logic is like I have to first check in column " Time" for each category and its category2 where Time is equal to or greater than 3. From there I have to select 6 rows continuously but if in case Time is "." as p_count is 0 and next row having "Time column" 3 orgreater than 3, then I need to take 6 rows from where time column".". Like in Category F2, Category2 as 4 , I want rows from 082018 as P_count is 0 and next row below it have time 3. Like now for categoryF2 with category2 as 3, I will select rows from 032018. This what modification I have from earlier query . earlier I was looking the continuous rows where time column is 3 or greater 3 starts . I was not including the row where time column is ".". for ex earlier , with same category F2, Category2 as 4 , I was looking rows from 072018. Hope this helps in understanding as its difficult to explain in writing all. The code over which I was trying is earlier one only so for selecting Continous 6 rows from time 3 or greater than 3 . Request you to please look at the excel attached. The input and output which I really want. Here is the code which I was trying . PROC SQL; Create Table NEW As Select Distinct Category, Category2, P_mnth1, PCount, Time, (CAT(Category,Category2)) As New Category From SAS file Order by Category desc, Category desc, P_mnth1 desc; Quit; PROC SQL noprint; Create table work.WANTA As Select Category, Category2, New Category, P_mnth1 As MONTH FORMAT= YYMMN6. From work.New Where Time ❤️ Group by New Category Order by Category DESC, Category2 Desc, New Category DESC, P_mnth1 DESC; Quit; PROC SQL noprint; Create table work.want_FINAL AS Select a.* From work.New AS a LEFT JOIN work.WANTA As b ON a.New category = b.New Category; QUIT; Waiting for your response. In excel sheet , I attached tab named as earlier output (this code is for the same only modification I did was to concatenate two coulmns and then use the above code but then it is not working) , the tab named as " New Output" is exactly what I am looking now. Am I able to make you to understand the requirement
... View more