About glz

glz · ‎11-09-2023

Hello all, I have an example data: The column in data A includes special characters: AA*B, A**B, AB**, and here * can be anything, both letter and number. The column in data B without special character: AADB, ABBF, AB3D. so in this example, since AADB satisfies AA*B, AB3D satisfies AB**, they will be reported. I do not know how to deal with them in SAS, could anyone help me to figure this out? Thanks a lot.

glz · ‎08-03-2023

Hello there, I would like to generate a customized publishable table (as attached above), and wonder if it can be formatted by creating a template from SAS and getting the result directly from SAS, instead of entering the number manually. Thanks a lot.

glz · ‎10-25-2019

Hello mkeintz, Thanks very much, your solution and idea is very valuable. If we define status_1 and status as character value first, then it solved my question! otherwise it will cause error such as "invalid numeric data, "Unknown" ". Thanks again.

glz · ‎10-24-2019

Hello, I have an example data in below, the column status (highlight with yellow) is what I want. For each subject, once "Positive" occur in Test, then the status for this subject is "Positive"; If no Positive, there is "Negative" then the status for this subject is "Negative"; If no positive, there are "Unknown" and one other character string such as "<5" then the status is "<5"; if no positive, there are "Unknown" and many other character string, such as "<5" and "<10", then the status is "NA"; Can anyone help me with this problem? Thanks.

glz · ‎08-12-2019

Thanks very much!

glz · ‎08-09-2019

Thanks, I tried the following code: proc sgplot data=subset noautolegend nocycleattrs; vbox Result / category=time group=status connect=mean; run; My question is: if I add group comment after / , then the two groups are both shown in box plot. I do not know how to separate these two groups with different formats. I wonder if there is an easy way to do it.

glz · ‎08-09-2019

Thanks for your quick reply. But this is not what i want, this is an example for "Box Plot with Multiple Connect Lines". What I need is the two groups are showing in different formats, blue group is a box plot, but the red group only needs to connect mean, does not need box. And i want these two groups in one figure. Thanks.

glz · ‎08-09-2019

Hi, I want to draw this example figure in sas 9.3. As you can see, there are two groups in the data, blue and red. blue one needs to draw the boxplot with mean connected, but the red one only needs to connect mean without box. Can anyone help me with this? Thanks.

Online Status	Offline
Date Last Visited	‎11-14-2023 02:28 PM

strings with special characters comparison

How to generate a customized publishable table directly from SAS?

Re: create a new column based on another column's value

create a new column based on another column's value

Re: how to draw a figure includes box plot and scatter plot

Re: how to draw a figure includes box plot and scatter plot

Re: how to draw a figure includes box plot and scatter plot

how to draw a figure includes box plot and scatter plot

Re: How to generate a customized publishable table directly from SAS?

Re: how to draw a figure includes box plot and scatter plot

Re: how to draw a figure includes box plot and scatter plot

strings with special characters comparison

How to generate a customized publishable table directly from SAS?

Re: create a new column based on another column's value

create a new column based on another column's value

Re: how to draw a figure includes box plot and scatter plot

Re: how to draw a figure includes box plot and scatter plot

Re: how to draw a figure includes box plot and scatter plot

how to draw a figure includes box plot and scatter plot