topic Re: How to transpose various fields into rows in SAS Programming

How to transpose various fields into rows

vidya3 — Thu, 30 May 2024 17:09:58 GMT

I have attached the document below according to which I'm looking to transpose the dataset, please help as this is quite urgent and I've been struggling with it for quite some time.

Re: How to transpose various fields into rows

PaigeMiller — Thu, 30 May 2024 17:30:36 GMT

Most of us will not download Microsoft Office documents as they can be a security threat. Better you should provide data as text in your message, following these instructions and examples. This should not be something we have to request repeatedly, you have been asked for data in the proper form before.

In the meantime, perhaps the PROC TRANSPOSE documentation and examples will be helpful.

Re: How to transpose various fields into rows

Reeza — Thu, 30 May 2024 17:37:35 GMT

Can you post the code you tried and your data as a data step instead of Excel?

You will need to follow the approach here (Example 3) to transpose multiple variables at once.

Re: How to transpose various fields into rows

ballardw — Thu, 30 May 2024 17:40:35 GMT

You need to very clearly show what your current data set looks like.

Then show and describe the result.

I am afraid that a single sheet from a spreadsheet doesn't tell us much about what you have and which the result.

Plus we can't tell SAS variable types or variable names.

And anytime reshaping comes up, it often is helpful to answer are your sure you need a data set? Often reports are easier to create than data sets.

Re: How to transpose various fields into rows

vidya3 — Thu, 30 May 2024 17:49:52 GMT

Dataset I have:
Value1 value2 date1 date2 range1 range2
1.2 2.3 1/1/24 3/2/24 xyz abc

Dataset I want:
Name label value date range
Value1 *** 1.2 1/1/24 xyz
Value1 *** 2.3 3/2/24 abc

I want the respective label of that field to fetch under label field, please help.