That does work Art. Thank you ... View more

Female Male _COL_ COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 A B COL1 0.716692 0.820369 0.319965 0.537561 0.009048 0.623179 0.329801 0.501619 0.461064 C D COL2 0.47814 0.568633 0.377889 0.322076 0.848357 0.585695 0.190736 0.666417 0.753265 COL3 0.33489 0.464657 0.19093 0.712932 0.309871 0.298905 0.408627 0.931734 0.623899 E F COL4 0.182391 0.123417 0.184646 0.260479 0.347146 0.428899 0.070591 0.21143 0.833228 COL5 0.048757 0.780064 0.238505 0.923092 0.527054 0.210349 0.51993 0.463315 0.781508 G H COL6 0.564873 0.769461 0.520583 0.604096 0.174694 0.395051 0.149006 0.923724 0.669723 COL7 0.077545 0.799448 0.857925 0.023725 0.2919 0.145091 0.180948 0.425452 0.333822 I J COL8 0.40907 0.508158 0.975613 0.828987 0.009638 0.137749 0.039158 0.358044 0.816533 COL9 0.280801 0.596491 0.265516 0.568593 0.066118 0.680901 0.915639 0.379575 0.277307 In this case, I want to delete row/col 3,5,7,9 (which are in the to_delete dataset at this point) ... View more

I feel as though I can do this in PROC SQL but havent been successful today. I'm very close. I can delete the rows, but am stuck on deleting the columns Again, my "large matrix" has both rows and columns with the same variable names (COL1, COL2....COLi) so i merely create a dataset that has a list of these based off of some critera: data to_delete; set large_matrix; keep _COL_; if missing (Female);run;quit; to_delete contains random columns from which I want to delete both the row and column This successfully deletes the proper rows (not difficult). Deleting the proper columns is stumping though. proc sql; create table small_matrix as Select * from large_matrix; DELETE from small_matrix WHERE _COL_ in (select * from work.to_delete); /* alter table work.kjk drop column  in (work.tod) Does not work to remove columns */ ; QUIT; Thank you to all for your time. ... View more

data remove;    set mat2;    if row in('a','c') then delete;    if col in('a','c') then delete;    run; I need to delete something like ~1000 rows and columns from a 10,000 x 10,000 matrix, do I need to put the columns into an array then somehow reference the array in the data step? ... View more

I've used a PROC SQL statement similar to Haikuo's solution However, this was very impression by all people. Thank you so much for the responses. I plan on using this forum in the future if I am stumped in the future! Cheers! ... View more