Proc Transpose

[lisa2002]

Hello everyone, 

I have data that I need to transpose.  This is what some of the data looks like...

Month: April 2019   1   1   1   2   2   2

Number of Patients seen on last day of month: ________  ___________ _______

Number of Patients seen on last Friday of month:   100%     100%          100%

Provider 1    1    2    4     6

I need this information to look like this...

Month       Number of Patients seen on last day of month:          Number of Patients seen on last Friday of month:    Provider

1                ___________                                                               100%                                                                             1

1                ____________                                                              100%                                                                             1

1                _____________                                                             100%                                                                           2

not sure how to go about this since there is no variable in the data set that uniquely identifies each observation.  I need assistance please. 

Thanks

[ballardw]

There are lots of questions about the actual content of your current data set. We would need variable names, types, and actual values as they appear in your data.

The best way to provide that information is to use: Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... 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.

[Tom]

not sure how to go about this since there is no variable in the data set that uniquely identifies each observation.

It is not sure what your data is but it is easy to add a unique record id.

data with_id;
  rowid + 1;
  set have;
run;
proc transpose data=with_id out=want;
  by rowid;
  ....
run;

If you want to save space and time then perhaps you should make a view instead of a dataset.

data with_idv / view=with_idv;
  rowid + 1;
  set have;
run;