About Ganeshk

Ganeshk · ‎10-06-2016

Thanks for quick response. Here is my code: Data oracle.Tab1; Set Tab2; Response_Date=Dhms(Date(),0,0,0); Post_Date=Dhms(Date(),0,0,0); Fromat Response_Date datetime19.; Fromat Post_Date datetime19.; Put Response_Date=; Put Post_Date=; run; Gives todays date. What can be done to modify. My existing variable name are Response_Date and Post_Date. Thanks

Ganeshk · ‎10-06-2016

Actually i have a variable date in that case how to use? sasdt=dhms(day, 0, 0, time); put sasdt datetime.; 02APR03:15:05:02

Ganeshk · ‎10-06-2016

Any example on dhms() function, how to use it?

Ganeshk · ‎10-06-2016

Hi kurtBremser, Multiple by value 86400 worked for me. since i am using SAS 9.3 version. Is there any other method? Thanks, Ganesh K

Ganeshk · ‎10-06-2016

Hi Linush, Actually in SAS Data i have date 05/25/2016 When i create SQL data i got date 1/1/1960 15:30:00 My date format was changed. I used Format to make chages while creation of SQL data Nothing is changing my date. so could you please guide Thanks, Ganesh K

Ganeshk · ‎10-06-2016

Hi all, I have a SAS data set with variable "Date" and having format mmddyy8. when i set the SAS data set and create new data set on Oracle SQL my date is changing to 1/1/1960 15:00:00 [basically to datetime20. format]. How to fix this please help. Thanks, Ganesh K

Ganeshk · ‎05-21-2016

Hi Ksharp, Thanks for code. I need to know is this the method used to arrive Price elasticity? Since i am new to work on this concept. I went through this link : http://support.sas.com/rnd/app/examples/ets/simpelast/sas.htm Do i need to consider some of other factor? Overall i want to know how to arrive Price elasticity? Thanks, Ganesh K

Ganeshk · ‎05-20-2016

Hi, I have table like as shown below: Prod_ID Date SP Vol 101 01Jan2015 18 50 101 04Jan2015 19 55 101 07Jan2015 20 40 101 12Jan2015 19 53 101 15Jan2015 20 37 101 19Jan2015 18 52 101 24Jan2015 19 54 101 25Jan2015 21 32 101 29Jan2015 18 51 101 31Jan2015 20 42 102 01Jan2015 9 40 102 04Jan2015 10 35 102 07Jan2015 8 45 102 12Jan2015 7 44 102 15Jan2015 9 42 102 19Jan2015 11 39 102 24Jan2015 8 48 102 25Jan2015 11 41 102 29Jan2015 9 45 102 31Jan2015 10 36 Now i need to calculate price change and volume change: The formula used to calculate the percentage change in SP is: Price Change= [SP(NEW) - SP(OLD)] / SP(OLD) The formula used to calculate the percentage change in Vol is: Volume Change=[Vol(NEW) - Vol(OLD)] / Vol(OLD) Elasticity= Price Change/Volume Change So my result should be: Prod_ID Date SP Vol Price Change Volume Change Elasticity 101 01Jan2015 18 50 0 0 0 101 04Jan2015 19 55 0.055555556 0.1 1.8 101 07Jan2015 20 40 0.052631579 -0.272727273 -5.181818182 101 12Jan2015 19 53 -0.05 0.325 -6.5 101 15Jan2015 20 37 0.052631579 -0.301886792 -5.735849057 101 19Jan2015 18 52 -0.1 0.405405405 -4.054054054 101 24Jan2015 19 54 0.055555556 0.038461538 0.692307692 101 25Jan2015 21 32 0.105263158 -0.407407407 -3.87037037 101 29Jan2015 18 51 -0.142857143 0.59375 -4.15625 101 31Jan2015 20 42 0.111111111 -0.176470588 -1.588235294 102 01Jan2015 9 40 0 0 0 102 04Jan2015 10 35 0.111111111 -0.125 -1.125 102 07Jan2015 8 45 -0.2 0.285714286 -1.428571429 102 12Jan2015 7 44 -0.125 -0.022222222 0.177777778 102 15Jan2015 9 42 0.285714286 -0.045454545 -0.159090909 102 19Jan2015 11 39 0.222222222 -0.071428571 -0.321428571 102 24Jan2015 8 48 -0.272727273 0.230769231 -0.846153846 102 25Jan2015 11 41 0.375 -0.145833333 -0.388888889 102 29Jan2015 9 45 -0.181818182 0.097560976 -0.536585366 102 31Jan2015 10 36 0.111111111 -0.2 -1.8 I also have doubt whether this is the approach to do price elasticity? Please share your thoughts on this Thanks Ganesh K

