cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
piao
‎03-01-2023
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

extract specific information using regular expression

by Calcite | Level 5 in SAS Programming
‎03-01-2023 01:58 AM
‎03-01-2023 01:58 AM
I would like to extract some information from a list of strings using regular expression but I'm not familiar with it. Can anyone help? Thanks in advance!   data test; length have $200; have='SEQ:2;NAME:xxx;START:2018-12-03;END:uk-uk-uk';output; have='SEQ:12;NAME:xxxxx;START:2018-12-03;END:';output; have='SEQ:22;NAME:xxxxxxx;START:uk-uk-uk;END:2012-uk-uk';output; have='SEQ:2;NAME:xxx;START:2018-12-03;END:uk-uk-uk SEQ:4;NAME:xxxx;START:2021-12-03;END:uk-uk-uk';output; run;   The strings contain SEQ, NAME, START and END. I want to get SEQ and NAME. The results will be: SEQ:2;NAME:xxx; SEQ:12;NAME:xxxxx; SEQ:22;NAME:xxxxxxx; SEQ:2;NAME:xxx;SEQ:4;NAME:xxxx; ... View more

Re: PROC MIXED warnings for type selection runs

by Calcite | Level 5 in Statistical Procedures
‎02-10-2023 08:28 AM
‎02-10-2023 08:28 AM
Thank you.   I am running the proc logistic and getting the warning "There is possibly a quasi-complete separation of data points. The maximum likelihood estimate may not exist." for the group AVISITN=99 and GRPN=1 in the log. I can also get this information from the dataset ConvergenceStatus. So I would like to use the information from the dataset ConvergenceStatus to filter up the data first. But it seems that there is no way to only output the dataset ConvergenceStatus without the warning in the log before I know which group could not be converged.     ods output ConvergenceStatus=ConvergenceStatus; proc logistic data = ana2 descending; by avisitn grpn; class trt01pn sitegrl/param=ref; model resp = trt01pn sitegr1 base/ risklimits; run;     ... View more

Re: PROC MIXED warnings for type selection runs

by Calcite | Level 5 in Statistical Procedures
‎02-10-2023 04:37 AM
‎02-10-2023 04:37 AM
Hi, I'm wondering if you have solved this because I also want to suppress the warning and use the info from the table ConvergStatus. Thank you! ... View more

Re: legend label truncation

by Calcite | Level 5 in SAS Programming
‎10-25-2022 11:21 AM
‎10-25-2022 11:21 AM
Thank you. But it doesn't work. Actually when I use below format, it is still truncated. proc format; value $sex (default=40) 'F'='十分士' 'M'='fgdgdfghjfdgsdg' ; run;     ... View more

legend label truncation

