topic Re: Any adverse events by treatment group - concat multiple variables in SAS Programming

Any adverse events by treatment group - concat multiple variables

SASFREAK — Wed, 03 May 2023 12:50:21 GMT

Hi Everyone,

I'm trying to create a AE listing by treatment group. The data representation in listing looks like this.

-----------------------------------------------------------------

SUBJID PERIOD SOC

(Age/sex) VISIT PT

AETERM

-----------------------------------------------------------------

001 TREATMENT Nervous system disorder

(64/f) cycle 1 Hypoaesthesia

Numbness to top things

I'm thinking to concat these multiple variable but not sure how to split them in this desired format. any comments or suggestions will be highly appreciated.

Thank you,

SASFREAK

Re: Any adverse events by treatment group - concat multiple variables

PaigeMiller — Wed, 03 May 2023 13:21:18 GMT

Can you please show us a portion of the actual SAS data set as working SAS data step code? Please see these instructions for examples. Do NOT provide data in other forms.

Re: Any adverse events by treatment group - concat multiple variables

SASFREAK — Wed, 03 May 2023 13:41:20 GMT

/*example code - I'm concating the variables but not sure how to represent them as indented in the .lst output*/

data sample;
input subjid $ demog$ phase $ avisit$ SOC $ PT$ AETERM$;
datalines;
001 (54/F) TREATMENT CYCLE1 Gastro CONSTIPATION constipation
001 (54/F) TREATMENT CYCLE1 Gastro DIAORRHOE  PAIN
001 (54/F) TREATMENT CYCLE2 Skin  Pruitus ITICHING
001 (54/F) FOLLOWUP CYCLE1. Skin Rash RASH
001 (54/F) FOLLOWUP CYCLE2  Psychtric Insomnia INSOMNIA
;
RUN;

data adae;
set SAMPLE;
/*combining variables -  subjid +demog info*/

col1 = cat(subjid , " + ", demog);
col2 = cat(phase, " + " , avisit);

run;

Re: Any adverse events by treatment group - concat multiple variables

ballardw — Wed, 03 May 2023 15:09:30 GMT

@SASFREAK wrote:

/*example code - I'm concating the variables but not sure how to represent them as indented in the .lst output*/

Do you mean that expect to see indents and apparent line feeds in the actual values of the variable values in the data set viewer? A report? An exported data file? Somewhere else?

If this relates to LST, or other output, please show us the code that is supposed to generate the output and the desired ODS destinations. Some approaches that might work for Listing would not work for RTF, PDF or HTML output.