About efunk

efunk · ‎05-17-2011

Works like a charm this time. Thank you, SPR.

efunk · ‎05-17-2011

Ok, I might have been to excited about this and jumped to the conclusions too quickly. SPR, your method isn't working as it should, I'm getting W0(there is no such thing as week 0), and only up to W5 in the whole year. I'm guessing it converted to something else. And darrylovia, maybe you know, why proc SQL doesn't group by with your format?

efunk · ‎05-17-2011

Both of your methods works good. I went with darrylovia's method. Thank you, guys.

efunk · ‎05-17-2011

Ok, let's say I have imported retail sales dataset with date formated like this: 2009.01.05 2009.01.06 ... 2010.01.05 ... 2011.01.05 I want to work with weekly results of sales, how to I convert this date format to something like this: 2009w1 2009w1 ... 2010w1 ... 2011w1 etc... Or if that's not possible, maybe change date to corresponding weeks Sunday date. for example if 2009.01.19 is 2nd weeks Saturday, change all dates: 2009.01.13 2009.01.14 2009.01.15 2009.01.16 2009.01.17 2009.01.18 to 2009.01.19 Help much appreciated. Message was edited by: efunk Message was edited by: efunk

efunk · ‎03-16-2011

Thank you. This helped me a lot.

efunk · ‎03-16-2011

No one really knows how to do it?

efunk · ‎03-15-2011

I want to plot 3d Graph y*x=z with y=sales(numeric), x=week(numeric) and z=region(char). Is it possible to do so? I know that PROC G3D asks for all three values to be numeric, but maybe there is some workaround?

efunk · ‎03-14-2011

Works perfectly. Thank you all for lightning fast support. Special thanks to Marius.

efunk · ‎03-14-2011

It is essential for me that region names would be left in the table as I need to know in which region those sales were made. There's almost zero chance for ties as all sales(currency) in real data have 13 decimal places, for example: 29.6044367170295 Message was edited by: efunk

efunk · ‎03-14-2011

There are two countries, around 50 regions and a lot of different items in my dataset. What I want to do? Leave in table only rows with top 3 "sales" for each country, each item and week. In other words, if I have data like this: Country Region Item Week Sales LV r1 i1 1 12 LV r2 i1 1 11 LV r3 i1 1 10 LV r4 i1 1 15 LV r5 i1 1 13 ...... LT r6 i1 1 12 LT r7 i1 1 10 LT r8 i1 1 11 LT r9 i1 1 18 LT r0 i1 1 20 I want to get such results: Country Region Item Week Sales LV r1 i1 1 12 LV r4 i1 1 15 LV r5 i1 1 13 ...... LT r6 i1 1 12 LT r9 i1 1 18 LT r0 i1 1 20 Is it possible to do so? I got a feeling it should be possible with PROC UNIVARIATE, but not sure, how. Message was edited by: efunk

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Convert full date to year and week of the year?

Re: Convert full date to year and week of the year?

Re: Convert full date to year and week of the year?

Convert full date to year and week of the year?

Re: 3D graphics with z being a region name(char value)?

Re: 3D graphics with z being a region name(char value)?

3D graphics with z being a region name(char value)?

Re: Is it possible to leave only largest values in table?

Re: Is it possible to leave only largest values in table?

Is it possible to leave only largest values in table?

Re: Convert full date to year and week of the year?

Re: Convert full date to year and week of the year?

Re: Convert full date to year and week of the year?

Convert full date to year and week of the year?

Re: 3D graphics with z being a region name(char value)?

Re: 3D graphics with z being a region name(char value)?

3D graphics with z being a region name(char value)?

Re: Is it possible to leave only largest values in table?

Re: Is it possible to leave only largest values in table?

Is it possible to leave only largest values in table?