https://communities.sas.com/t5/SAS-Programming/Total-users/m-p/311266#M67228 <P>Use substr().</P> Sun, 13 Nov 2016 17:31:49 GMT LinusH 2016-11-13T17:31:49Z https://communities.sas.com/t5/SAS-Programming/Total-users/m-p/311244#M67214 <P>Hello everybody!</P><P>&nbsp;</P><P>I have a question, I need to have the total of people who visit a parto of a website, it is /blog.</P><P>I have a column named url with all the links like /shop, /shop/buy, /search /blog, etc. and another with page views .</P><P>How my proc sql need to&nbsp;be if I want to know the total of pageviews of the /blog?</P><P>&nbsp;</P><P>Thanks!</P> Sun, 13 Nov 2016 15:31:41 GMT https://communities.sas.com/t5/SAS-Programming/Total-users/m-p/311244#M67214 fconerj 2016-11-13T15:31:41Z https://communities.sas.com/t5/SAS-Programming/Total-users/m-p/311266#M67228 <P>Use substr().</P> Sun, 13 Nov 2016 17:31:49 GMT https://communities.sas.com/t5/SAS-Programming/Total-users/m-p/311266#M67228 LinusH 2016-11-13T17:31:49Z