Show variables in next line in same page in proc report

[chinna0369]

Hi all,

I have lot of variables in my listing dataset, I would like to show them in same page in next line as below.

But I am getting next line of variables in next page.

My code is as follows, can you please help me to get the output what I want.

   proc report data= pov_final_out nowd headline headskip split= '\' spacing=1
   style = [rules=group frame=void just=l];
   column dehstatl dehdatc defintl delname decpdt detgtlb detldom deappp deadflw deadfla defaosp dehivta depstim devatim deuuova devapr devaosp
          devad devsman devsdn devssz devsssp devgman devgdn devgsz devgssp  deaatim deaaprc deaaosp deasman deasdn deassz deasssp deagman 
          deagdn deagsz deagssp devpuse deavuse deauosp derstl derslsp defrc demodal debravf dedisap derfrnc depetim deprsuc deruosp deviaae devnisp deissn
          deembd deenusp delsrtm deaascm deamctm deaascm deaectm deaecsp devascm devmctm devascm devectm devecsp deusuch deunusp dehpadp dehepa dehetd dehetdu 
          deprtmn deprtd deprtdu detft detvolc deadtrt deae dfyn desspp dummy; 

   define dehstatl    / display 'Hospitalization Status:' style=[cellwidth=20mm];
   define dehdatc   / display 'If Inpatient, Date of Hospitalization:'  style=[cellwidth=20mm];
   define defintl   / display 'First Initial:'  style=[cellwidth=20mm];
   define delname   / display 'Full Last Name:'  style=[cellwidth=20mm];  
   define decpdt   / display 'WavelinQ Cases Performed to Date as Primary Operator:'  style=[cellwidth=20mm];
   define detgtlb   / display 'Target Limb:'  style=[cellwidth=20mm];
   define detldom  / display 'Target Limb Dominance:'  style=[cellwidth=20mm];
   define deappp  / display 'Was an Angiogram Performed to Confirm Angiographic Eligibility?'  style=[cellwidth=20mm];
   define deadflw  / display 'Is there Adequate Dual Arterial Flow to the Hand (Palmar Arch)?'  style=[cellwidth=20mm];
   define deadfla   / display 'How was Dual Arterial Flow Assessed?'  style=[cellwidth=20mm];
   define defaosp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define dehivta   / display 'Was Hand IV Placed in the Target Arm?'  style=[cellwidth=20mm];
   define depstim   / display 'Procedure Start Time/First Skin Puncture:'  style=[cellwidth=20mm];
   define devatim   / display 'Time of Vein Access:'  style=[cellwidth=20mm];
   define deuuova   / display 'Was Ultrasound Used to Obtain Vessel Access?'  style=[cellwidth=20mm];
   define devapr   / display 'Which Vein was used to Gain Access?'  style=[cellwidth=20mm];
   define devaosp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define devad   / display 'First Initial:'  style=[cellwidth=20mm];
   define devsman   / display 'Venous Sheath Utilized Manufacturer:'  style=[cellwidth=20mm];
   define devsdn   / display 'Venous Sheath Utilized Device Name:'  style=[cellwidth=20mm];
   define devssz   / display 'Venous Sheath Utilized Size:'  style=[cellwidth=20mm];
   define devsssp   / display 'Venous Sheath Utilized Other, Specify:'  style=[cellwidth=20mm];
   define devgman   / display 'Venous Guidewire Utilized Manufacturer:'  style=[cellwidth=20mm];
   define devgdn   / display 'Venous Guidewire Utilized Device Name:'  style=[cellwidth=20mm];
   define devgsz   / display 'Venous Guidewire Utilized Size:'  style=[cellwidth=20mm];
   define devgssp   / display 'Venous Guidewire Utilized Other, Specify:'  style=[cellwidth=20mm];
   define deaatim   / display 'Time of Arterial Access:'  style=[cellwidth=20mm];
   define deaaprc   / display 'Which Artery was Used to Gain Access?'  style=[cellwidth=20mm];
   define deaaosp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define deasman   / display 'Arterial Sheath Utilized Manufacturer:'  style=[cellwidth=20mm];
   define deasdn   / display 'Arterial Sheath Utilized Device Name:'  style=[cellwidth=20mm];
   define deassz   / display 'Arterial Sheath Utilized Size:'  style=[cellwidth=20mm];
   define deasssp   / display 'Arterial Sheath Utilized Other, Specify:'  style=[cellwidth=20mm];
   define deagman   / display 'Arterial Guidewire Utilized Manufacturer:'  style=[cellwidth=20mm];
   define deagdn   / display 'Arterial Guidewire Utilized Device Name:'  style=[cellwidth=20mm];
   define deagsz   / display 'Arterial Guidewire Utilized Size:'  style=[cellwidth=20mm];
   define deagssp   / display 'Arterial Guidewire Utilized Other, Specify:'  style=[cellwidth=20mm];
   define devpuse   / display 'Which Vein Position was Used to Create the endoAVF?'  style=[cellwidth=20mm];
   define deavuse   / display 'Which Artery/Vein was Used to Create the endoAVF?'  style=[cellwidth=20mm];
   define deauosp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define derstl   / display 'Reason for Selecting Target endoAVF Location:'  style=[cellwidth=20mm];
   define derslsp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define defrc   / display 'Was Final Result Confirmed via Imaging?'  style=[cellwidth=20mm];
   define demodal   / display 'If YES,Modality:'  style=[cellwidth=20mm];
   define debravf   / display 'Brachial Artery Volume Flow (Post-Procedure):'  style=[cellwidth=20mm];
   define dedisap   / display 'Distance from Anastomosis to Perforator:'  style=[cellwidth=20mm];
   define derfrnc   / display 'If NO, Reason:'  style=[cellwidth=20mm];
   define depetim   / display 'Time Final Fistulagram Performed (Procedure Stop):'  style=[cellwidth=20mm];
   define deprsuc   / display 'Was WavelinQ endoAVF Successfully Created?'  style=[cellwidth=20mm];
   define deruosp   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define deviaae   / display 'If NO, Were the Vessels that were Interacted with During the Procedure Imaged to Assess for any AEs?'  style=[cellwidth=20mm];
   define devnisp   / display 'If NO, Specify Reason:'  style=[cellwidth=20mm];
   define deissn   / display 'If YES, Were Any Issues Noted?'  style=[cellwidth=20mm]; 
   define deembd   / display 'Was an Embolic Device Used?'  style=[cellwidth=20mm];
   define deenusp   / display 'If NO, Specify Reason Embolic Device Not Used:'  style=[cellwidth=20mm];
   define delsrtm   / display 'Time of Last Sheath Removal (Start of Access Site Closure):'  style=[cellwidth=20mm];
   define deaascm   / display 'Arterial Access Site Closure Method:'  style=[cellwidth=20mm];
   define deamctm   / display 'Venous Guidewire Utilized Size:'  style=[cellwidth=20mm];
   define deaascm   / display 'Venous Guidewire Utilized Other, Specify:'  style=[cellwidth=20mm];
   define deaectm   / display 'Time of Arterial Access:'  style=[cellwidth=20mm];
   define deaecsp   / display 'Which Artery was Used to Gain Access?'  style=[cellwidth=20mm];
   define devascm   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define devmctm   / display 'Arterial Sheath Utilized Manufacturer:'  style=[cellwidth=20mm];
   define devascm   / display 'Arterial Sheath Utilized Device Name:'  style=[cellwidth=20mm];
   define devectm   / display 'Arterial Sheath Utilized Size:'  style=[cellwidth=20mm];
   define devecsp   / display 'Arterial Sheath Utilized Other, Specify:'  style=[cellwidth=20mm];
   define deusuch   / display 'Arterial Guidewire Utilized Manufacturer:'  style=[cellwidth=20mm];
   define deunusp   / display 'Arterial Guidewire Utilized Device Name:'  style=[cellwidth=20mm];
   define dehpadp   / display 'Arterial Guidewire Utilized Size:'  style=[cellwidth=20mm];
   define dehepa   / display 'Arterial Guidewire Utilized Other, Specify:'  style=[cellwidth=20mm];
   define dehetd   / display 'Which Vein Position was Used to Create the endoAVF?'  style=[cellwidth=20mm];
   define dehetdu   / display 'Which Artery/Vein was Used to Create the endoAVF?'  style=[cellwidth=20mm];
   define deprtmn   / display 'Other, Specify:'  style=[cellwidth=20mm];
   define deprtd   / display 'Total Dose:'  style=[cellwidth=20mm];
   define deprtdu   / display 'Unit:'  style=[cellwidth=20mm];
   define detft   / display 'Total Fluoroscopy Time in Minutes:'  style=[cellwidth=20mm];
   define detvolc   / display 'Total Amount of Contrast Used:'  style=[cellwidth=20mm];
   define deadtrt   / display 'Were any Adjunctive Treatment Modalities Used?'  style=[cellwidth=20mm];
   define deae   / display 'Were there Any Adverse Events During the Procedure?'  style=[cellwidth=20mm];
   define dfyn   / display 'Was there a WavelinQ Device Deficiency or Malfunction?'  style=[cellwidth=20mm];
   define desspp   / display 'Is a Second Stage Procedure Planned?'  style=[cellwidth=20mm];
   define dummy		/ display '';

   compute before _page_ / left style=[font_weight=bold FONT_SIZE = 3];
       line 'Procedure Overview:';
   endcomp;
   run;

