topic Re: proc sql ptoc report in SAS Programming

proc sql ptoc report

sourabhy — Thu, 21 Jun 2018 18:24:13 GMT

i need to know.. how to solve this querry
countrywise breakup of
most purchased product
least purchased product
since i am fresher in sas kindly help..

Re: proc sql ptoc report

Kurt_Bremser — Thu, 21 Jun 2018 18:57:03 GMT

Please post the code you already tried, and some example data for testing.

Post data in a data step with datalines.

Re: proc sql ptoc report

ballardw — Thu, 21 Jun 2018 19:48:18 GMT

"Most purchased product" would require a definition. It could represent 1) frequency of purchase, 2) total currency value of purchases, 3) largest numbers of unique purchasers and likely a few more ideas depending on what the "product" concerns.

as a minimum a description of your data would help provide more targeted suggestions, best is some example data in the form of a data step.

Also, do you want/need a data step to provide input to a model or further data processing or do you want a report that people will read?

I would likely look at starting with Proc summary with your country and product variables as CLASS variables and what ever you are using to measure "most" or "least" as VAR variable that gets summed. I would likely use the NWAY option as well unless I wanted sums of the VAR variables overall, by country regardless of product and by product regardless of country.

Re: proc sql ptoc report

sourabhy — Fri, 22 Jun 2018 02:17:48 GMT

data new;

input productid $ country $ quantity 5.;

datalines;

22139 UK 56

21773 UK 4

21773 UK 5

21801 UK 34

21056 SA 1

21773 SA 34

34788 MN 345

3456 MN 234

;

I need table given below:

title "most purchased product"

country productid maxqty(as per quantity)

UK 22139 56

SA 21773 34

MN 34788 345

similarly for least purchased product

didn't got the same output.

kindly help

Re: proc sql ptoc report

Kurt_Bremser — Fri, 22 Jun 2018 03:31:19 GMT

Try

proc sql;
create table want as
select country, productid, max(quantity) as maxqty
from new
group by country
having quantity = max(quantity);
quit;