Date:         Fri, 29 Jul 2011 03:36:03 -0400
Reply-To:     Hari Prasad <hariprasad@TAKESOLUTIONS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Hari Prasad <hariprasad@TAKESOLUTIONS.COM>
Subject:      Re: transpose?
Comments: To: Adriano Rodrigues <adriano@GPP.COM.BR>

SORRY TYPO ERROR IN LAST MESSAGE. PLEASE IGNORE IT.

data x;
input Car $ country $ salemark;
datalines;
Fiat Brazil  1000
Fiat Argentina 1500
Fiat Espana 2000
Fiat Japan 3000
BMW Brasil 4000
BMW Italy 2000
Mercedes Italy 5000
Citroen   Japan 4000
Citroen  USA  10000
;
run;

proc sort data=x;
 by car ;
run;

proc transpose data=x out=y1 prefix=country;
 by car ;
 var  country;
run;

proc transpose data=x out=y2 prefix=salemark;
 by car ;
 var  salemark;
run;

data y3;
 merge y1 y2;
 by car;
run;

proc print data=y3 ;
 var car country1 salemark1 country2 salemark2 country3 salemark3 country4
salemark4;
run;