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: 
jaemin
‎04-24-2017
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-10-2017 11:14 AM
‎04-10-2017 11:14 AM
I used the method xaxis=translate(xaxis, 'A0'x, '.'); you described in the webpage to create the format and it worked!!! Thanks so much!!!   data time_all2; merge tfmt time_all; by time; if time=15 then tlabel=put(time,best12.)||"="||quote('.') ; if time=21 then tlabel=put(time,best12.)||"="||quote('..') ; if time=27 then tlabel=put(time,best12.)||"="||quote('...') ; if time=33 then tlabel=put(time,best12.)||"="||quote('....') ; tlabel2=translate(tlabel, 'A0'x, '.'); run; proc sql; select tlabel2 into :tlabel separated by " " from time_all2; quit; proc format; value tfmttwo &tlabel ; run; proc sgplot data=freq dattrmap=attrmap2; vbar time / group=pgagrp response=percent2 name="grouping" BARWIDTH=0.7 NOOUTLINE attrid=pgagrp ; xaxis values=(0 to 36 by 3) label="Month (ADA/N)" fitpolicy=SPLITALWAYS SPLITCHAR=" " ; yaxis label='Percent' values=(0 to 100 by 10); keylegend "grouping" ; format pgagrp pgagrptwo. time tfmttwo. percent2 7.1; run;   ... View more

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 02:56 PM
‎04-07-2017 02:56 PM
I tried making them blank in the format but I don't think it worked.   ... View more

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 02:38 PM
‎04-07-2017 02:38 PM
I edited the format and removed TYPE=LINEAR. Now it splits but how can I hide the values I don't want: 15, 21, 27. 33?   ods html gpath="&figuredir" image_dpi=200 ; ods graphics/reset=index scale=off /*border=off*/ imagename="test" width=10in height=6.5in; title1 "Disease activity of patients remaining on adalimumab by month"; proc sgplot data=freq dattrmap=attrmap2; vbar time / group=pgagrp response=percent2 name="grouping" BARWIDTH=0.7 NOOUTLINE attrid=pgagrp ; xaxis values=(0 to 36 by 3) label="Month (ADA/N)" fitpolicy=SPLITALWAYS SPLITCHAR=" "; yaxis label='Percent' values=(0 to 100 by 10); keylegend "grouping" format pgagrp pgagrptwo. time tfmttwo. percent2 7.1; run; ods graphics off;   ... View more

Re: How to insert Excel formula in TITLE using ods tagsets.excelxp

by Calcite | Level 5 in ODS and Base Reporting
‎04-07-2017 02:32 PM
‎04-07-2017 02:32 PM
I do not want to hard code the sheet name and I tried to use the same logic in title but I think the syntax is different and I don't know how to do it.   I thought about place it in a single cell but since it is a centered title you have to consider the width of the table and merge the cells which is too complicated. ... View more

How to insert Excel formula in TITLE using ods tagsets.excelxp

by Calcite | Level 5 in ODS and Base Reporting
‎04-07-2017 01:19 PM
‎04-07-2017 01:19 PM
I am using ods tagsets.excelxp to create an Excel file and I am trying to place the Excel formula =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) in TITLE. What the formula does is to return the name of the current sheet.   I know how to insert that formula in the table with PROC REPORT: define test / style(column)={tagattr='formula:MID(CELL("filename",RC[-1]),FIND("]",CELL("filename",RC[-1]))+1,255)'}; But I have no idea how to do that in TITLE. Anybody can help?   The desired output looks like this: ... View more

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 12:48 PM
‎04-07-2017 12:48 PM
Here is the format:     ... View more

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 12:03 PM
‎04-07-2017 12:03 PM
The value is numeric but the formatted value is discrete. SAS does not have options for that situation? ... View more

Re: Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 11:48 AM
‎04-07-2017 11:48 AM
I just tried fitpolicy=SPLITALWAYS but it did not work. ... View more

Split format label for xaxis values with PROC SGPLOT

by Calcite | Level 5 in Graphics Programming
‎04-07-2017 11:39 AM
‎04-07-2017 11:39 AM
I am trying to split the formmated xasix values in two lines with PROC SGPLOT but it is not working. Anybody has idea how to do that with SGPLOT (not GCHART)?   ods html gpath="&figuredir" image_dpi=200 ; ods graphics/reset=index scale=off /*border=off*/ imagename="Descriptive Figure - PGA v1" width=10in height=6.5in; title1 "Disease activity of patients remaining on adalimumab by month"; footnote; proc sgplot data=freq dattrmap=attrmap2; vbar time / group=pgagrp response=percent2 name="grouping" BARWIDTH=0.7 NOOUTLINE attrid=pgagrp ; xaxis type=linear values=(0 to 36 by 3) label="Month (ADA/N)" fitpolicy=split SPLITCHAR=" "; yaxis label='Percent' values=(0 to 100 by 10); keylegend "grouping" ; format pgagrp pgagrptwo. time tfmttwo. percent2 7.1; run; ods graphics off; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-24-2017 08:27 AM
Quick links