HI Jagadishkatam, thanks for response I ran your test code and the output is description. Col1. col 2. col3. col4 supplier1. 1. 1. 1. 1 supplier2. 1. 1. 1. 1. supplier3. 1. 1. 1. 1 I would like for it to look like this description 04/01/15. 04/02/15. 04/03/15 supplier1. 23. 15. 45 supplier2. 12. 33. 22 supplier3. 0. 47. 54 i need count of each incidents thank you
... View more
hI Arthur, Thank for response I ran the script you provided and it only gives Date from 04/06/15-04/09/15 the table. That has 04/01/15-04/09/15 that shows partial days... In addition how can I sort date to show most current date first ... And last question how can I export the results to a excel tab ? My output added- name: table label: table1 data name; report path. Tabulate.report.table thank you
... View more
HI I have a data set that looks like this ID. Date. Device description A1. 03/01/15. R150. Supplier 1 a2. 03/02/15. R 161. Supplier2 b1. 03/03/15. R152. supplier3 i need it to look like this 03/01/15. 03/02/15. 03/03/15 supplier1. 1 supplier2 1 supplier3. 1 it counts each incidents by date
... View more
hi I have a table that looks like thi . City. Market. Sub market Houston. A. b NeW York. Q san fran. Austin. D. i have a data step looks like this ddata report; set report; if sub market = ( .) then market = sub market; run; i shan't the value that is in the maket column an not the word sub market if market is blank as well thN it should default to city value not name city ...thanks again
... View more
Thanks Rw9 ITs worked great I have a question instead of sum if I wanted to get the mean of how many amts we get per day of week do change sum to count and get mean some where else ? Thanks for assistance
... View more
SSorry ballardw For not explaining myself my data looks like this The data will be a month worth of data I would need to get a count of how many came in per week of day Monday tueday wed Thur fri sat sun After I get total for each day I would need than avg of the total nname. Day of week amt. Bag A. Mon. 34. S A. Mon. 23. S A. Mon. 37. S B. Tue. 56. S b. Mon. 12. S B. Thur. 56. S
... View more
thank for your response AMt is not that important I need to get the number of entries and group by day of week for exmple it happens 10 times every monday but once I get a count by day of week I would then want an avg of what gets produce in a month view broken out by day of week fo exmple feb report name. Mon tue. Wed Thur fri sat sun a. 50. 23. 78. 34. 12 45. 58 b. 12. 34. 76. 12. 43. 12. 12 that is avg number A has incidents coming in so our highest would be wed for a on a monthly view
... View more
Hi have proc table looks like this proc sql; create table table1 as (select name, day of week, amt, bag from table ); run; data looks nname. Day of week amt. Bag A. Mon. 34. S A. Mon. 23. S A. Mon. 37. S B. Tue. 56. S b. Mon. 12. S B. Thur. 56. S what I need for the output to look is like this Mon. Tue. WeD. Thur. Fri. Sat. Sun A. 3. 3. b. 1. 1. 1 since this is a monthly pull I need the avg amt of bags that come in the day of week Mon tue wed Thur fri sat sun thank you for your help
... View more
hi I have a table that shows 8 days worth of data which includes today's date I need to exclude today's date ... the he data looks like this 03/13/15. Tid 03/14/15. Tid 03/15/15. Tid 03/16/15. Tid 03/17/15. Tid 03/18/15. Tid 03/19/15. Tid 3/20/15. Tid I Need to remove current date since its a partial data and keep first 7 days thanks
... View more
PGSTATS i using your example I tweaked it to fit my code proc sort data = part2; by number; run; proc transpose data = part2 out temp(drop=_:) prefix = v_; by number ; id facevalue; idlabel facevalue; var ebal; run; i get this error message error The id value "v_1_00" occurs twice in the same by group. note the above message was for the following by group number = 4407 it happens six more time same error message different number tthanks for your assistance
... View more
hi i have a table that looks like this number. Value. Balance 1. 1. 1 1. 2. 5 1. 3. 10 1. 4. 20 I Would like it to look like this number Balance. 1. 2. 3. 4. 1 36 1. 5. 10 20 thanks again
... View more
I Think I found the error in mytable I have a date time field but when I enter no value in it this date 01/01/00 stored automatically into it i want to keep the field null where there is no value i notice that my issue is the same. The col has more blanks than entries since it's the date of deinstalled an where there is no date it defaults to 0/01/00 I would like to have it empty or null
... View more
I Thought I could be slick an convert date to character an than join table dive I just need to match another character date an even after I change it to date character it still change format to 01/01/00
... View more
THe table looks like this proc sql; create Table audit as ( select A.id, a.owner, b.active2, b.date, c.active1 from table a, table b, table c where a.id = b.id and a.id=c.id ); quit;
... View more
