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: 
Srigyan
‎02-08-2022
  • 130 Posts
  • 19 Likes Given
  • 2 Solutions
  • 0 Likes Received

Re: add multiple record

by Quartz | Level 8 in SAS Programming
‎03-21-2019 10:44 AM
‎03-21-2019 10:44 AM
  I have done this in following way...     proc sql; update &final_File._checkpoints as a set Checkpoints="Total Records", Total_Count=(select Count(*) from &final_File.), comment="This is total number cases here", Update_Date=today(); insert into &final_File._checkpoints set Checkpoints="Unique record", Total_Count=(select Count(distinct &level.) from &final_File.), comment="This is unique number of cases", Update_Date=today(); quit; ... View more

add multiple record

by Quartz | Level 8 in SAS Programming
‎03-21-2019 08:57 AM
‎03-21-2019 08:57 AM
I am creating a table and updating the record with some queries. %let final_File=F_OUTPUT.DS_daily_demand_F; %let level= (catx('',OPTION_NUMBER,date,fascia)); data &final_File._checkpoints; format Checkpoints $30. Total_Count 10. comment $100. Check_Date date9.; run; proc sql; update &final_File._checkpoints as a set Checkpoints="Total Records", Total_Count=(select Count(*) from &final_File.), comment="This is total number cases here", Check_Date=today();   proc append &final_File._checkpoints= Checkpoints="Unique record", Total_Count=(select Count(distinct product_ID) from &final_File.), comment="This is unique number of cases", Check_Date=today(); quit;   highlighted portion is not working, how should I write this code. ... View more

Re: range change

by Quartz | Level 8 in SAS Programming
‎03-19-2019 11:40 AM
‎03-19-2019 11:40 AM
sorry, I am facing problem when I have more date for same product.   table 1       Product st_date End_date Price A 10-Jan-18 15-Jan-18 10 A 15-Jan-18 30-Jan-18 10 B 09-Feb-18 14-Feb-18 20 C 06-May-18 11-May-18 30 D 11-Jun-18 16-Jun-18 15   table 2   Product Override_date Price A 10-Jan-18 11 A 11-Jan-18 12 A 13-Jan-18 9 A 14-Jan-18 5 A 03-Jan-18 12 B 09-Feb-18 18 D 17-Jun-18 23         output is coming like    Product st_date End_date Price A 10-Jan-18 10-Jan-18 11 A 11-Jan-18 12-Jan-18 12 A 13-Jan-18 13-Jan-18 9 A 14-Jan-18 02-Jan-18 5 A 03-Jan-18 15-Jan-18 12 A 15-Jan-18 10-Jan-18 11 A 11-Jan-18 12-Jan-18 12 A 13-Jan-18 13-Jan-18 9 A 14-Jan-18 02-Jan-18 5 A 03-Jan-18 30-Jan-18 12 B 09-Feb-18 14-Feb-18 18 C 06-May-18 11-May-18 30 D 11-Jun-18 16-Jun-18 15   highlighted is error. ... View more

Re: range change

by Quartz | Level 8 in SAS Programming
‎03-19-2019 10:56 AM
‎03-19-2019 10:56 AM
As suggested i put end date for over_ride   table1       Product st_date End_date Price A 01-Jan-18 15-Jan-18 10 B 09-Feb-18 14-Feb-18 20 C 06-May-18 11-May-18 30 D 11-Jun-18 16-Jun-18 15     table2       Product Override_date End_date Price A 03-Jan-18 15-Jan-18 12 A 10-Jan-18 15-Jan-18 11 A 11-Jan-18 15-Jan-18 12 A 13-Jan-18 15-Jan-18 9 A 14-Jan-18 15-Jan-18 5 B 09-Feb-18 14-Feb-18 18 D 17-Jun-18 16-Jun-18 23   i run the macro  %FletrensInterval(work.table1, work.table2, work.want, unita=Product, datefirsta=St_date, datelasta=End_date, unitb=Product, datefirstb=Override_date, datelastb=End_date, join=left);   showing following error: 24 proc datasets lib=&lib nolist; delete &ds; quit; 24 ! %rensinterval(&tablea,qzbtableft0,datefirst=&datefirsta,datelast=&datelasta); _ 180 24 ! %rensinterval(&tableb,qzbtabright0,datefirst=&datefirstb,datelast=&datelastb); * sortering afhængig om byvars ERROR 180-322: Statement is not valid or it is used out of proper order. WARNING: Apparent invocation of macro RENSINTERVAL not resolved. WARNING: Apparent invocation of macro RENSINTERVAL not resolved. 24 proc datasets lib=&lib nolist; delete &ds; quit; 24 ! %rensinterval(&tablea,qzbtableft0,datefirst=&datefirsta,datelast=&datelasta); 24 ! %rensinterval(&tableb,qzbtabright0,datefirst=&datefirstb,datelast=&datelastb); * sortering afhængig om byvars _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order.     ... View more

Re: range change

by Quartz | Level 8 in SAS Programming
‎03-19-2019 10:43 AM
‎03-19-2019 10:43 AM
I am working on your example. I will let you know if this works for me. ... View more

Re: range change

by Quartz | Level 8 in SAS Programming
‎03-19-2019 10:41 AM
‎03-19-2019 10:41 AM
Hi, Thanks, this answer also worked for me. But i could have select only one answer as solution so I accepted the first one. But this answer work fine for me. Thanks. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-18-2019 05:56 AM
‎03-18-2019 05:56 AM
I am looking to skip that step, is this not possible. I know this way. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-18-2019 05:53 AM
‎03-18-2019 05:53 AM
Thanks for putting effor on my query and thats good learning for me. However for my question the first condition was we can't create a date wise data. data inter (drop=on_sale_date off_sale_date); set have; by product; do date=on_sale_date to off_sale_date; output; end; format date date9.; run; This section of code actually creating that, offcourse this is the right answer but not the one I am looking for.  ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 11:56 AM
‎03-15-2019 11:56 AM
request you to please have a look on the query. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 11:54 AM
‎03-15-2019 11:54 AM
it has the business relationship 🙂 but thats not the same technically. I still need to try all the answer given in my previous post. if that work surelly i will confirm that, sorry for delay.   As far as this problem is concern. and why the record is coming from 6 to 3 record for product A. if you expand that data you have multiple price for same day but we need to consider only one price for one day which is the lowest. and thats why there are only 3 range which cover the entire period here. Hope thats clears the query. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 10:28 AM
‎03-15-2019 10:28 AM
I can try, please share how can i do it. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 10:11 AM
‎03-15-2019 10:11 AM
Daywise data i have created, but the challenge is to create the data the way i am looking.   Purpose to use less hard-disk, i have limited storage for this operation.  ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 10:11 AM
‎03-15-2019 10:11 AM
Daywise data i have created, but the challenge is to create the data the way i am looking. Purpose to use less hard-disk, i have limited storage for this operation.  ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 09:08 AM
‎03-15-2019 09:08 AM
Its giving me day wise result and I specifically mentioned i dont want to go in that route. I need range without creating a day wise record. ... View more

Re: Range selection based of lowest price

by Quartz | Level 8 in SAS Programming
‎03-15-2019 08:36 AM
‎03-15-2019 08:36 AM
Not very specific for SQL, datastep is good for me.Let me check and confirm ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-08-2022 02:23 PM
Likes given to
Quick links