About Niugg2010

Jagadishkatam · ‎04-13-2017

Thanks, Could I request you to please mark this answer correct, it will help everyone in the community to quickly point to the best answers.

Niugg2010 · ‎04-13-2017

Thanks. Your method is novel. The code is short, but learn a lot. I transposed the datasets first, and dealt with the data, then transposed back.

Cynthia_sas · ‎02-23-2017

Hi: Another way that you can do it (using the slightly different data that I posted) is to use the Report Writing Interface. It does the type of column-spanning you want. However, the RWI is not supported for RTF, but is supported for PDF. See below: As you can see, it is possible to get what you want using the RWI, with a DATA step, not PROC REPORT. There will be a WARNING in the log if you use the code with RTF. Just remember that if you cannot use PDF for this, then your choice is to use PROC REPORT to get RTF and the first example I posted. Or to switch to PDF and get the above example. Hope this helps, cynthia

Niugg2010 · ‎02-16-2017

There are some difference. If there is no startpage=now. The content of ods text will be in the same page as the last output.

BrunoMueller · ‎02-03-2017

Hi As an alternate method you could make use of the "COMPUTE AFTER" block. Using this method the text is written as part of the table, and is therefor part of the table measuring, see sample code below title; ods rtf file="C:\temp\rtf111.rtf"; ods escapechar="^"; proc report data=sashelp.cars (obs=36) nocenter; column rowid Make Model; define rowid / computed; compute rowid; _rowId + 1; rowId = _rowId; endcomp; compute after / style={just=left}; length msgline $ 1024; msgline = "line1 ^n line2 ^n line3 ^n line 4 ^n line 5 ^n line 6"; l = length(msgline); line msgLine $varying1024. l; endcomp; run; /*ods text="^S={leftmargin=1in}line1 ^n line2 ^n line3 ^n line 4 ^n line 5 ^n line 6";*/ ods rtf close; Bruno

Cynthia_sas · ‎02-02-2017

Hi: This Tech Support note shows the exact syntax you need to use to do what you want to do. My default every procedure step will start a new page. http://support.sas.com/kb/24/559.html cynthia

Niugg2010 · ‎01-06-2017

Thanks.

PGStats · ‎12-29-2016

You can also ask proc fcmp to print the code: proc fcmp; listfunc functionName; run;

Ksharp · ‎11-09-2016

No. You can't. Find some Recovery Software in Internet, maybe that could get you the table back.

KachiM · ‎11-04-2016

Compare() function compares two strings. Returns left-most position of the byte which is not matching and 0(zero) when the two strings are same. Since you have given only two strings which has a differeing byte at the 15-position and I am adding one more string to show that COMPARE() function returns 0. data a; length f1 $ 66; input f1; datalines; GAGCAAGCGCCATACTCCTGTGGAGAAGTCTGCCGTTACTGCCCTGTGGGGCAAGGTGAACGTGGA GAGCAAGCGCCATACTCCTGTGGAGAAGTCTGCCGTTACTGCCCTGTGGGGCAAGGTGAACGTGGA GAGCAAGCGCCATAGTCCTGTGGAGAAGTCTGCCGTTACTGCCCTGTGGGGCAAGGTGAACGTGGA ; run; data _null_; retain old; set a; if _n_ = 1 then old = f1; else do; dif = compare(f1, old); put dif = ; if dif = 0 then put 'No Difference'; if dif ^= 0 then substr(f1, dif, 1) = lowcase(substr(f1, dif, 1)); put f1 = ; end; run;

Niugg2010 · ‎10-30-2016

Thanks a lot. learn a lot.

Niugg2010 · ‎10-29-2016

Cynthia, Thanks. You are right. I also got some errors. I am sure it is ods's reason. However, I am not sure how to use "put" with ODS. Thanks for your response and the suggested document. It is really helpful.

Niugg2010 · ‎10-03-2016

Wendy, Thanks. I got the data using StatExplore node. At beginning I used Code Node to got mean median, then I tried StatExplore node and set USE=YES. I found the results were a little difference, but they were very close. For example for P_TARGET0: when I used code node, median=0.9058705 mean=0.8383493 std=0.1647437 skewness= -1.5372081 Kurtosis=2.1043724; when I used StatExplore node, median=0.903874 mean=0.835846 std=0.166262 skewness=-1.52727 Kurtosis= 2.062464; do you think that is normal? Thanks.

Niugg2010 · ‎10-03-2016

Thanks a lot. It is very helpful.

Niugg2010 · ‎10-02-2016

Thanks.

Online Status	Offline
Date Last Visited	‎06-15-2023 06:22 PM

Re: PDF bookmark issue

PDF bookmark issue

Re: one format question

one format question

Re: Proc lifetest question

Re: Proc lifetest question

Proc lifetest question

Re: data step merge issue

data step merge issue

Re: rtf style attribute

Re: A function issue

Re: character question

Re: character question

Re: about sas template

Re: about sas template

Re: footnote question

Re: proc report procedure

Re: proc report issue

Re: programming issue

Re: proc report issue

Re: ods page break issue

Re: ODS rtf question

Re: ods rtf print issue

Re: ods rtf column width question

Re: user defined function

Re: how can I restore the deleted datasets

Re: character question

Re: about sas template

Re: ODS and template question

Re: Enterprise Miner Score node question

Re: one index function question

Re: import fastq format file