https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835019#M330077 <P>Try this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input customer_Id $ order_id order $; datalines; a 168 TV a 169 TV a 170 TV a 171 Radio a 172 Radio a 173 Radio b 174 TV b 175 TV b 176 TV b 177 TV b 178 TV b 179 TV c 180 TV c 181 TV c 182 Radio c 183 Radio c 184 Radio ; data want; set have; by customer_Id order notsorted; if first.customer_Id then rank = 0; if first.order then rank + 1; run;</CODE></PRE> Sat, 24 Sep 2022 20:03:10 GMT PeterClemmensen 2022-09-24T20:03:10Z https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835016#M330076 <P>Hello Community,</P><P>I am trying to give a rank to a product in the order they appear on my table. Here is my data <STRONG>Have&nbsp;</STRONG></P><TABLE><TBODY><TR><TD>customer_Id</TD><TD>order_id</TD><TD>order</TD></TR><TR><TD>a</TD><TD>168</TD><TD>TV</TD></TR><TR><TD>a</TD><TD>169</TD><TD>TV</TD></TR><TR><TD>a</TD><TD>170</TD><TD>TV</TD></TR><TR><TD>a</TD><TD>171</TD><TD>Radio</TD></TR><TR><TD>a</TD><TD>172</TD><TD>Radio</TD></TR><TR><TD>a</TD><TD>173</TD><TD>Radio</TD></TR><TR><TD>b</TD><TD>174</TD><TD>TV</TD></TR><TR><TD>b</TD><TD>175</TD><TD>TV</TD></TR><TR><TD>b</TD><TD>176</TD><TD>TV</TD></TR><TR><TD>b</TD><TD>177</TD><TD>TV</TD></TR><TR><TD>b</TD><TD>178</TD><TD>TV</TD></TR><TR><TD>b</TD><TD>179</TD><TD>TV</TD></TR><TR><TD>c</TD><TD>180</TD><TD>TV</TD></TR><TR><TD>c</TD><TD>181</TD><TD>TV</TD></TR><TR><TD>c</TD><TD>182</TD><TD>Radio</TD></TR><TR><TD>c</TD><TD>183</TD><TD>Radio</TD></TR><TR><TD>c</TD><TD>184</TD><TD>Radio</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And below is my data <STRONG>Want</STRONG>.</P><TABLE><TBODY><TR><TD>Id</TD><TD>order_id</TD><TD>order</TD><TD>Rank</TD></TR><TR><TD>a</TD><TD>168</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>a</TD><TD>169</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>a</TD><TD>170</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>a</TD><TD>171</TD><TD>Radio</TD><TD>2</TD></TR><TR><TD>a</TD><TD>172</TD><TD>Radio</TD><TD>2</TD></TR><TR><TD>a</TD><TD>173</TD><TD>Radio</TD><TD>2</TD></TR><TR><TD>b</TD><TD>174</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>b</TD><TD>175</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>b</TD><TD>176</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>b</TD><TD>177</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>b</TD><TD>178</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>b</TD><TD>179</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>c</TD><TD>180</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>c</TD><TD>181</TD><TD>TV</TD><TD>1</TD></TR><TR><TD>c</TD><TD>182</TD><TD>Radio</TD><TD>2</TD></TR><TR><TD>c</TD><TD>183</TD><TD>Radio</TD><TD>2</TD></TR><TR><TD>c</TD><TD>184</TD><TD>Radio</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks for helping.</P> Sat, 24 Sep 2022 19:50:46 GMT https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835016#M330076 twix17 2022-09-24T19:50:46Z https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835019#M330077 <P>Try this</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data have; input customer_Id $ order_id order $; datalines; a 168 TV a 169 TV a 170 TV a 171 Radio a 172 Radio a 173 Radio b 174 TV b 175 TV b 176 TV b 177 TV b 178 TV b 179 TV c 180 TV c 181 TV c 182 Radio c 183 Radio c 184 Radio ; data want; set have; by customer_Id order notsorted; if first.customer_Id then rank = 0; if first.order then rank + 1; run;</CODE></PRE> Sat, 24 Sep 2022 20:03:10 GMT https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835019#M330077 PeterClemmensen 2022-09-24T20:03:10Z https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835024#M330080 <P>Thank you this works perfectly.</P> Sat, 24 Sep 2022 20:42:51 GMT https://communities.sas.com/t5/SAS-Programming/Ranking-within-two-categorical-variables/m-p/835024#M330080 twix17 2022-09-24T20:42:51Z