About Srigyan

Srigyan · ‎03-15-2019

I have the below table which gives you prices for a product from a date range. But as you can see there are multiple price is available for the same date.So I wanted to have a new range where price is lowest for that day i.e. if we talk about 02-jan-2018 for product A there are price 28,26,28,10 but i will consider the price 10 because thats the lowest in that range. Product on_sale_date off_sale_date Price A 01-Jan-18 07-Jan-18 28 A 02-Jan-18 08-Jan-18 26 A 02-Jan-18 07-Jan-18 28 A 04-Jan-18 10-Jan-18 21 A 02-Jan-18 10-Jan-18 10 A 05-Jan-18 14-Jan-18 14 b 02-Jan-18 09-Jan-18 27 b 05-Jan-18 13-Jan-18 30 b 04-Jan-18 12-Jan-18 16 b 05-Jan-18 11-Jan-18 19 c 02-Jan-18 08-Jan-18 27 c 02-Jan-18 06-Jan-18 24 c 02-Jan-18 08-Jan-18 30 So my table will look like this ( it creates a new range which takes the lowest price in that period.) Product new_on_sale_date new_off_sale_date Price A 01-Jan-18 01-Jan-18 28 A 02-Jan-18 10-Jan-18 10 A 11-Jan-18 14-Jan-14 14 B 02-Jan-18 03-Jan-18 27 B 04-Jan-18 12-Jan-18 16 B 13-Jan-18 13-Jan-18 30 c 02-Jan-18 06-Jan-18 24 c 07-Jan-18 08-Jan-18 24 Note: 1) There is no limitation for number of records at any level. 2) Unique level is Product+on_sale_date+off_sale_date+price. 3) I am not considering a solution Where i need to put all the record on day wise first And then choose the lowest one And then create range again. I wanted to have this data without creating any table on day wise because the size of data is too huge to create on day wise. Basically I am looking for an optimised query which can hendle 300 Gb data rather than just a simple query .

Srigyan · ‎03-14-2019

yes,everything can be multiple. for a same product it can be different date range also. the level of uniqueness is Product+start_date+end_date_price only.

Srigyan · ‎03-14-2019

there can be multiple override date between start_date and end_date, and if there is more then one override then . table1 product st_date end_date price A 10/01/2018 15/01/2018 10 Table2 Product Override Price A 10/01/2018 11 A 11/01/2018 12 A 13/01/2018 9 A 14/01/2018 5 output will be like product st_date end_date price A 10/01/2018 10/01/2018 11 A 11/01/2018 12/01/2018 12 A 13/01/2018 13/01/2018 9 A 14/01/2018 15/01/2018 5

Srigyan · ‎03-14-2019

Sorry, I think I oversimplified the example. 1) None of the record is fixed it can be any number. 2) 2 assumption is fine, I can manage it. 3)updated when override date>=st_date and override date<=end_date

Srigyan · ‎03-14-2019

Answer for all the question is, it can be any number. This is smallest data which can help to understand the scenario. This is dummy data.

Srigyan · ‎03-14-2019

I have two base table. table 1 Product st_date End_date Price A 01-Jan-18 06-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 Price A 03-Jan-18 12 B 09-Feb-18 18 D 17-Jun-18 23 1st table is the price table for 4 products, it says price for that particular product for a given period. The second table is overridden table where business decided to change the price between the given period from table1. Output should be like this... Output Product st_date End_date Price A 01-Jan-18 02-Jan-18 10 A 03-Jan-18 06-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 I am not considering to write this data first on day wise, then convert on range as this is huge table. i just want to change the range(st_date & end_date based on table2)

Srigyan · ‎01-15-2019

This is working great, however As I mentioned this is for huge database, the following program data all; format date date9.; set sample; do date=Start_Date to End_Date; output; end; keep date price; run; creates one record for each day and each price.I need to calculate this 5 years for more than a billion records. Just don't want to create one record for each date, and each price. Can we optimize this process? To approve a single suggestion, mouse over it and click "✔" Click the bubble to approve all of its suggestions.

