Hi all, I'm performing one study about social network analysis. Before analysis, I need to transform my data in the appropriate format. My raw data are formatted like this: Tom Jack Jack Mike Tom Hellen Dora Hellen Ross Jack Will Paul Paul Howard Paul Andy Andy Kim Andy Tom One row means the two guys in the two columns are directly conneceted  (No matter left-right connected or right-left connected). I need to transform my data like this( if the two guys are directly connectted, the content in the matrix are 1. Finally,one symmetric matrxi will be created): names Andy Dora Hellen Howard Jack Kim Mike Paul Ross Tom Will Andy 1 0 0 0 0 1 0 1 0 1 0 Dora 0 1 0 0 0 0 0 0 0 0 0 Hellen 0 0 1 0 0 0 0 0 0 1 0 Howard 0 0 0 1 0 0 0 1 0 0 0 Jack 0 0 0 0 1 0 1 0 1 1 0 Kim 1 0 0 0 0 1 0 0 0 0 0 Mike 0 0 0 0 1 0 1 0 0 0 0 Paul 1 0 0 1 0 0 0 1 0 0 0 Ross 0 0 0 0 1 0 0 0 1 0 0 Tom 1 0 1 0 1 0 0 0 0 1 0 Will 0 0 0 0 0 0 0 0 0 0 1 How to achieve this? Thanks in advance. Tom ... View more

When we should use Replacement node and when use Impute node? Thanks. Best Tom ... View more

Hi guys, I want to reformat my data. If gender="M", I'll reformat it as 1.if others,  I'll reformat it as 0.  I wrote the codes as below. But it didn't work as expected.  Did I use "others" wrongly?  Thanks. Tomi proc format; value $gender   "M"=1                               others=0; data have; input gender $ @@; datalines; F M M G R T ; run; data want; set have; format gender $gender.; run; ... View more