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: 
ngrannum75
‎06-24-2020
  • 4 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Grouping ID variable by date to create daily time series

by Fluorite | Level 6 in SAS Academy for Data Science
‎06-17-2020 10:58 PM
‎06-17-2020 10:58 PM
Hi,    I have a table that has Prod_Ids (product avail to sell) and Start_date and End_date. I would like to group similar Prod_Ids for each day ... essentially creating a count of Prod_Ids (product) avail to sell each day. For example, Prod_Ids = 1011111, Count = 50, Start_date = 01JUN2020. So I am also changing the datetime to date9.    My key question is how to count the Prod_Ids for each day to create a daily count of product Prod_IDs.  Here is an example of the data:    Prod_Id Start_date End_date 10644800 26FEB2020:04:05:50.180000 27FEB2020:04:25:54.189999 10656210 02SEP2019:04:15:36.840000 04SEP2019:04:03:47.819999 10656210 07MAR2020:06:25:11.780000 08MAR2020:06:37:29.919999 10656210 17FEB2020:03:55:08.130000 18FEB2020:04:58:05.809999 10665400 21AUG2019:12:44:09.780000 24AUG2019:05:16:01.809999 10665400 06NOV2019:05:51:53.420000 11NOV2019:05:14:50.279999 10682600 27FEB2020:04:25:54.190000 28FEB2020:04:25:13.529999 10703611 29SEP2019:04:04:38.320000 30SEP2019:05:19:45.929999 10703611 15DEC2019:04:12:49.910000 21DEC2019:04:40:18.419999 10703611 16NOV2019:05:19:58.700000 17NOV2019:04:43:56.199999 10703611 21AUG2019:12:44:09.780000 24AUG2019:05:16:01.809999 10703611 06NOV2019:05:51:53.420000 11NOV2019:05:14:50.279999 ... View more

Re: Full Join using proc sql but not working

by Fluorite | Level 6 in SAS Programming
‎05-22-2020 05:58 PM
‎05-22-2020 05:58 PM
Thank you so much! This clears up my confusion! ... View more

Re: Full Join using proc sql but not working

by Fluorite | Level 6 in SAS Programming
‎05-22-2020 05:26 PM
‎05-22-2020 05:26 PM
Thank you.  I am new to SAS EG. How do you suggest I correct this variable? In the table uses this datetime format and i would like to filter for a specific date range. is my macro incorrect or my where clause?    Valid_Start_Dttm  "01JAN2020:12:00:00.000000"d   %LET start_date = 01JAN2020:12:00:00.000000;   where x.Valid_Start_Dttm BETWEEN "&start_date."d AND TODAY()- 1;   I am guessing I would need a datetime in my where clause?      Thank you.  ... View more

Full Join using proc sql but not working

by Fluorite | Level 6 in SAS Programming
‎05-22-2020 04:01 PM
‎05-22-2020 04:01 PM
Hi, I am trying to perform a full join using two tables, there is no output on the log; my SAS server just seems to be timing out. Not sure what is happening or how to troubleshoot this issue. Here is my code.   %LET start_date = 01JAN20:12:00: 00.000000; proc sql; create table uat as select x.sku_id, x.Base_Price_Amt, xx.On_Air_Qty, y.Shipping_And_Handling_Amt, y.Source_Cd from hist x full join expos y on (x.sku_id = y.sku_id) where x.Valid_Start_Dttm between "&start_date."d and today() - 1 ; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-24-2020 04:31 PM
Likes given to
View All
Quick links