Hi  Team,   I need a help in sas problem statement. I have a data set which I have attached in attachment below in which I have two question-   1, in attached file I have divide the amtspent into three categories- below 100, 100-200 and above 200 . 2. I want to count the number of unique customers in each group(using select case when) I have tried below code but unable to find the solution-   proc sql; create table want as select custid case when amtspent = "below 100" then count(distinct custid) when amtspent = "100-200" then count(distinct custid) when amtspent = "above 200" then count(distinct custid) else count(distinct custid) end as "unique customer" from grv group by amtspent quit; run;     Please help   ... View more

Hi Team,   In attached file I want to clubbed data into two group group 1 only for jet airways and air india and group 2 for other airline. and after that I want to find top 15 client to be identified location wise based upon the volume and the airlne group share.   Kindly help.   ... View more

Hi  Team,   In attached file I want to categorize the respondent into three category based on their spending(below 100,100-200 and above 200 ) and how we count the number of unique customer in each group. however I have tried below codes but not successful to finding the result-   proc sql; create table new as select case when amtspent > 100 then "below 100" when amtspent 100-200 then "between100 to 200" when amtspent < 200 then "above 200" else value "nothing"; end; run;   Kindly check and advise.   Thanks, Manoj Ahuja ... View more

Hi  Team,   I am new in sas, In attached file how to import the data in sas such that only transaction data is imported and only header data is imprted.       Kindly advise.   Thanks, Manoj Ahuja ... View more

How to categorize the data into two group in sad? For example if we have dataset for airline so how we categorize the data into two group; one group for jet Airways and air india and second group for all other airlines? Please help ... View more