data NewData; set YourData; if (countw(COLUMN1,'NA')-1)=0 then COLUMN2=substr(COLUMN1,1,7 ); else if (countw(COLUMN1,'NA')-1) ne 0 then COLUMN2=substr(COLUMN1,1, 10); proc print noobs; run; COLUMN1 COLUMN2 ABC.XYZ.EFG ABC.XYZ ABC.XYZ.EFG ABC.XYZ ABC.XYZ.EFG ABC.XYZ ABC.NA.XYZ.EFG ABC.NA.XYZ ABC.NA.XYZ.EFG ABC.NA.XYZ ABC.XYZ.EFG ABC.XYZ ABC.XYZ.EFG ABC.XYZ ABC.NA.XYZ ABC.NA.XYZ
... View more