cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
alexanthonymaj0
‎04-18-2019
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Creating a new variable based on Count of 2 other variables

by Calcite | Level 5 in SAS Programming
‎04-18-2019 02:52 AM
‎04-18-2019 02:52 AM
Yes, thank you so much for your reply, I am really appreciative! I have a couple of follow-up questions, if you don't mind. First off, I am trying to group the variables (1) Count_Customer (2) Count_Sales_Rep (3) Sales_Volume based on (1) the Channel 'Sales_Channel' and (2) the Month 'Report_Month'  -- I know the results I am getting are not correct (I have attached to this post). How would I go about achieving this?           proc sql;        create table work.sales_summary1 AS select report_month, count(unique Customer_ID) as Count_Customer, count(unique Sales_Rep_ID) as Count_Sales_Rep, Sales_Volume, Sales_Channel          from sales_details group by Report_Month and Sales_Channel; quit; ... View more

Creating a new variable based on Count of 2 other variables

by Calcite | Level 5 in SAS Programming
‎04-17-2019 09:50 PM
‎04-17-2019 09:50 PM
Hi Everyone, I am looking to create a new variable that counts unique customers, based on the month - represented by Custer_ID and Report_Month respectively. Any help would be greatly appreciated!  Here is what I have so far - thanks in advance   data sales_summary1;          set Sales_Details;          Distinct_Customer = count(Customer_Id,Report_Month);         keep Distinct_Customer report_month sales_channel; run; ... View more

Date Formatting issue

by Calcite | Level 5 in SAS Programming
‎02-06-2019 02:41 AM
‎02-06-2019 02:41 AM
Hi everyone,   I am getting all of my desired results, except my date formatting is incorrect. Currently, the date is formatted as "06-Aug-89" (it also comes up in the results this way) and I would like it to be  formatted as 06/11/1989. Does anyone have any suggestions?  Here is my code:   libname employee '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568'; data emp123;           length FirstName $ 14 LastName $ 20 JobTitle $ 22;           infile '/home/alexanthonymaj0/my_courses/rahmansarker/c_8568/emp_50490.csv' dlm=',';           input EmployeeID FirstName $ LastName $ Gender $ Salary JobTitle $ Country $ HireDate $;           format HireDate $ddmmyy. Salary dollar8.; drop Gender Country; run;   proc print data=emp123; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-18-2019 07:58 PM
Quick links