Manipulating the output from proc print

Reply
New Contributor
Posts: 2

Manipulating the output from proc print

Hi Guys

My output after looks like this..    proc print data=maps.africa2 (obs=2); run;

                  Obs    CONT     ID    ISO    IDNAME                  ISONAME                  START

                    1     94     125    012    ALGERIA                    ALGERIA                        1

                    2     94     141    024    ANGOLA                    ANGOLA                       1071

              

                 

                  Obs     END    POINTS              CONT94_GEO                     NAME

                    1    1070     1070                id 125, cont 94 of maps.Africa    ALGERIA

                    2    2566     1496                id 141, cont 94 of maps.Africa    ANGOLA

                 

but i need all the variables in one together.....

       

            Obs  

CONT IDISOIDNAME              ISONAME              START      END  POINTS    CONT94_GEO                                  NAME

1 94 125012ALGERIA                ALGERIA                    1         1070   1070         id 125, cont 94 of maps.Africa          ALGERIA

2 94 141024ANGOLA                ANGOLA                   1071    2566   1496         id 141, cont 94 of maps.Africa         ANGOLA

HELP ME GUYS..

THANKS

DANNY

ouputz

SAS Super FREQ
Posts: 8,743

Re: Manipulating the output from proc print

Hi:

You did not say what your destination of interest was/is...LISTING, RTF, PDF, HTML??? At any rate, if you are creating LISTING output, you do not have a lot of choices except to make the LINESIZE bigger (it can go to 256) or to adjust the orientation to landscape mode.

  Otherwise, for RTF or PDF, you can see this previous forum posting on dealing with very wide tables:

https://communities.sas.com/message/414#414

  For HTML, it's not a big issue, because your tables can generally be as wide as you need for them to be.

cynthia

New Contributor
Posts: 2

Re: Manipulating the output from proc print

Thanks cynthia.

It was for a listing output.

That helps.

Happy new year.

Super User
Super User
Posts: 6,500

Re: Manipulating the output from proc print

  • You can also try using the WIDTH=MIN option. 
  • Also the NOOBS option with remove that first column with the observation number.
  • You can also build your own text output using a DATA step with FILE and PUT statements.
  • If the values of character variables are really long then you might want to use PROC REPORT so that you could use the flow option on those columns (variables).
Ask a Question
Discussion stats
  • 3 replies
  • 190 views
  • 3 likes
  • 3 in conversation