topic Re: Transpose / sum entries in SAS Procedures

Transpose / sum entries

BETO — Wed, 10 Sep 2014 21:33:58 GMT

HI I need help with a Transpose Table

data is

DAte. Id. machine

08/1/14. G. A1

08/01/14. B. A2

08/01/14. L. A3

08/01/14. G. A4

08/01/14. B. A5

08/01/14. G. A6

i would like to see data output like this

Date G. B. L

08/01/14. 3. 2. 1

Thanks

Re: Transpose / sum entries

Reeza — Wed, 10 Sep 2014 21:43:23 GMT

Where does the 3/2/1 come from?

Re: Transpose / sum entries

stat_sas — Wed, 10 Sep 2014 21:52:30 GMT

data have;

input Date $ Id $ machine $;

datalines;

08/01/14 G A1

08/01/14 B A2

08/01/14 L A3

08/01/14 G A4

08/01/14 B A5

08/01/14 G A6

;

proc tabulate data=have;

class date id machine;

table date,id=' '*n=' ';

run;

Re: Transpose / sum entries

art297 — Wed, 10 Sep 2014 22:17:55 GMT

Since you want a dataset, expanding on stat@sas's code:

data have;

input Date $ Id $ machine $;

datalines;

08/01/14 G A1

08/01/14 B A2

08/01/14 L A3

08/01/14 G A4

08/01/14 B A5

08/01/14 G A6

;

proc tabulate data=have out=need (keep=date id n);

class date id machine;

table date,id=' '*n=' ';

run;

proc transpose data=need out=want (drop=_:);

by date;

id id;

var n;

run;

data want;

retain date G B L;

set want;

run;

Re: Transpose / sum entries

BETO — Thu, 11 Sep 2014 01:18:49 GMT

Hi Arthur Tabacheck,

i have an additional question how can I auto append the "want" table to access table ? so once want is created it appends it to access

Thanks

Re: Transpose / sum entries

art297 — Thu, 11 Sep 2014 02:27:01 GMT

I don't know what you mean by 'access' or what you want the final file to look like.

Re: Transpose / sum entries

BETO — Thu, 11 Sep 2014 02:32:15 GMT

HI Arthur

i would like to append it to Access its an office program Excel has extension of .XLS Access has .mdb

Re: Transpose / sum entries

art297 — Thu, 11 Sep 2014 02:50:37 GMT

Append it to an existing access file, or just create an access file? If it is the latter, and your site licences SAS/Access for pc file formats, look up proc export in the documentation.

Re: Transpose / sum entries

Ksharp — Thu, 11 Sep 2014 12:28:48 GMT

ODBC + libname . check it at support.sas.com to see how to set up a ODBC connection with database .