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
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;
Where does the 3/2/1 come from?
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;
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;
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
I don't know what you mean by 'access' or what you want the final file to look like.
HI Arthur
i would like to append it to Access its an office program Excel has extension of .XLS Access has .mdb
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.
ODBC + libname . check it at support.sas.com to see how to set up a ODBC connection with database .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.