by Calcite | Level 5 in SAS Programming
‎10-25-2022 07:56 AM
‎10-25-2022 07:56 AM
I have below code and output the figure in RTF. Some Chinese characters are truncated in the legend but all English characters are showed. Is there anything wrong with the template?   Thanks.       %macro RTF_Template2(escapechar=@,_StFont=Courier New, _nbpt=8 ); %global line line2 tablestyle liststyle graphstyle lastfootnote1 lastfootnote2 lastfootnote3; %*--------------------------------------------------------------------------*; %* Step 01: Macro Variables for table display *; %*--------------------------------------------------------------------------*; %let line="&escapechar.R/RTF'\fs0\brdrb\brdrs\brdrw20"; %let line2=%str(&escapechar.R/RTF%'\fs0\brdrb\brdrs\brdrw10); /* font for table and listing */ %let tablestyle=kltnr_8_uk; %let liststyle=kltnr_8_uk; %let graphstyle=kltnr_9_uk; %*--------------------------------------------------------------------------*; %* Step 02: define fonts for tables and listings *; %*--------------------------------------------------------------------------*; *****fonts for tables; ods path work.templat(update) sasuser.templat(read) sashelp.tmplmst(read); ***** define rtf template; proc template; define style styles.kltnr_9_uk; parent=styles.rtf; replace fonts/ 'TitleFont'= ("&_StFont", &_nbpt.pt) 'TitleFont2'= ("&_StFont", &_nbpt.pt, Bold) 'FixedFont'= ("&_StFont", &_nbpt.pt, Bold) 'StrongFont'= ("&_StFont", &_nbpt.pt, Bold) 'docFont'= ("&_StFont", &_nbpt.pt) 'footFont'=("&_StFont", &_nbpt.pt) 'EmphasisFont' = ("&_StFont", &_nbpt.pt,normal) 'headingFont' = ("&_StFont", &_nbpt.pt) 'headingEmphasisFont' = ("&_StFont", &_nbpt.pt) 'FixedEmphasisFont' = ("&_StFont", &_nbpt.pt) 'FixedStrongFont' = ("&_StFont", &_nbpt.pt) 'FixedHeadingFont' = ("&_StFont", &_nbpt.pt) 'BatchFixedFont' = ("&_StFont", &_nbpt.pt); replace color_list / 'link' = blue 'bgH' = white 'fg' = black 'bg' = white; replace body from Document/ bottommargin=1.26in topmargin=1.26in rightmargin=2in leftmargin=2in; style table from output/ frame = void rules = groups cellpadding = 1 cellspacing=0 borderwidth=0 outputwidth=100%; style table from container/ frame=void rules=groups cellpadding=.4pt cellspacing=0pt borderwidth=.4pt asis=on; /* style table/*/ /* frame=hsides*/ ; class GraphFonts "Fonts used in graph styles" / 'GraphDataFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphValueFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphLabelFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphFootnoteFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphTitleFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphAnnoFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphUnicodeFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphLabel2Font' = ("&_StFont",&_nbpt.pt, demi_bold) 'GraphTitle1Font' = ("&_StFont",&_nbpt.pt, demi_bold) 'NodeTitleFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'NodeLabelFont' = ("&_StFont",&_nbpt.pt, demi_bold) 'NodeInputLabelFont'= ("&_StFont",&_nbpt.pt, demi_bold) 'NodeDetailFont' = ("&_StFont",&_nbpt.pt, demi_bold); style GraphData1 from GraphData1 / markersymbol = "circle" linestyle=1; style GraphData2 from GraphData2 / markersymbol = "Asterisk" linestyle=2; style GraphData3 from GraphData3 / markersymbol = "triangle" linestyle=20; style GraphData4 from GraphData4 / markersymbol = "square" linestyle=33; style GraphData5 from GraphData5 / markersymbol = "X" linestyle=41; style GraphData6 from GraphData6 / markersymbol = "Star" linestyle=5; style GraphData7 from GraphData7 / markersymbol = "Diamond" linestyle=8; style GraphData8 from GraphData8 / markersymbol = "circlefilled" linestyle=28; style GraphData9 from GraphData9 / markersymbol = "Plus" linestyle=15; style GraphData10 from GraphData10 / markersymbol = "starfilled" linestyle=2; style GraphData11 from GraphData11 / markersymbol = "trianglefilled" linestyle=20; style GraphDataText/font=("&_StFont", 9pt, normal); style GraphLabelText/font=("&_StFont", 9pt, normal); style GraphValueText/font=("&_StFont", 9pt, normal); end; run; %mend; %RTF_Template2; proc format; value $sex 'F'='十分士大夫士大夫的' 'M'='fgdgdfghjfdgsdg' ; run; options device=emf ; ods rtf file="test.rtf" style=kltnr_9_uk nogtitle nogfootnote; proc sgplot data=sashelp.class; vbar age/group=sex response=height stat=mean groupdisplay=cluster limits=upper ; keylegend / title='' ; format sex $sex. ; run; ... View more

extract words from a string

by Calcite | Level 5 in SAS Programming
‎09-09-2022 04:20 AM
‎09-09-2022 04:20 AM
Hi,   I have a variable called MH in a dataset. I would like to extract the names (i.e., aaa or bbb...) and put them in a new variable called NEW. Thanks in advance.   obs           MH 1            Seq:1; Name:aaa; Date:xxx; Reason:xxx 2            Seq:1; Name:aaaa; Date:xxx; Reason:xxx  Seq:2; Name:bbb; Date:xxx; Reason:xxx 3            Seq:1; Name:aaa; Date:xxx; Reason:xxx  Seq:2; Name:bb; Date:xxx; Reason:xxx  Seq:3; Name:cc; Date:xxx; Reason:xxx   obs           NEW 1            aaa 2            aaaa;bbb 3            aaa;bb;cc ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-01-2023 08:37 AM
Quick links