The TODw. format will write a leading 0. data POLAIM_ADD_FORMAT; set POLAIM_MERGE; mydate =datepart(LOAD_LAST_DATETIME); mytime = timepart(LOAD_LAST_DATETIME); format mydate ddmmyy10. mytime tod5.; LOAD_LAST_DATETIME_NEW= put(mydate,ddmmyy10.)||' '||put(mytime,tod5.); run; ... View more

The ID Statements turns the values into the new column names. I would recommend the SAS Documentation for additional information: PROC TRANSPOSE: ID Statement  ... View more

That is coming from the part of the Table statement I have commented out below. I do not think you need that. TABLE /*Row Dimension*/ Name/**'N' = ' ' */ ALL*{style=[ font_weight=bold just=center background = cxE5B82E foreground=black BORDERCOLOR=cxE5B82E Font=("Trebuchet MS",9pt)]} , ... View more

You can use PROC TRANSPOSE to do this. It requires multiple steps. Code is below. /* create sample data */ data one; brand='Toyota'; input model $ jan_sales feb_sales jan_carsold feb_carsold trend $; cards; VIOS 10 15 1536 1985 Increase CAMBRY 15 12 1684 1430 decrease YARIS 11 15 1356 175 Increase AVANZA 9 10 1123 1254 Increase ; run; proc sort data=one; by brand model trend; run; proc transpose data=one out=two; by brand model trend; var jan_sales feb_sales jan_carsold feb_carsold; run; data two; set two; varname=scan(_name_,1,'_'); type=scan(_name_,2,'_'); drop _name_; run; proc sort data=two; by brand model trend type; run; proc transpose data=two out=three(drop=_name_); by brand model trend type; var col1; id varname; run; proc print data=three; run; ... View more

If you run my code that uses PROC SUMMARY, X is set to missing for the additional rows. ... View more

You could use PROC SUMMARY with COMPLETETYPES to get the desired results.   data have; input Id Date :anydtdte. FirstName $ LastName $ x ; format date monyy6. ; datalines; 123 Apr-22 A B 20 123 Apr-23 A B 30 123 Apr-24 A B 40 124 Apr-22 E F 10 125 Apr-22 G H 10 125 Apr-23 G H 10 ; run; proc summary data=have completetypes nway; class id date; id firstname lastname; var x; output out=want(drop=_type_ _freq_) sum=; run; data want; set want; if firstname ne ' ' then temp=firstname; else firstname=temp; if lastname ne ' ' then temp1=lastname; else lastname=temp1; retain temp temp1; drop temp temp1; run; proc print data=want; run; ... View more

LOGNUMBERFORMAT is still considered internal and is not documented with PROC OPTIONS because it is limited in scope. It is only intended to affect the formatting of a limited number of numeric values in the log. It does not translate to other system or data set options, such as OBS= or FIRSTOBS=. ... View more

Here is some code to get you started. It is not clear what you are trying to do with #4. proc report data=mnthly_sales; column cty zip var sales; define cty / group 'County/Name'; define zip / group; define var / group descending; define sales / sum format=8.2; run; ... View more

The following style template adds a visible top and bottom page margin, but I have not found a way to add a left or right margin. This also adds a blank Footnote. proc template; define style styles.test; parent=styles.rtf; class systemtitle / bordertopcolor=black bordertopwidth=2pt; class systemfooter / borderbottomcolor=black borderbottomwidth=2pt; class body / frame=box; end; run; ods _all_ close; ods RTF startpage=no file="c:\temp\test.rtf" NOGTITLE NOGFOOTNOTE style=styles.test; options nonumber nodate; title PAGE BORDER; footnote ' '; ODS RTF startpage=now TEXT="{\pard\b\qc {PAGE1} \par}"; RUN; proc odstext; p "REPORT:" /style=[fontweight=bold textalign=c fontsize=20pt fontfamily=Arial]; run; proc report data=sashelp.cars contents="Honda Cars"; where Make="Honda"; column ("Car" make model) ("Cost" msrp invoice) ("Fuel Efficiency" mpg_city mpg_highway); run; ODS RTF startpage=now TEXT="{\pard\b\qc {PAGE2} \par}"; RUN; proc report data=sashelp.cars nowd OUT=QUARTILES; column origin type msrp msrp=msrp2 msrp=msrp3 msrp=msrp4 msrp=msrp5; define origin / group; define type / group; define msrp / p25; define msrp2 / median; define msrp3 / p75; define msrp4 / min; define msrp5 / max; run; ods RTF close; ... View more

There are no debt_code values in common in either data set and the one you mention does not exist in either. I had to modify the code below to get it to run successfully. Can you run this and then explain what you are expecting to get? data Accounts_In_120A; input rep_code :$4. debt_code :$9.; datalines; 120A 307828335 120A 360588099 120A 335051207 120A 100020874 120A 307838722 120A 307843532 ; run; data Manual_Tracing; input icustomerid :$8. debt_code :$9. tran_code :$6. Trace_date :date9.; format trace_date date9.; datalines; 13431155 100719376 MO9747 18JAN2023 4684004 100980689 MO9746 04JAN2023 159855 10099664 MO9745 09JAN2023 5184570 101041721 MO9746 11JAN2023 21818771 101320083 MO9746 20JAN2023 20673429 101760858 MO9747 17JAN2023 ; run; proc sort data=accounts_in_120A; by debt_code; run; proc sort data=manual_tracing; by debt_code; run; data Adding_120A ; merge Accounts_In_120A Manual_tracing ; by debt_code; run; proc print; run; ... View more

Try the following revised code: proc tabulate data=have format=6.0 style=[font_size=5pt just=c fontstyle=italic borderwidth=0 cellpadding=0 foreground=dimgray]; class drug period visit / order=data style=[textalign=center ] missing; classlev drug period visit/ style=[background=white font_weight=bold font_size=5pt foreground=dimgray cellpadding=2]; var number_of_patients/; keyword all sum /style=[background=white font_weight=bold font_size=5pt foreground=dimgray]; table drug=' '*period=' ', visit*number_of_patients=' '*(sum=' ' colpctsum=' '*f=8.1); run; ... View more