Proc transposed help

[Gil_]

I have a tsble thst looks like this
Cp_ID,
ID,
CONTENT,
ITEMCOUNT
LAST MODIFY
I DO A SORT content
Data looks like
Cpid. Id. Content. Count. Last modify
Cpid123. A2. One. 1864 20sep2018 17:54:02
Cpid123. A2. Two 20 20sep2018 17:36:09
Cpid123. A2. Five. 543 20sep2018 17 59:04
Cpid123. A2. Ten. 67 20sep2018 17:38:16
Cpid123. A2. One. 500 19sep2018 16:33:08
Cpid123. A2. Two 200 19sep2018 17:49:12
I need the proc transposed to look

Cpid. Id. Date. . One. Two five ten

[VDD]

a link to how to transpose data.

https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

[Reeza]

You can use the methods here to provide sample data in a format that others can easily use:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

[Gil_]

I didnt know it posted i was getting and error message sorry

[VDD · Accepted solution]

here is the transpose you are requesting:

data have;
input Cp_ID $
ID $
CONTENT $
ITEMCOUNT
LAST :date9. MODIFY $;
cards;
Cpid123. A2. One. 1864 20sep2018 17:54:02
Cpid123. A2. Two 20 20sep2018 17:36:09
Cpid123. A2. Five. 543 20sep2018 17:59:04
Cpid123. A2. Ten. 67 20sep2018 17:38:16
Cpid123. A2. One. 500 19sep2018 16:33:08
Cpid123. A2. Two 200 19sep2018 17:49:12
;
proc sort data=have;
	by cp_id id last modify;
run;
proc transpose data=have out=want(drop=_name_);
   by cp_id id last modify;
   id content;
   var itemcount;
   format last date9.;
run;
proc print data=want;run;

[Gil_]

Reeza i cant copy and post my actual code restrictions

[Reeza]

Then make fake data or use a dataset from SASHELP.CLASS. 

---

@Gil_ wrote:
Reeza i cant copy and post my actual code restrictions

---

[Gil_]

Hi VOD, it partial work its seems to be missing 2entries.
Cpid123. A2. One. 1844 20sep2018 23:54:02
Cpid123. A2. Two 1844 20sep2018 23:54:02 Cpid123. A2. Five. 1844 20sep2018 23:54:02

Cpid123. A2. One. 1244 20sep2018 17:38:16

Cpid123. A2. Two. 1244 20sep2018 17:38:16

Cpid123. A2. Five 1244 20sep2018 17:38:16