Hi Folks:   I'm trying to create a data of CORR and it's corresponding p-values from proc corr. Outp option outputs only CORR that I need but not p-value.  Any suggestion as to how I could achieve the DESIRED OUTPUT below? Mock dataset attached to this post with two example variables and an outcome variable 'log_outcome'. I have many variables in actuality so that re-organizing in Excel sheet manually is not ideal.       proc corr data=have outp=outp; var log_outcome houses rentals; run; ... View more

Hi Folks:   I'm creating a 'group' variable based on the specific values that 'idname' character variable takes. However, my simple if then statement is not working. It picks up almost randomly. Look how group=1 include city of Buk that i did not specify and the rest groups are even more inaccurate.  What am i doing wrong here?    Any pointers appreciated.   DATA all (keep =idname group group1); SET m.alldata_id; retain group; if IDNAME IN ('Bundang' 'Jungwon' 'Sujeong') THEN GROUP=1; ELSE if IDNAME IN ('Gwonseon' 'Jangan' 'Paldal' 'Yeongtong') THEN GROUP=2; ELSE if IDNAME IN ('Cheoin' 'Yongin' 'Cheoin' 'Giheung' 'Suji' 'Suyon') THEN GROUP=3; ELSE if IDNAME IN ('Heungdeok' 'Cheongju' 'Heungdeok' 'Seowon' 'Sangdang' 'Cheongwon') THEN GROUP=4; ELSE if IDNAME IN ('Changwon' 'Uichang' 'Seongsan' 'Masanhappo' 'Masanhoewon' 'Jinhae') THEN GROUP=5; ELSE if IDNAME IN ('Deogyang' 'Ilsandong' 'Ilsanseogu') THEN GROUP=6; else group+1; run; ... View more

Hi Folks: I'm trying to replace missing information by existing information in the data with some conditions applied as shown in the image below. I couldn't do it manually and hope there's a way to automate this in SAS?      if prxmatch("m/A|B|C/oi",NAME) > 0 then fill missing in variable I using the available value. Which is 10 for I, 25 for J and 23 for K variables. if prxmatch("m/D|E|F/oi",NAME) > 0 then fill missing in variable I using the available value. Which is 2 for I, 25 for J and 3 for K variables. I have 10 more batches by prxmatch conditions as shown above. About 85% of data has no missing as shown by G and H rows. No action needed if no missing outside the rows specified in the prxmatch clauses.   DATA FILL; INPUT NAME $ I J K; CARDS; A 10 . . B . 25 . C . . 23 D 2 . . E . . 3 F . 25 . G 1 2 4 H 5 7 8 ; I greatly appreciate your time and help.    ... View more