SAS Support Communities

xxformat_com · ‎02-23-2025

Hi, Can radars be created with proc sgplot or GTL using SAS 9.4 or do we have to use the old procedure proc gradar?

xxformat_com · ‎10-31-2024

Which graph procedure can be used to represent words frequency i.e. to have a representation like the one given by SAS Visual Analytics?

xxformat_com · ‎09-29-2024

data a; a='A'; b='B'; x=1; y=1; run; data b; a='A'; c='C'; x=2; z=2; run; data z (drop=i j); set a b; array charvar {*} _character_; array numvar {*} _numeric_; do i=1 to dim(charvar); if charvar{i} = ' ' then charvar{i}='/'; end; do j=1 to dim(numvar); if numvar{j} = . then numvar{j}=.A; end; run; proc print data=z; var a b c x y z; run; But I'm assuming there is an easier approach. Actually, I added more data and an extra layer of difficulty after that in my code because any missing value of an existing variable should not be reported with / or .A data a; a='A'; b='B'; w=.; x=1; y=1; run; data b; a='A'; c='C'; d=' '; x=2; z=2; run; At the end, my excel report changes the background of the cells only when the variables were not in the original datasets (my datasets are coming from .csv file I import) and I have an extra layer of probably unneeded complication using a loop for call define in proc report.

xxformat_com · ‎09-29-2024

I used a set statement only. The solution I've found is using arrays. I'm just assuming that there is a better way of doing it.

xxformat_com · ‎09-29-2024

Datasets to append can have different variables. Sometimes, it can be useful to identify in the output dataset when values are missing before the variable was not in the original dataset. data a; a='A'; b='B'; x=1; y=1; run; data b; a='A'; c='C'; x=2; z=2; run; How would you get a slash when the character variable was missing and a .A when the numeric variable was missing?

xxformat_com · ‎09-28-2024

I like the two set statements. Is there a specific reason for preferring a view over a dataset?

xxformat_com · ‎09-28-2024

I agree about y: but it is just a demo example. But the question was about listing all the variables which are not starting with x as in real life, we either don't know the name of the variables in advance or the list is so long that automating is worth it.

xxformat_com · ‎09-28-2024

As far as I know it is not possible to use "not" with <varname>: to list a series of variable not starting with. In other words, it is not possible to do this: data tmp; x1=1; x2=2; y1=1; y2=2; run; proc print data=tmp; var not(x:) x:; run; We can still use a macro variable: data tmp; x1=1; x2=2; y1=1; y2=2; run; proc sql noprint; select name into: notx separated by ' ' from dictionary.columns where libname='WORK' and memname='TMP' and upcase(name) not like 'X%'; quit; proc print data=tmp; var &notx. x:; run; Would you have any other suggestion?

xxformat_com · ‎09-19-2024

The swimmer plot is an example where type= option could be used in keylegend. In this paper you can start to see that the code starts to get messy with so many scatter statement. https://www.lexjansen.com/phuse-us/2018/dv/DV08.pdf Here we have to keep in mind that programs have to be validated in clinical research and programmers don't really like validating other people programs. So it is essentiel to have short effective and comprehensive code to facilitate the process. The SAS system offers the opportunity to derive items from a specific symbol plotted on the graph. If we don't have any flexibility to define the symbol size, then the benefit of the feature is lost and we keep with old workaround.

xxformat_com · ‎09-15-2024

As for multiple legenditem, it overloads the procedure when we could expect the size given in the wall to be reused. fill type have its options. I would expect something similar to be available for symbols.

xxformat_com · ‎09-14-2024

The type= option of the keylegend statement allow to keep a subset of the symbol used on the graph. In the example, a filled symbol is used. It is always possible to resize the rectangle in the legend using scale, fillheigh, fillaspact. However it is not possible to use these options to resize the symbol. Is there any other option which could be used. Note: An alternative solution would be to create a specific legenditem only for the symbol (no color). But here I'm just checking on whether I have missed an option. proc sgplot data=sashelp.class; scatter x=weight y=height / filledoutlinedmarkers markerfillattrs = (color = red) markeroutlineattrs = (color = blue thickness = 2) markerattrs = (size = 30 symbol = DiamondFilled); keylegend / position=right type=marker; keylegend / position=right type=markercolor scale=; keylegend / position=right type=markersymbol; run;

xxformat_com · ‎09-04-2024

I've just created a ticket by the tech support.

xxformat_com · ‎09-04-2024

Hi, I was not anticipating any difference on the x-axis (when using valuesformat= or variable format) but there is one for the missing category. Do you have any thought on this? proc format; value $sex 'M'='Male' 'F'='Female' ' '='Missing'; run; data class; set sashelp.class; output; if _n_=1 then do; sex=' '; output; end; run; proc sgplot data=class; vbarbasic sex / response=height stat=mean missing; format sex $sex.; run; proc sgplot data=class; vbarbasic sex / response=height stat=mean missing; xaxis valuesformat=$sex.; run;

xxformat_com · ‎08-25-2024

Thank you to both of you. I was so focused on the picture in the online doc, that I didn't realise that I should double check the definition.

xxformat_com · ‎08-24-2024

Based on the SAS Online documentation https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/p07m2vpyq75fgan14m6g5pphnwlr.htm#n0s89yyivxyeren1ugj51fcu6a9p the two following procedure should output a different graph. What is missing here? proc sgplot data=sashelp.class; hbarbasic sex; xaxis values=(0 to 10) ranges=(0-20) labelpos=datacenter; run; proc sgplot data=sashelp.class; hbarbasic sex; xaxis values=(0 to 10) ranges=(0-20) labelpos=center; run;

SAS Support Communities

radar using GTL or proc sgplot ?

Text Sentiment Analysis

Re: Appending datasets and identifying missing variables in the output

Re: Appending datasets and identifying missing variables in the output

Appending datasets and identifying missing variables in the output

Re: Listing variables to print

Re: Listing variables to print

Listing variables to print

Re: Hoy to size the symbol when keylegend type=markersymbol

Re: Hoy to size the symbol when keylegend type=markersymbol

How to remove the hyperlink from the title of TOC in PDF

Re: Text Sentiment Analysis

Re: Appending datasets and identifying missing variables in the output

Re: Appending datasets and identifying missing variables in the output

Re: Appending datasets and identifying missing variables in the output

multiple colors in xaxistable title

Re: How to use rename and drop statements in a data step

Re: indsname= and n-literal

"What's New"

Re: Sas proc report

radar using GTL or proc sgplot ?

Text Sentiment Analysis

Re: Appending datasets and identifying missing variables in the output

Re: Appending datasets and identifying missing variables in the output

Appending datasets and identifying missing variables in the output

Re: Listing variables to print

Re: Listing variables to print

Listing variables to print

Re: Hoy to size the symbol when keylegend type=markersymbol

Re: Hoy to size the symbol when keylegend type=markersymbol

Hoy to size the symbol when keylegend type=markersymbol

Re: proc sgplot: valuesformat= vs. variable format

proc sgplot: valuesformat= vs. variable format

Re: axis labelpos=datacenter

axis labelpos=datacenter

SAS Plattform Netzwerk

SAS Analytics Explorers

Follow Us

What is...