Srigyan · ‎01-15-2019

Hi, I have the following data Start_Date End_Date Price 01-Jan-18 05-Jan-18 15 03-Jan-18 09-Jan-18 14 07-Jan-18 10-Jan-18 12 02-Jan-18 07-Jan-18 18 & I am looking for following output Start_Date End_Date Price 01-Jan-18 02-Jan-18 15 03-Jan-18 06-Jan-18 14 07-Jan-18 10-Jan-18 12 How I find the price is based on what is the lowest price available in the first table. 1) 15 is lowest price is for 01-Jan & 2nd Jan. 2) In the same way, 14 is lowest price for 03rdJan to 06-Jan 3) 18 -is never the lowest price so it didn't come in the output data. ***Our output data start date is 01-Jan-2018 and end date is 10-Jan-2018. This is a very huge data originally so I need the most optimized SAS program which completes this job

Srigyan · ‎01-04-2019

I can manage this data without double quote as Developer going to program accrodingly, if I need to provide this data in this format. Do we have any way to do it.

Srigyan · ‎01-04-2019

The application which is consume this data will be developed by the Developer and they wanted to have this input in the format where we dont have any additional double quotes. So do you think you can help me the way i wanted to get an output.

Srigyan · ‎12-20-2018

I don't have option to ignore the file and i have to take the tab only. How can I solve this issue.

Srigyan · ‎12-19-2018

I am trying to export SAS data into CSV, sas dataset name is abc here and format is LINE_NUMBER DESCRIPTION 524JG 24PC AMEFA VINTAGE CUTLERY SET "DUBARRY" I am using following code. filename exprt "C:/abc.csv" encoding="utf-8"; proc export data=abc outfile=exprt dbms=tab; run; output is LINE_NUMBER DESCRIPTION 524JG "24PC AMEFA VINTAGE CUTLERY SET ""DUBARRY""" so there is double quote available before and after the description here and additional doble quote is coming after & before DUBARRY word. I have no clue whats happening. Can some one help me to resolve this and make me understand what exatly happening here.

Srigyan · ‎12-13-2018

I was using dictionary.tables & dictionary.columns table, but I am not aware what each column means from both the table. Can some one explain each column, I know many are self explanatory, but I am not sure about all.Please help...

Srigyan · ‎11-30-2018

how to export all char with double quote

Srigyan · ‎11-30-2018

I have a sas data set and I need to export in csv and that csv file needs to be imported somewhere else. We are not sure what delemeter can be used to seprate one column to another column.As you can say Record can have anything inside it. So taking any delimeter like comma,tab or space etc is risky. 1) Please suggest how to solve this problem. 2) One solution is my mind to replace (")double quote with (') single quote in RECORD field and cover char with (") double quote while export it. What code should be written. 2.1) How to replace double quote with single quote. 2.2) How to export csv file covering char field with double quote. NAME RECORD AMOUNT DATE NAME-1 RECORD"1 20.83 17/10/2017 NAME-2 RECO,RD"2 9.86 30/05/2018 NAME-3 RECORD"3 5.68 05/08/2012 NAME-4 REC,ORD"4 3.21 01/06/2012 NAME-5 RECORD"5 465.37 03/10/2014

Online Status	Offline
Date Last Visited	‎02-08-2022 02:23 PM

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBN...

Re: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBN...

ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME ...

ods select none; and producing table in mail body

Re: sas weekday in macro variable

Re: sas weekday in macro variable

Re: sas weekday in macro variable

Re: sas weekday in macro variable

sas weekday in macro variable

Re: set if dataset have same suffix

Re: set if dataset have same suffix

Re: transpose_format

Re: slow proc sort and code

Re: slow proc sort and code

Re: Default noprint for all possible places

Range selection based of lowest price

Re: range change

Re: range change

Re: range change

Re: range change

range change

Re: date correction

date correction

Re: SAS export giving double quote itself

Re: SAS export giving double quote itself

Re: SAS export giving double quote itself

SAS export giving double quote itself

Tables & Columns SAS

Re: char between double quote in sas export

char between double quote in sas export