About tarheel13

tarheel13 · ‎01-14-2021

Yes, if you read the OP, I said that I do use preloadfmt with proc report. This is a step that I do before that. I know what proc freq does. I guess you don't really understand what I was asking. I have a table shell that I have to work off of.

tarheel13 · ‎01-14-2021

To give context of the problem I am trying to solve! I included the proc sql step where the macro variables are assigned! And because I have to count the AEs by SOC and PT and I needed a row for "All Events".

tarheel13 · ‎01-14-2021

Is there a way to get all the SOCs into a proc format step? Subject aeterm_Soc aeterm_PT 1 Cardiac disorders arrhythmia 1 Respiratory disorders Pulmonary embolism 2 Vascular disorders hypertension 2 Blood disorders Anemia 3 Blood disorders Anemia 3 Vascular disorders DVT 4 Blood disorders Lymphopenia 4 Infections and infestations Septic shock 5 Blood disorders Lymphopenia 6 Respiratory disorders Pneumothorax 7 Psychiatric disorders Agitation Here is some sample data. I am making an AE table using proc report and preloadfmt. This is what I do but I have to keep adding more to the proc format as more SOCs present in the data. Is there a way to make this more dynamic? proc sql; select distinct aeterm_soc into :soc1 - from adae; quit; proc format; value $ descr (multilabel notsorted) "&soc1","&soc2","&soc3"="All Events" "&soc1"="&soc1" "&soc2"="&soc2" "&soc3"="&soc3" ; run; There are 27 SOCs in MedDRA. Is there a better way to do this so I wouldn't have to hypothetically write "&soc1"="&soc1" all the way to "&soc27"="&soc27"? Thanks!

tarheel13 · ‎01-13-2021

https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/038-2008.pdf Email Erik. He might be able to help you. I spoke to him in 2019 when I was doing a mail merge out of SAS.

tarheel13 · ‎01-13-2021

Use #byval title option in proc report. https://www.lexjansen.com/nesug/nesug09/cc/CC29.pdf

tarheel13 · ‎01-12-2021

She just told me that she needs to be able to estimate N, mean, SD for each data point. I do not know "appropriate manner" to display that. I was going to just print number of subjects underneath the figure and use datalabel statement to get mean for each point. I think the limitstat=stddev already shows the SD fine but it's not my call. @Reeza we do have stacked bar chart of ordinal scores in another version of shells. This figure is supposed to be for DSMB though.

tarheel13 · ‎01-12-2021

Thank you. I will try this. The only other idea I have is to output a dataset from proc means and then do something like this: proc means data=visits n mean stddev maxdec=2; class sev folderseq; var ordinal_visit; output out=MeanOut n=n mean=mean stddev=SD; run; proc sgplot data=summary; series x=folderseq y=mean/group=sev; scatter x=folderseq y=mean / group=sev yerrrorlower=lowerSD yerrorupper=upperSD; xaxistable SD; run; However, I don't really like how this looks lol. And for some reason, my formats of folderseq are not showing up. I had them set up to display Day 1, Day 3, etc.

tarheel13 · ‎01-12-2021

Because it is a 1-8 scale of disease severity. I did not write the SAP so just trying to program according to SAP and shell. It is a measure of disease severity. So 8 means the patient is about to die and 1 is stable. Recovery is defined as this score reaching 1,2, or 3.

tarheel13 · ‎01-12-2021

Do you mean this? https://blogs.sas.com/content/graphicallyspeaking/2015/12/23/box-plot-with-stat-table-and-markers/ Like the table underneath?

tarheel13 · ‎01-12-2021

No, I don't think she means date. I have to get the mean, SD, and N for each study day and then the disease severity (moderate, severe, or all subjects). I imagine she would mean display mean, SD, and N for each point. If I specify datalabel, that will put the label for each marker on the figure. However, it sounds like she wants the SD and N too and that's what I was asking. See direct quote: "For the first line, I am saying that the N, Mean, standard deviation for each point should be marked in some manner in the figure for each data point of the figure."

tarheel13 · ‎01-12-2021

Thanks for your response. Statistician wrote back to me and she is saying that n, mean, SD should be marked for each data point in the figure. Do you know how to do that? I am only aware of datalabel statement in SG plot.

tarheel13 · ‎01-12-2021

I am making a plot of mean and SD of an ordinal variable. Shell says to display n, mean, SD in appropriate manner. Anyone have suggestion on how to display n? I am plotting the ordinal variable over different study days. proc sgplot data=dsn; vline folderseq / response=ordinal_visit stat=mean limitstat=stddev markers; run;

tarheel13 · ‎01-11-2021

Lol by TIA, I meant thanks in advance. And, no I am newer to proc logistic. proc sort data=dsn; by subgroupvar; run; proc logistic data=dsn plots(only)=effect(x=(ordinal_visit) sliceby=treatment*severity_baseline individual connect alpha=0.5); class severity_baseline(ref=first) treatment baseline_Steroid/param=ref; model ordinal_visit=treatment baseline_steroid; oddsratio treatmnet; ods output oddsratioswal=ORest; by subgroupvar; run; So basically, I will put this in a macro and pass in the subgroup var as a parameter and name the datasets separately and then stack them? To get overall, you just exclude the by subgroupvar? Then stack all these together and then I can use Sanjay's program?

tarheel13 · ‎01-11-2021

Okay, so I have never made forest plot before. I have googled it extensively and keep finding this code from Sanjay Mantage. https://blogs.sas.com/content/graphicallyspeaking/files/2016/05/Subgrouped_Forest_Plot_SG_94.txt However, I am a little bit confused about how to build the dataset forest_subgroup. So do I just have to output all the odds ratios for my subgroups from proc logistic and stack them together in one dataset? My shell is not very detailed. It just has a skeleton of a forest plot by subgroup and says odds ratio and confidence intervals will be presented as labels. TIA!

tarheel13 · ‎01-08-2021

Thanks! I found that too after I already replied to this haha

Online Status	Offline
Date Last Visited	‎06-04-2024 04:03 PM

Re: Seeking Advice on SAS for Entry into Pharma Industry

Re: Identify death date over a list of dates

Re: Identify death date over a list of dates

Re: Seeking Advice on SAS for Entry into Pharma Industry

Re: How to count rows that come after a certain date?

Re: a question on regular expression

Re: a question on regular expression

Re: Replace values in a numeric table based on a character table

Re: a question on regular expression

Re: Replace values in a numeric table based on a character table

Re: Identify and flag the latest day

Re: account verification

Re: create a new library

Re: Person-years form a start to an end date

Re: Interaction plot

Re: Replace values in a numeric table based on a character table

Re: a question on regular expression

Re: Compress function treats slash as “or”?

Re: How to use prxchange to replace special characters

Re: Is there a way to search for a value of a variable in multiple dat...

Re: Get all SOC in proc format

Re: Get all SOC in proc format

Get all SOC in proc format

Re: Sending emails in SAS: Email address has a # in it

Re: Proc Report header label "BY Group"

Re: Display n, mean, and SD of ordinal variable in best manner

Re: Display n, mean, and SD of ordinal variable in best manner

Re: Display n, mean, and SD of ordinal variable in best manner

Re: Display n, mean, and SD of ordinal variable in best manner

Re: Display n, mean, and SD of ordinal variable in best manner

Re: Display n, mean, and SD of ordinal variable in best manner

Display n, mean, and SD of ordinal variable in best manner

Re: Help with forest plot

Help with forest plot

Re: proc logistic design variables

SAS User Groups

SAS Global Forum