Are these data the whole content of your dataset? If it is, it is much achieved. [pre] data op; set yourdataset end=last; retain _start _obs ; if _n_ eq 1 then do; _start=start_dt; _obs=obs;end; if last then do; _end=end_dt; output; end; keep _obs id _start _end; run; [/pre] If you have a couple of groups of id ,then using 'first.id' 'last.id' to get it. It somewhat looks like the previous post in this forum?? Weird!! Ksharp ... View more

Hi. There are several System Options can adjust the margin of RTF file. [pre] options topmargin=4 cm bottommargin=4 cm leftmargin=0 cm rightmargin=0 cm nodate nonumber center ; [/pre] Ksharp ... View more

Hi. Why are your logic so complex always. I totally be messed up by it. [pre] options missing=.; data temp; input ID $ PROD $ DATE1 : yymmdd8. DATE2 : yymmdd8. AMOUNT CAT$; datalines; 10 111 20050108 20050110 100 B 10 111 20050112 20050117 500 A 10 111 20050121 20050124 200 B 10 222 20050110 20050112 150 B 10 222 20050115 20050120 250 B 20 222 20010601 20010616 700 B ;run; proc format ; value st .= ' ' low-high=[yymmddn8.] ; run; proc sort data=temp; by id prod; run; data op; set temp; by id prod; retain pr1 pr2 strt1 strt2 stp1 stp2 am1 am2 _cat d1 d2; keep id pr1 pr2 strt1 strt2 stp1 stp2 am1 am2 _cat d1 d2; format strt1 stp1 strt2 stp2 st.; if first.prod and last.prod then do; pr1=prod; strt1=date1; stp1=date2; d1=date2-date1; am1=amount; _cat=cat; call missing(pr2,strt2,stp2,d2,am2); output; end; else do; if first.prod then am=0; am+amount; if first.prod and first.id then do; strt1=date1; pr1=prod; _cat=cat; end; if cat eq 'A' then _cat='A' ; if last.prod and not last.id then do; am1=am; stp1=date2; end; if first.prod and not first.id then do; strt2=date1; pr2=prod; end; if last.prod and last.id then do; am2=am; stp2=date2; d1=stp1-strt1; d2=stp2-strt2; output; end; end; run; proc report data=op nowd out=result(drop=_break_); column id pr1 strt1 stp1 d1 am1 pr2 strt2 stp2 d2 am2 _cat ; run; proc print noobs;run; [/pre] Good Luck. Ksharp ... View more

Just to add something into Cynthia's code. [pre] ods tagsets.excelxp file="C:\temp\LA.xls" style=listing options(doc='Help'); options missing='0'; ods listing close; ods escapechar='~'; proc report data=sashelp.class nowd contents="Claims" out=test style(summary)=Header{foreground=purple background=cxeeeeee bordertopwidth=2 borderbottomwidth=0 bordertopcolor=cyan borderbottomcolor=_undef_ bordertopstyle=solid borderbottomstyle=_undef_}; column age sex name weight height; define age / order 'ID' style(column)={just=l}; define sex / display 'Job' style(column)={just=l}; define name / display 'Date'; define weight / display 'Class/Injury'; define height /sum; break after age / summarize ; compute sex; if sex eq 'F' then call define(_row_,"style","style=[background=yellow]"); endcomp; compute after age; str=repeat('=',44) ; line "~S={font_weight=bold} " str $44.; line ' '; endcomp; run; ods tagsets.excelxp close; ods listing; [/pre] And hope Cynthia can use ODS ESCAPECHAR to make the underline blod. Ksharp Message was edited by: Ksharp ... View more

OK. That is much more clearer. If I have understand your logic totally. As you said, you have sort the postnumbercode from smallest to largest. [pre] data temp; input post $ code $; cards; Y A Y A Y A Y A Y A Y B Y B Y B Y D Y A Y A Z C Z C ;run; proc sql feedback; select * from temp group by post having count( distinct code ) ge 2 ;quit; [/pre] Ksharp ... View more

What your txt file looks like exactly? And what you want dataset to look like? Your data is ambiguous. ... View more

Hi. Not sure what variables you need to sum. But SUM function supports not only list input but also colon input. For example you need to sum January and February. [pre] sum(of jan: feb:) [/pre] Ksharp ... View more

[pre] PROC EXPORT DATA=sashelp.shoes FILE="c:\new.xls" DBMS=XLS REPLACE; SHEET='Invoice'; putnames=no; RUN; [/pre] ... View more

Hi. Do you use proc sql to create index? and using proc contents to view the index is really created? ... View more

Hi. When I look up documentation about excel,I found another proc can do it. [pre] proc dbload dbms=excel data=sashelp.class; path='c:\mydata.xls'; putnames=no; limit=0; load; run; [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. Maybe you can use scan() function to achieve it. Not test. [pre] data cc; infile cards; input ; a=scan(_infile_,1,',~'); b=scan(_infile_,2,',~'); c=scan(_infile_,3,',~'); cards; A,1,13 B~2,15 c,D~20 ; run; proc print noobs; run; [/pre] Ksharp ... View more

Hi. I suppose You can interpret it the same as varibales without log transformed. Because log transformed is monotonous increasing, that means the value of this variable is larger and log transformed of this variable is also larger. The target of log transformed of the variable Maybe is to make distribution of variable to approach Normal distribution which can fit the model better. Ksharp ... View more

That is impossible.If dependent variable is continuous,that is not necessary to use logistic distribution to map discrete value to infinite(negative and positive ).If dependent variable is continuous ,GLM is suited for that. The appearance of logistic model is just to solve the problem of discrete value of dependent variable. Ksharp ... View more

Sorry.I have no clue about this . Maybe you need to judge the number of observations of sub-dataset to decide to call macro. [pre] proc sql; select nobs into :_nobs from dictionary.tables where libname ='WORK' and memname='TABLENAME';quit; [/pre] if &nobs ne 0 then ' proc export ' Ksharp Message was edited by: Ksharp ... View more

Hi. Just as Cynthia said,If flag2 is character ,why using ' flag2 ne . ' ? Your data structure is ambiguous. [pre] data temp0; input var $ flag1 flag2 $3. text & $50.; datalines; Test1 1 7. This is test string Test1 1 12. This is test string Test1 2 This line needs to be added to previous line Test2 1 55. This is test string Test2 2 This line needs to be added to previous line run; proc sort data=temp0; by var; run; data temp1 index(keep=var text rename=(text=_text)); set temp0; by var; if last.var then do; output index; delete; end; output temp1; run; data temp2; merge temp1 index; by var; run; data op(drop=text _text); set temp2; by var; length __text $ 100; __text=text; if last.var then __text=catx(' ',text,_text); run; proc print noobs;run; [/pre] Ksharp ... View more