Hi...I am trying to calculate the number of days, weeks, months and years between successive claims for each ID. I am getting some unusual results. This is the code I am using:   proc sort data=Summary;      by ID Claim_Date; run;   data pc1;      set Summary;      by ID;            if first.ID then do;                 Number_Days = .;                 Number_Weeks = .;                 Number_Months = .;                 Number_Years = .;            end;            else if ID = lag(ID) then do;                 Number_Days = (intck('Day', lag(input(put(Claim_Date,8.),yymmdd8.)), input(put(Claim_Date,8.),yymmdd8.),'c'));                 Number_Weeks = (intck('Week', lag(input(put(Claim_Date,8.),yymmdd8.)), input(put(Claim_Date,8.),yymmdd8.),'c'));                 Number_Months = (intck('Month', lag(input(put(Claim_Date,8.),yymmdd8.)), input(put(Claim_Date,8.),yymmdd8.),'c'));                 Number_Years = (intck('Year', lag(input(put(Claim_Date,8.),yymmdd8.)), input(put(Claim_Date,8.),yymmdd8.),'c'));            end; run;   This is what I get:   Claim_Date ID Number_Days Number_Weeks Number_Months Number_Years 20141003 100001945 . . . . 20090902 100002160 . . . . 20090902 100002160 . . . . 20090902 100002160 . . . . 20090903 100002160 1 0 0 0 20111124 100002727 . . . . 20111124 100002727 . . . . 20111124 100002727 812 116 26 2   This is what I want:   Claim_Date ID Number_Days Number_Weeks Number_Months Number_Years 20141003 100001945 . . . . 20090902 100002160 . . . . 20090902 100002160 0 0 0 0 20090902 100002160 0 0 0 0 20090903 100002160 1 0 0 0 20111124 100002727 . . . . 20111124 100002727 0 0 0 0 20111124 100002727 0 0 0 0   Thanks. ... View more

Hi...I am creating a report using ODS PDF and can't seem to figure out how to change the number of rows of output on each page of the report. Right now, I am getting 34 rows of actual data on each page and there is a large space or gap between each row as if a blank row was inserted in between each row of data. I would just like to have as many rows of data on each page as possible and can fit, Thanks ... View more

Hi....I am having trouble getting the output in the proper form. The output results in that data forming a "Step" appearance for each "FiscalYear" as the output for the first FiscalYear in cells a3:d12 and the output for the second FiscalYear is in cells e13: h22 and so on. I want the all of the output along rows 3 - 12 across the columns. Thanks.     PROC REPORT DATA=Summary NOWD SPANROWS; COLUMN ("Top 10 Sales Products" (COUNT FiscalYear,(ID PROD1 Number_Requests))); DEFINE COUNT / DISPLAY 'Rank Number' STYLE(COLUMN)={TAGATTR='format:#,##'}; DEFINE FiscalYear / ACROSS 'Fiscal Year' STYLE(COLUMN)={borderwidth=1px FRAME=box rules=cols }; DEFINE ID / 'Product ID' ; DEFINE PROD1 / 'Product Name'; DEFINE Number_Requests / 'Number Requests' STYLE(COLUMN)={TAGATTR='format:#,##'}; RUN; QUIT; ... View more

Hi....I want to be able to select the last value across each row for each row. Is it possible to do the selection without having to transpose the dataset. Thanks.   Have: Column1 Column2 Column3 Column4 Column5 201011 201112 201213     201213 201314       201516         201112 201213 201314 201415 201516   Want: Column 201213 201314 201516 201516   ... View more

Hi....I am trying to calculate the number of days from a clients DOB and a date. I am using INTCK Function and it seems to work until the clients DOB falls on a Leap year. Any suggestions to to fix this....Thanks   ((intck('Day',input(put(client_dob,8.),yymmdd8.),input(put(date,8.),yymmdd8.),'c'))) as Number_Days ... View more

Hi...I am having problems with incrementing a count. For each ID, starting at 1 and increment by 1 when their is a change in the Program type and retain the count and increment by 1 when there is another change in the Program type. Thanks.   DATA GROUP58B;      SET GROUP58A;      COUNT+1;      RETAIN COUNT;            BY ID;                 IF FIRST.ID THEN COUNT=1;                 IF ID = LAG(ID) AND PROGRAM = LAG(PROGRAM) THEN COUNT = 1; RUN;       Have:   DATE ID PROGRAM COUNT 20130219 130439 HCP 1 20140121 130439 HCP 1 20140403 130439 HCP 1 20160314 130439 PCP 2 20160314 130439 PCP 1 20160415 130439 PCP 1   Want:   DATE ID PROGRAM COUNT 20130219 130439 HCP 1 20140121 130439 HCP 1 20140403 130439 HCP 1 20160314 130439 PCP 2 20160314 130439 PCP 2 20160415 130439 PCP 2 ... View more