Ganeshk · ‎05-12-2016

Hi Ksharp I need one more solution for same program: Item Category Subcategory Volume Volume_Fig Revenue Revenue_Fig Profit Profit_Fig SP Sp_Fig 1 ABC cv Vol_1 2 Rev_1 10 Profit_1 12 SP_1 20 0 Vol_2 3 Rev_2 34 Profit_2 12 SP_2 21 0 Vol_3 4 Rev_3 55 Profit_3 11 SP_3 22 Here only for first observation should only contain values. Rest of all obs. should have "0" (numeric) or " "(character) Thanks, Ganesh K

Ganeshk · ‎05-11-2016

Hi, My data is: Item Category Subcategory Vol_1 Vol_2 Vol_3 Rev_1 Rev_2 Rev_3 Profit_1 Profit_2 Profit_3 SP_1 SP_2 SP_3 1 ABC cv 2 3 4 10 34 55 12 12 11 20 21 22 2 xyz xc 4 6 7 23 44 66 14 15 12 23 23 25 I need to transpose like: Item Category Subcategory Volume Volume_Fig Revenue Revenue_Fig Profit Profit_Fig SP Sp_Fig 1 ABC cv Vol_1 2 Rev_1 10 Profit_1 12 SP_1 20 Vol_2 3 Rev_2 34 Profit_2 12 SP_2 21 Vol_3 4 Rev_3 55 Profit_3 11 SP_3 22 Thanks, Ganesh K

Ganeshk · ‎07-09-2015

hi, i have data set as shown below: Item_Id Category Item_Description Date AGS BC MX 23555212 Chips Potato Lays Chips 50 gms 2/1/2015 22 31 23555212 Chips Potato Lays Chips 50 gms 3/1/2015 33 23555212 Chips Potato Lays Chips 50 gms 5/1/2015 25 32 23555212 Chips Potato Lays Chips 50 gms 6/1/2015 27 23555212 Chips Potato Lays Chips 50 gms 7/1/2015 22 35442011 Chips Chilly Lays Chips 50 gms 2/1/2015 34 35442011 Chips Chilly Lays Chips 50 gms 3/1/2015 31 35442011 Chips Chilly Lays Chips 50 gms 4/1/2015 35442011 Chips Chilly Lays Chips 50 gms 5/1/2015 32 35442011 Chips Chilly Lays Chips 50 gms 6/1/2015 34 My O/P is to be executed as shown below Item_Id Category Item_Description Date AGS BC MX 23555212 Chips Potato Lays Chips 50 gms 2/1/2015 22 31 23555212 Chips Potato Lays Chips 50 gms 3/1/2015 (24) (i.e. 22+25+27+22/4) 33 23555212 Chips Potato Lays Chips 50 gms 5/1/2015 25 32 23555212 Chips Potato Lays Chips 50 gms 6/1/2015 27 (32) (i.e. 31+33+32/3) 23555212 Chips Potato Lays Chips 50 gms 7/1/2015 22 (32) (i.e. 31+33+32/3) 35442011 Chips Chilly Lays Chips 50 gms 2/1/2015 34 35442011 Chips Chilly Lays Chips 50 gms 3/1/2015 31 35442011 Chips Chilly Lays Chips 50 gms 4/1/2015 (32.75) (i.e. 34+31+32+34/4) 35442011 Chips Chilly Lays Chips 50 gms 5/1/2015 32 35442011 Chips Chilly Lays Chips 50 gms 6/1/2015 34 How to do this? Thanks, Ganesh K

Ganeshk · ‎07-09-2015

