@Angelfish The IT client supports TRIPLEDES but only when installed with other SAS applications such as SAS for Windows or SAS Enterprise Guide. This is a software distribution practice meant to comply with some encryption technology regulations, where only known customers can get this from SAS. (IT client, as-is, is downloadable by anyone.)   This makes the VS Code to SAS OnDemand harder, I know. But I don't have another answer right now. If you are part of an educational institution, I suggest looking into SAS Viya Workbench for Learners. ... View more

I have checked with IT, they said that it is an instance with a Private IP. ... View more

Thank you. I changed format it matched my excel output.   proc format library=work; value dspl low - 3.25 = '2.5' 3.25 <- 6.25 = '5' 6.25 <-high= '7.5' ; run; proc freq data= data.tmpg noprint; tables trt*dspl/outpct out=work.summary; format dspl dspl. ; run; proc sgplot data=work.summary; vbar dspl / group=trt groupdisplay=cluster response=pct_row ; label dspl='Displacement' trt='Treatment' pct_row='Percent of Treatment' ; run; ... View more

Thank you @Ksharp. I have referred links provided by you and GitHub, https://lexjansen.com/ before I write to this forum. Today I received mail from PharmaSUG and they have published 2020 papers. I will also look into those papers. ... View more

PROC HPTMINE is not part of Base SAS ... View more

Well, I don't know that paper, however the process itself sounds backwards.  PDF's are outputs, they are only used for people to look at, they are not conducive to any other process.  Most databases (Oracle, Medidata Rave etc.) have modules designed for standard CRF builds.  These are accessible for Data Management staff - who are responsible for this part - and other users.  It is down to the DM group to create standardised CRF libraries, then use these to implement database builds.  As a programmer, you can simply extract this metadata directly from the database.  This is a preferred method as then all the information done and entered in one place (hence one of the main reasons we use databases in the first place), it is stored in a usable format, and provides the option to extract as raw data or produce reports.  Doing this process the other way, getting an output, then reading that in and processing loses all of this - i.e. if anything changes you need to start again by getting the output and processing it. ... View more

Yes, am fully aware of what xlsx files are, but you did not mention opening on Windows, hence why I point this out.   This is unfortunately the pitfalls of using code downloaded from somewhere, and a major problem with the open source arena in general - knowing what the code does and being able to validate it.  I see that @Kurt_Bremser has answered your question.  I personally would say avoid using some third party script, if you need XML gemerated on Linux for use on a Windows Office (and doesn't it even sound daft), then use ods tagsets.excelxp.  Open Office is, at its core, a bit of a mess, an attempt to move towards open source.   tagsets.excelxp creates plain text one file XML, which can be read and interpreted by Excel amongst other applications.   ... View more

Hi, even though it is mentioned in the doc that the last argument must be an array, there must be a solution. I wonder how it is done for sum, mean, and all the other base math functions that allow variable arguments.. Is there some workaround or how was it done for these kind of functions?   I would really appreciate a more elegant solution.. Cheers, *obj* ... View more

Hi   Check this. I made little change in your code and replaced RTF Tags data class; set sashelp.class; attrib _empty length=$1; _empty=''; run; ods rtf; ods escapechar='^'; GOPTIONS DEVICE=SASPRTC; proc report data=class headline headskip split="$" missing nowd ps=54 style(header)= [background=white protectspecialchars = off just=center vjust=top] contents="" style(report)=[ frame=hsides rules=group cellpadding=1pt cellspacing=.15pt borderwidth=.15pt]; column ('\brdrb\brdrs header1' ('\brdrb\brdrs header11' age Height) _empty ('\brdrb\brdrs header12' Name Sex) ) _empty ('\brdrb\brdrs header2' ('\brdrb\brdrs header21' Weight ) ) ; define _empty/' ' style(column)={cellwidth=10 }; define age / order=data style(column)=[cellwidth=1.5 in just=Left]; define Height / order=data style(column)=[cellwidth=1.5 in just=Left]; define Name / order=data style(column)=[cellwidth=1.5 in just=center]; define Sex / order=data style(column)=[cellwidth=1.5 in just=center]; define Weight / order=data style(column)=[cellwidth=1.5 in just=Left]; run; ods rtf close; ... View more

Hi FlimFlam   Thank you very much. I was looking for this long time. I have written to SAS Support last month still no answers. I followed link which you have added. It is working fine now :smileyhappy 🙂   Regards Rajaram ... View more

Thanks Rajaram.   I used my ods.tagsets.rtf   code template :   proc template; define style temp1/store=templ.temp1; parent=styles.rtf; style table from table / protectspecialchars = off asis = on cellpadding = 1pt cellspacing = 1pt borderwidth = 1pt frame = hsides rules = groups ; style parskip / fontsize = 0pt ; end; run;   My code :   options nolabel orientation=landscape papersize=4 nodate nonumber; ods listing close; ods path sashelp.tmplmst templ.temp1 (read); ods tagsets file='mydir\demog.rtf' options(continue_tag="no") style=first; title1 'Table 1.1.1'; title2 'Demographics for all regions'; title3 'Study 7GFD-E04'; footnote1 j=l 'Note: first line note'; footnote2 j=l 'Note: second line note'; proc report data=sashelp.demographics nowd style(header)=[frame=hsides rules=none fontfamily=courier] style(column)=[frame=hsides rules=none fontfamily=courier]; column region name isoname pop popagr gni; define region /group; define name /display; define isoname /display; define pop /display; define popagr /display; define gni /display; run; ods tagsets.rtf close; ods listing;   The result of this code is shown in attchment "CurrentTagset.png".  The desired result is shown in attachment "wouldlike.png".   Currently I still have vertical border line in header's for each column.    Cheers   saskap ... View more

Thank you ballardw. I solved issue similar to your suggestion. ... View more

Post your code and output, preferably referencing a SASHELP data set so it can be replicated. You should also reference your Maintenance i.e. SAS 9.3TS1M2 is your current version? ... View more