Transpose / sum entries

[BETO]

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

[Reeza]

Where does the 3/2/1 come from?

[stat_sas]

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;

[art297 · Accepted solution]

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;

[BETO]

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

[art297]

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

[BETO]

HI Arthur

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

[art297]

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.

[Ksharp]

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