Any adverse events by treatment group - concat multiple variables

[SASFREAK]

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

[PaigeMiller]

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.

[SASFREAK]

/*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;




 

[ballardw]

---

@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.