Hi, Can anyone help me in creating a pdf report with 14 columns in portrait? When i do proc print to ODS PDF table has been breaking into 9 and 5 columns. I tried decreasing size of font and using split option but it didnt work. I have to add this page to 32 other pages in the report. Could any of you suggest me a way to do it without affecting options of other 33 pages? Thanks, RK
... View more
Hi all, Can any one help me out with the following? i want to get max(cnt) by date upto that particular date. For example i want my result dataset to be like below. datalines; date cnt 23march2013 10 24march2013 25 14april2013 15 15april2013 30 18april2013 17 result dataset: date max(cnt) 23march2013 10 24march2013 25 14april2013 25 15april2013 30 18april2013 30 Thanks in advance, RK
... View more
Hi, Is there a maxdec option in Proc Univariate? I am comparing two variables' descriptive stats and i need precision upto 10th decimal. Thanks in advance -- RK
... View more
Hi Reeza, Thank you for the response. I am using the following code to get top two dealers for each event date (that is each friday) but I couldn't get because the count is increasing by 1 for each dealer on the same date itself. Could you help me out with this? proc sort data=dealers; by event_dt id descending size; run; data lib.dealers; set dealers; by event_dt id; retain count 0; if first.event_dt and first.id then count=1; else count=count+1; run; Thanks, RK
... View more
Hi, Could some one answer my question? I need to find top two values for a variable (say top_car_make) that is found based on summary variable (cars_sold) over last tweleve months for each friday. Each friday we have to look back twelve months and calculate top two cars sold for a dealer. The obs are grouped as dealerID, car_make and date. Thanks,RK
... View more