About LNM

LNM · ‎06-12-2019

I have more than 1000 departments. So I need to try to expand the namefield when the rwidth=1 is my best choice. Please look at my sample data which only contains 2 departments. Thank you, thank you.

LNM · ‎06-12-2019

Here's my attached codes in notepad

LNM · ‎06-12-2019

Sorry for the delay in getting back to you all. I still need help. The data comes to me in a excel spreadsheet. Then I run the print program. I have created an attached small sample. Thank you, thank you.

LNM · ‎06-11-2019

Here's the sample data. I would like the department names with rwidth=1 not to wrap namefield amount Pos_Pool jobfield combo_cd bold rwidth 444444-Tesing the Namefiled if row width can be extended 1 1 112121-The Northwest Tornado Cha sers 1 1 1 Mary McKee 10000 11112222 Administrative Assistant ztornado-WA1 Mary McKee-1 200000 00011122 Administrative Assistant ztornado-WA1 Mary McKee-2 155555 01112222 Administrative Assistant 725ztornado-WA1 Thank you, Lile

LNM · ‎06-11-2019

Here's what I am try to code. Can you help me with the syntax? Please. Here's what I coded. Can you help me with the syntax? Please. compute rwidth; if rwidth eq 1 then call define(_row_,style(column)={cellwidth=4.5 in just=l}); endcomp; Thank you. LNM

LNM · ‎06-11-2019

Here's what I coded. Can you help me with the syntax? Please. compute rwidth; if rwidth eq 1 then call define(_row_,style(column)={cellwidth=4.5 in just=l}); endcomp; Thank you.

LNM · ‎06-10-2019

I have set my namefield column width. However the namefield also contains titles for each department. I don't want the department titles to wrap because there's no data in the next column when I print the department titles. I have assigned a 1 to the rows that I don't want to wrap. My codes is attached.

LNM · ‎05-07-2018

Thank you, your comment is very helpful.

LNM · ‎05-07-2018

It works beautifully. Thank you, Thank you!!

LNM · ‎05-07-2018

ods listing close; options nonumber nodate orientation=portrait papersize=LETTER missing=''; ods escapechar= '!' noproctitle; options nobyline; ods pdf file="C:\testing_050718.pdf" style=styles.style1; proc report data=print04 nowindows missing spacing=1 style(report)={just=left} split='|'; title "#testing"; I changed it above. Now my title changed to #testing on every page. It's not giving me the value of testing which is 1000. Any more suggestions?

LNM · ‎05-07-2018

When I run my proc report below: proc report data=print04 nowindows missing spacing=1 style(report)={just=left} split='|'; by testing; It prints testing on every page just like I want to. The title looks like this: Testing=1000 I want to keep the '1000' which is the value of testing but remove the 'Testing=' part. In short I just want '1000' to print by itself. Thank you.

LNM · ‎03-24-2017

Thank you, it works!

LNM · ‎03-24-2017

Thanks a lot, it works!!

LNM · ‎03-23-2017

I need help concatenating my two dates to a comment field. Here's what I have DATA PRX; SET BICS_02; format prx_startdt prx_enddt mmddyy10.; /*format to mm/dd/yyyy*/ prx_startdt = datepart(Optional_1_start_date); /*optional date is date and time*/ prx_enddt = datepart(Optional_1_end_date); /*optional date is date and time*/ period_comments = prx_startdt||" to "||prx_enddt; /*combine the dates in comment "start date to end date"*/ run; prx_startdt and prx_enddt just post the date values. I have converted it to the right format but in the doesn't translate correctly to my comments field. Please help.

Online Status	Offline
Date Last Visited	‎06-12-2019 07:09 PM

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Expanind titles -not to wrap when the column width has been set

Re: proc report

Re: proc report

Re: proc report

Re: proc report

Re: proc report

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Re: Expanind titles -not to wrap when the column width has been set

Expanind titles -not to wrap when the column width has been set

Re: proc report

Re: proc report

Re: proc report

proc report

Re: Concatenating two dates

Re: Concatenating two dates

Concatenating two dates