Thanks,

Adithya

[Tom]

Could you just use PROC PRINT instead?  It should do that automatically when the number of observations is small.

proc print data=sashelp.baseball(obs=1);
run;

Results in normal listing destination.

                             The SAS System                            12
                                              13:02 Thursday, May 5, 2022

                                    n
                                    At     n      n      n
 Obs       Name          Team      Bat   Hits   Home   Runs   nRBI   nBB

   1  Allanson, Andy   Cleveland   293    66      1     30     29     14

              Cr
        Yr    At    Cr    Cr    Cr    Cr
 Obs  Major   Bat  Hits  Home  Runs  Rbi  CrBB   League   Division

   1    1     293   66     1    30    29   14   American    East


                    n       n        n                         log
 Obs  Position    Outs    Assts    Error    Salary    Div    Salary

   1     C         446      33       20        .      AE        .

[Cynthia_sas]

Hi:
Without data, no one can run your code. Can you post some sample data. I notice that you use several listing options that are incompatible with ODS (headline/headskip). What is your destination of interest? RTF, PDF, HTML, EXCEL??? What is your orientation for the report, if you are using RTF or PDF? Portrait or landscape? And, if RTF and PDF, what are your margin settings? Why are you controlling the cellwidth to 20MM?? What is the purpose of the dummy variable at the end of the report row. You seem to want to split your 80 variables across 3 rows? Does that mean you will have 1 observation on each page?
Can you provide more context for this report, especially the destination and your option settings and some test data?
Cynthia