Suppose there are three districts: ag, du, and si. And the "count" variable indicates the number of people moving from a district from another district.
origin destination count
ag ag 0
ag du 41
ag si 13
du ag 3
du du 0
du si 79
si ag 7
si du 6
si si 0
And I have to convert the above data to a matrix form as follows:
0 41 13
3 0 79
7 6 0
How do I have to write the code to do that? Thanks.
Use transpose :
data OD;
input origin $ destination $ count;
datalines;
ag ag 0
ag du 41
ag si 13
du ag 3
du du 0
du si 79
si ag 7
si du 6
si si 0
;
proc sort data=OD; by origin destination; run;
proc transpose data=OD out=ODmat(drop=_NAME_);
by origin;
var count;
id destination;
run;
proc print data=ODmat noobs; run;
PG
Use transpose :
data OD;
input origin $ destination $ count;
datalines;
ag ag 0
ag du 41
ag si 13
du ag 3
du du 0
du si 79
si ag 7
si du 6
si si 0
;
proc sort data=OD; by origin destination; run;
proc transpose data=OD out=ODmat(drop=_NAME_);
by origin;
var count;
id destination;
run;
proc print data=ODmat noobs; run;
PG
Thanks! It works!
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.