topic Re: It's a SAS question, need to find out most popular product. in SAS Programming

most popular product/ most purchased product having dataset of sales

SV75 — Mon, 24 Sep 2018 07:29:01 GMT

Re: most popular product/ most purchased product having dataset of sales

RW9 — Mon, 24 Sep 2018 07:35:48 GMT

Please review the guidance on posting new questions. You have provided no information or even a question as far as I can tell. Post test data in the form of a datastep, show what you want out from that, and explain any logic in between.

Re: most popular product/ most purchased product having dataset of sales

Reeza — Mon, 24 Sep 2018 14:58:14 GMT

How do you define the 'most popular product' or 'most purchased product'? Is it over a specific time frame? What does your data look like, are items in rows or columns? What do you want as output? Is this per store/region or product class or overall? Your question is not a question and unanswerable at this point in time.

Re: most popular product/ most purchased product having dataset of sales

ballardw — Mon, 24 Sep 2018 14:59:21 GMT

proc freq is one of the basic tools for counting.

with out examples of what your data might actually look like it is very hard to go much further than that.

It's a SAS question, need to find out most popular product.

SV75 — Tue, 25 Sep 2018 11:02:35 GMT

The data is about the sales of product in different country with their product id and other details. So I need to find out the most popular product that is the product which is having great sale with respect to country.

Re: It's a SAS question, need to find out most popular product.

RW9 — Tue, 25 Sep 2018 11:11:23 GMT

Again:

Post test data in the form of a datastep, show what you want out from that, and explain any logic in between.

At a guess do something like:

proc sql;
  create table want as
  select  country,
          value
  from    (select country,sum(value) as value from have group by country)
  having value=max(value);
quit;

Or a proc means and output sum, then take top result.

Re: It's a SAS question, need to find out most popular product.

Reeza — Tue, 25 Sep 2018 14:46:27 GMT

Vague question without data, equals vague answer without code or data.

So sum the sales of each products in each country and rank them. PROC MEANS will sum them and PROC RANK will rank them to find the top products.

@SV75 wrote:

The data is about the sales of product in different country with their product id and other details. So I need to find out the most popular product that is the product which is having great sale with respect to country.

Re: most popular product/ most purchased product having dataset of sales by country wise report

vamshirajd — Sun, 06 Sep 2020 11:10:49 GMT

Re: most popular product/ most purchased product having dataset of sales

vamshirajd — Sun, 06 Sep 2020 11:12:19 GMT

online retail store data

Re: most popular product/ most purchased product having dataset of sales

vamshirajd — Sun, 06 Sep 2020 11:55:21 GMT

how to know missing values

Re: most popular product/ most purchased product having dataset of sales

PaigeMiller — Sun, 06 Sep 2020 11:58:06 GMT

@vamshirajd you need to ask a complete question, providing all the relevant details.

Re: most popular product/ most purchased product having dataset of sales

Kurt_Bremser — Sun, 06 Sep 2020 12:40:25 GMT

Note that hijacking another's 2-year-old thread is not a way for getting good answers. Please post your question in a new thread of your own, with a descriptive subject line, and pertinent details. Example data (posted as a data step with datalines in a code box) and expected outcome will be helpful.