Hi, i have data set has shown below: Category Subcategory Class Item_Description Item_ID 30/March/2015 6/April/2015 13/April/2015 20/April/2015 27/April/2015 4/May/2015 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 23 26 24 22 23 25 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 26 24 25 21 22 24 Required O/P: Category Subcategory Class Item_Description Item_ID Date Price Snacks Chips Potato_Chips Potato Lays 50gm 502223189 30/March/2015 23 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 6/April/2015 26 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 13/April/2015 24 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 20/April/2015 22 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 27/April/2015 23 Snacks Chips Potato_Chips Potato Lays 50gm 502223189 4/May/2015 25 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 30/March/2015 26 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 6/April/2015 24 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 13/April/2015 25 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 20/April/2015 21 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 27/April/2015 22 Snacks Chips Chilly_Chips Chilly Lays 50gm 621452221 4/May/2015 24 How to transpose as shown above? Thanks, Ganesh K

Ganeshk · ‎07-08-2015

Hi, I found many links in sas support communities under this topic, but i was not able to fix the issue. My data consist of 134 sheets in single excel workbook with xlsx format. Each file is consisting of 3000 records. My Question is: How to import all sheet as data set and then append them all at once? Thanks Ganesh

Ganeshk · ‎07-06-2015

Hi All, My data is as shown below: Promo_id Promotion_Start Promotion_End 10121 1/1/2015 1/14/2015 10129 1/1/2015 1/7/2015 So Requirement is to convert my data into weekly level: Note: As per my client week start is of Monday to Sunday basis Ex: Output of my data with new column need to be created "New Start week", "Count_of_Days" and "Calc_Reqd" Promo_id Promotion_Start Promotion_End New_Start_week Count_of_Days "Calc_Reqd" 10121 1/1/2015 1/14/2015 12/29/2014 4 "4/7" 10121 1/1/2015 1/14/2015 1/5/2015 7 "7/7" 10121 1/1/2015 1/14/2015 1/12/2015 3 "3/7" 10129 1/1/2015 1/7/2015 12/29/2014 4 "4/7" 10129 1/1/2015 1/7/2015 1/5/2015 3 "3/7" Thanks, Ganesh K

Ganeshk · ‎06-18-2015

Hi, i have a data set with 4 variable, data set is shown below: Storeid ProdId Date SP 1 101 22/1/2013 18 1 101 23/1/2013 18 1 101 24/1/2013 19 1 101 25/1/2013 18 1 101 26/1/2013 19 1 101 27/1/2013 19 Require output is: Storeid ProdId Date SP 1 101 22/1/2013 18 1 101 24/1/2013 19 1 101 25/1/2013 18 1 101 26/1/2013 19 How to retrieve particular record when price is increasing or decresing?

Online Status	Offline
Date Last Visited	‎08-28-2021 04:17 PM

Want to extract semicolon related values and bucket it as required vqr...

Re: 1 table need to be looked up into multiple folder related dataset

1 table need to be looked up into multiple folder related dataset

How to extract this string?

Re: How to get all the list of all files as a dataset from particular ...

Re: How to get all the list of all files as a dataset from particular ...

Re: How to get all the list of all files as a dataset from particular ...

How to get all the list of all files as a dataset from particular fold...

Re: Date Formating Causing ERROR value instead of missing in the data ...

Re: Date Formating Causing ERROR value instead of missing in the data ...

Re: 1 table need to be looked up into multiple folder related dataset

Re: How to extract this string?

Re: How to extract this string?

Re: Distinct values for all columns in dataset

Re: How to get all the list of all files as a dataset from particular ...

Re: Date format changing while processing SAS file to oracle Sql

Re: Date format changing while processing SAS file to oracle Sql

Re: Date format changing while processing SAS file to oracle Sql

Re: Date format changing while processing SAS file to oracle Sql

Re: Date format changing while processing SAS file to oracle Sql

Date format changing while processing SAS file to oracle Sql

Re: Price change and volume change (Price Elasticity Concept)

Price change and volume change (Price Elasticity Concept)

Re: Transpose data

Transpose data

how to consider Average Value for missing Prices?

Transpose Help!

Help on Import data

Date based Query in SAS

How to obtain increase/decrease price change by date in sas?