topic Re: Print observations in a row in SAS Studio

Print observations in a row

Alireza_Boloori — Wed, 06 Sep 2017 00:39:32 GMT

Hello everyone,

When I want to print all observations under a variable, it prints them in a column format (i.e., each observation is listed right below the previous one). However, how can I print all observations in a row format (i.e., all observations are listed adjasent to each other)?

Any idea/thought is really appreciated!

Re: Print observations in a row

Reeza — Wed, 06 Sep 2017 01:09:40 GMT

You'll need to manually use a PUT statement within a data step to control your output.

Or you could select the row, transpose your data and then use PROC PRINT.

If this is something you do regularly I'd probably create a macro to handle this issue.

Re: Print observations in a row

Alireza_Boloori — Wed, 06 Sep 2017 02:03:14 GMT

I'd be very thankful if you can create a macro, because this is not going to be a one-time SAS code for me.

Re: Print observations in a row

ballardw — Wed, 06 Sep 2017 15:13:09 GMT

Show an example starting data set and the desired resulting data set.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: Print observations in a row

Reeza — Wed, 06 Sep 2017 16:15:37 GMT

@Alireza_Boloori wrote:
I'd be very thankful if you can create a macro, because this is not going to be a one-time SAS code for me.

I'm happy to help, not to write your code. If this is not a one time use you should also understand it thoroughly. I suggest coding it for a 'Base case' then we can help you turn it into a macro. For example, how to get all Names from SASHELP.CLASS on a single line. You didn't want any delimiter between the values?

See the PUT Statement Documentation for examples

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n1spe7nmkmi7ywn175002rof97fv.htm