topic Re: Proc transposed help in SAS Programming

Proc transposed help

Gil_ — Thu, 20 Sep 2018 22:43:19 GMT

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

Re: Proc transposed help

VDD — Thu, 20 Sep 2018 23:04:25 GMT

a link to how to transpose data.

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

Re: Proc transposed help

Reeza — Fri, 21 Sep 2018 00:43:22 GMT

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-data-AKA-generate/ta-p/258712

Re: Proc transposed help

Gil_ — Fri, 21 Sep 2018 03:28:03 GMT

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

Re: Proc transposed help

VDD — Fri, 21 Sep 2018 03:39:01 GMT

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;

Re: Proc transposed help

Gil_ — Fri, 21 Sep 2018 03:29:03 GMT

Reeza i cant copy and post my actual code restrictions

Re: Proc transposed help

Reeza — Fri, 21 Sep 2018 03:46:59 GMT

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

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

Re: Proc transposed help

Gil_ — Fri, 21 Sep 2018 04:03:56 GMT

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