But, if you want to delete then why you have included them from Genomestudio or any software that you have used for SNP data processing. You can also open your file in excel and delete corresponding row and column from map and ped files. If your data are in 'tab' format then use text to column option in excel and you will get your data columnwise. I think it will help you. Thanks

thanks a lot Kummar the story is long, actually i have genotyped data for bovine 50k beadchip on Btau4.0 chr by chr. I get this data from my Prof. and he lost the rawdata. now, I want to make chr. genotype based on UMD3.1, so I seperated anontation based on UMD3.1 assembly for each chr. and then in map file with some script i found which anontion is not related to for example chr12 in UMD3.1 (i means it belong to Btau4.0) , now i want to delete this column number in ped file , I tried to open in excell 2012 but the the colum is long and i recived an error now i dont kon what can I do? i will be appriciate if some one give some suggetion to me

If I understood correctly, you are selecting the wanted SNPs you want from the map and you want to create a new ped with only them. Or the inverse: you want to remove from .ped the selected SNPs based in .map.

The safest way is to do it with a program that understand ped files and have slicing functions. plink is the industry standard one, used in many of the big GWAS projects. Look in the section for data management for extract and remove

Thank you Pablo I did it , I make a snp list file and then use this command in plink as below ./plink --file my-file --exclude my-snp-list file
it wrote for me on report ----------------------------------------------------------@ | PLINK! | v1.07 | 10/Aug/2009 | |----------------------------------------------------------| | (C) 2009 Shaun Purcell, GNU General Public License, v2 | |----------------------------------------------------------| | For documentation, citation & bug-report instructions: | | http://pngu.mgh.harvard.edu/purcell/plink/ | @----------------------------------------------------------@

Web-based version check ( --noweb to skip ) Recent cached web-check found... OK, v1.07 is current

Writing this text to log file [ plink.log ] Analysis started: Tue Nov 13 03:55:52 2012

Options in effect: --file mari --exclude mysnplist

1722 (of 1722) markers to be included from [ mari.map ] 410 individuals read from [ mari.ped ] 410 individuals with nonmissing phenotypes Assuming a disease phenotype (1=unaff, 2=aff, 0=miss) Missing phenotype value is also -9 0 cases, 410 controls and 0 missing 410 males, 0 females, and 0 of unspecified sex Reading list of SNPs to exclude [ mysnplist ] ... 404 read Before frequency and genotyping pruning, there are 1318 SNPs 410 founders and 0 non-founders found Total genotyping rate in remaining individuals is 0.986356 0 SNPs failed missingness test ( GENO > 1 ) 0 SNPs failed frequency test ( MAF < 0 ) After frequency and genotyping pruning, there are 1318 SNPs After filtering, 0 cases, 410 controls and 0 missing After filtering, 410 males, 0 females, and 0 of unspecified sex

Analysis finished: Tue Nov 13 03:55:53 2012

but know when i control the number of raw in map in new file is 1722, but I think it should be 1318 ??!?!?

I don't know its deleted 404 SNP or not? it didn't give me output file . I think it maybe put some (-) on some thing like that on map file , that it not readable in future analysis whats your idea?