Hi, I have a date format, e.g. 06/01/1989 and I want a new variable with just the year in it…1989 in this case. However, when I use a substr function, it is returning me odd values. data one; set two; NewVariable=susbtr(date,7,4); run; I checked the column description for the date variable and it says TYP:NUM LENGTH: 8 FORMAT MMDDYY10. INFORMAT MMDDYY10. Where am I going wrong? ... View more

Hi, I have a data set "test" from which I want to select only those observations for which the product column is 6 AND 3 for every group of ID. The desired output table is test1 below. test ID product ----------------------- 101 6 101 3 101 5 101 3 ----------------------- 102 2 102 3 102 6 102 6 ----------------------- 103 6 103 6 103 6 103 6 test1 ID product ---------------------- 101 6 101 3 101 3 ---------------------- 102 3 102 6 102 6 I tried using the following program but it fails to group by the IDs and is returning any observation that is a 6 or a 3. Can anybody please point what's wrong? proc sql; create table test1 as select * from test where product in (6 3) group by hhid; quit; Thanks! ... View more

Hi, How can I write a program that will look for "25" in column B below and stop at the second "25" for the same group in column A? I have been using the index feature to account for the double entries in column B but am at a loss on how to proceed in this case. A B 1 25 1 30 1 36 2 25, 52 2 40 2 25 Desired output: A B 1 25 1 30 1 36 2 25, 52 2 40 ... View more

Can I include dummy variables in proc glm? I use the following but am not sure if the results should look the way they do. proc glm data=final; class income_bracket kiddummy year; model units= units_cat kiddummy |year; lsmeans kiddummy year /adjust = tukey; run; ... View more

Can I include dummy variables in proc glm? I use the following but am not sure if the results should look the way they do. proc glm data=final; class income_bracket kiddummy year; model units= units_cat kiddummy |year; lsmeans kiddummy year /adjust = tukey; run; ... View more

I have a dataset that looks like the one below. The date column is sorted. I’m trying to create a table which will summarize • If the “first” purchase in 2005 is product ‘2’ and then • How many units of products 7 & 9 were bought by the person (ID) over the following years I tried using Proc Summary. The problem is that there are multiple cases in which the person bought products 2 along with something else on their first purchase in 2005 (hence the multiple units & cost entries in certain rows). I have put them with commas to make a distinction. However, my dataset has them in the same box and separated by a space. ID date product units cost($) trip 1 1/28/2005 2 1 20 1 1 2/3/2005 99 1 24 2 1 2/4/2007 9 1 24 3 1 4/13/2008 8 1 30 6 1 7/27/2008 8 1 30 7 1 11/9/2009 8 1 30 8 2 7/31/2005 7 1 25 1 2 3/20/2006 9 1 24 2 2 1/12/2007 9 1 14 3 2 2/6/2008 9 1 40 4 2 10/16/2009 9 1 19 5 3 3/24/2005 2,9 1,1 40 1 3 10/18/2006 4 3 45 2 3 5/6/2007 2 1 39 3 3 5/7/2007 99 1 39 4 3 4/17/2005 2,9 3,2 75,120 1 3 4/23/2005 7, 9 1,1 25,40 2 ... View more

I’m new to the macro facility and was trying my hand at writing a code that would give me frequency tables for different products by different years. The code I wrote gives me frequencies for all the products instead of selecting the product and year combinations I specify in the macro. Can anybody please correct the program? Thanks! data fruits; set fruitdata; if date gt 'XXX'd and date lt 'XXX'd then year= '2007'; if date gt 'XXX'd and date lt 'XXX'd then year= '2008'; if date gt 'XXX'd and date lt 'XXX'd then year= '2009'; if fruit= ‘orange’ then product= '1'; else product ='0'; if fruit= ‘apple’ then product= '2'; else product ='0'; if fruit= ‘pear’ then product= '3'; else product ='0'; run; %macro test(year=, product=); proc freq data= fruits; table fruit; title ‘Sale of product& in year&'; run; %mend; %test(year= '2007', product= '1'); %test(year= '2007', product= '2'); %test(year= '2007', product= '3'); %test(year= '2007', product= '1'); %test(year= '2007', product= '2'); %test(year= '2007', product= '3'); %test(year= '2009', product= '1'); %test(year= '2009', product= '1'); %test(year= '2009', product= '1'); ... View more

I have a dataset with purchase history (dates of purchase) of a product for different consumers. The dates of purchase (in the DD/MM/YY format) are sorted by consumers. I want to calculate the average time between two buys for each consumer. Can anybody please help? The product category is not important here, just the time between two purchases. The data looks like this: Date Consumer Product 1/1/08 1 24 1/1/08 2 23 6/2/08 2 24 2/3/07 3 22 7/3/08 3 24 4/4/06 4 25 2/4/07 5 23 5/9/07 5 23 Thank you. ... View more