topic Re: Transpose based on a group in SAS Programming

Transpose based on a group

forumsguy — Thu, 30 Apr 2015 12:48:35 GMT

Hi,

I have a dataset which looks like this

Name	City
John	Washington
John	Chicago
John	Newyork
Mary	Washington
Mary	Dallas

And I want to Transpose it based on Group of Name and City output should be something like this

Output_Report

John

Washington

Chicago

Newyork

Mary

Washington

Dallas

Is it possible to create a dataset/PDF report like this ?

Any help is really appreciated

Re: Transpose based on a group

RW9 — Thu, 30 Apr 2015 12:58:39 GMT

Question is, why would you want to, its then hard to see what is a name and what is a city. If you have to then:

data want;

set have;

by name;

if first.name then do;

output_report=name;

output;

output_report=city;

output;

end;

else do;

output_report=city;

output;

end;

run;

However to my mind it makes more sense to report both columns, but just group the first in a report:

proc report data=have;

columns name city;

define name / order "Name";

define city / "City";

run;

This will display:

Name City

John Washington

Chicago

NewYork

Mary Washington

...

Re: Transpose based on a group

Ksharp — Thu, 30 Apr 2015 16:12:24 GMT

You really should post it at ODS and Report forum if it is a proc report problem.

data have;
input  Name $     City : $20.;
cards;
John     Washington
John     Chicago
John     Newyork
Mary     Washington
Mary     Dallas
;
run;
 
proc report data=have nowd;
     columns name city;
     define name / order "Name" noprint;
     define city / "City";
      compute before name;
       line name $;
      endcomp;
run;

Xia Keshan