06-24-2020
ngrannum75
Fluorite | Level 6
Member since
04-08-2020
- 4 Posts
- 2 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by ngrannum75
Subject Views Posted 608 06-17-2020 10:58 PM 1535 05-22-2020 05:58 PM 1548 05-22-2020 05:26 PM 1588 05-22-2020 04:01 PM -
Activity Feed for ngrannum75
- Posted Grouping ID variable by date to create daily time series on SAS Academy for Data Science. 06-17-2020 10:58 PM
- Liked Re: Full Join using proc sql but not working for Kurt_Bremser. 05-22-2020 06:00 PM
- Posted Re: Full Join using proc sql but not working on SAS Programming. 05-22-2020 05:58 PM
- Liked Re: Full Join using proc sql but not working for Tom. 05-22-2020 05:57 PM
- Posted Re: Full Join using proc sql but not working on SAS Programming. 05-22-2020 05:26 PM
- Posted Full Join using proc sql but not working on SAS Programming. 05-22-2020 04:01 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1
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
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
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