sas_datalover's articles:

Items(106) /11 Next >> Last >|

Re: Computing growth rates 0 18 (4/23/2008 3:42:47 PM) comp.soft-sys.sas I am trying to compute the growth rate for my data based on a week 1 value (the base). The values would be as below (computed in Excel). NOw I wonder how I would do it in SA, if I had a billion rows of data. ... sas_datalover

Re: How can one use SAS to view data in 3 dimensional space #9 0 30 (4/14/2008 5:56:54 PM) comp.soft-sys.sas I appreacite the kind advice.. I doubt i will be sending any of that to people in this office though :) Nat Wooding wrote: Syb A word of warning about SAS graphs rendered with active-x in case you decide to... sas_datalover

Re: How can one use SAS to view data in 3 dimensional space #4 0 25 (4/14/2008 12:23:19 PM) comp.soft-sys.sas Thanks a lot Ya Huang... That's a very neat feature.. of proc g3d; HAve a good day. Ya Huang wrote: Forgot to say: to play the plot, right click the figure, then click mouse control, then click the secon... sas_datalover

Re: How can one use SAS to view data in 3 dimensional space 0 20 (4/11/2008 9:20:40 PM) comp.soft-sys.sas Dear all, I have a bankruptcy dataset that I am trying to understand better. I'd like to view the entire data set in x1, x2 and x3 space.. I'd like to rotate the co-ordinates in various directions.. and chec... sas_datalover

Re: How to Report output from a count as a TABLE #3 0 18 (4/11/2008 1:11:33 PM) comp.soft-sys.sas Thanks Howard... I understand your point about it being a lil more difficult to work with multiple tables... but sometimes, its the way forward. "Howard Schreier " wrote: On Fri, 11 Apr 2008 05:33:56 -07... sas_datalover

Re: How to Report output from a count as a TABLE 0 21 (4/11/2008 12:33:56 PM) comp.soft-sys.sas Dear All, Say one wanted to count the number of people in each of these multiple files, and wanted the output to be all in ONE table, how could it be done? I just want to avoid having to note down the numb... sas_datalover

Re: Selecting a record just prior to "W" #8 0 22 (4/7/2008 1:12:13 PM) comp.soft-sys.sas Howard, This is not a very simple example as you put it. Look at your output for ID # 3. Your result has this: 3 A 60 09/30/1990 yet on that day, the customer consumed 'W' and NOT A as you have it. I gues... sas_datalover

Re: Selecting a record just prior to "W" #5 0 23 (4/4/2008 10:33:33 PM) comp.soft-sys.sas Here is what I ended up doing: proc sort data = have; by id descending date; run; proc print data=have; run; Data wanted; set have; by id; retain flag counter; if first.id then do; flag = 0; counter... sas_datalover

Re: Selecting a record just prior to "W" #3 0 19 (4/4/2008 9:16:47 PM) comp.soft-sys.sas Could you elaborate.. I came up with some many ways neither appears fool proof. Jack Clark wrote: Syb, Sort and Set your data by ID and descending date. Then within each ID, when product is W you know you w... sas_datalover

Re: Selecting a record just prior to "W" #4 0 21 (4/4/2008 9:15:54 PM) comp.soft-sys.sas You will have to explain a bit. Your code does not seem to do the right thing. What did u not understand about the data? Nathaniel.Wooding@dom.com wrote: Syb Here is my solution. Note that it still includes ... sas_datalover

sas_datalover's replies:

Items(3) /1

computing percentages in sql 3 53 (3/27/2007 2:18:21 PM) comp.soft-sys.sas LAdies and Gents, I am trying to compute percenatges in SQL. I have done it, but i need suggestions for a shorter code. I want to combine Steps 1 & 2. What I did is this: data sales; input @1 ID @9 T... sas_datalover (111)

counting similar prods as 1 4 26 (3/28/2007 5:28:28 PM) comp.soft-sys.sas Dear folks: I wrote this code below: I need to modifiy the output such that for id=2 for example count is 1 instead of 3. ID 4 should have a count of 1 A and 3 B's. Any product that has a similar looking nam... sas_datalover (111)

graph this 7 29 (4/16/2007 1:02:43 PM) comp.soft-sys.sas Dear All, I have sales data that looks like this: Tom James Chris Mike Sean 0.07 0.70 0.07 0.09 0.70 0.07 0.09 0.75 0.08 ... sas_datalover (111)