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
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
...
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.