hi, The reason this is happening is because when you select *, you are telling sas you want to include everything from both the tables, and as year and season exists on both tables you can't have two variables with the same name. In order to get rid of it, you would need to tell SAS which of the two tables you want to pull year and season from. ... View more

Your choices vary according to whether your variables are ordinal or nominal, but look at the DISTANCE procedure and the various proximity measures it provides. Some are applicable for discrete variables.  You can then get a "distance" matrix (dis/similarity matrix) that can be used to cluster variables. I haven't done this myself (I use correpondence analysis instead) butI think it will work. ... View more

here is the methodology, http://bioterrorism.slu.edu/bt/products/bio_epi/scripts/mod12.pdf do let me know if you need any more help HTH Sivaji ... View more

Thank you very much. I will look into the article you recommended. ... View more

Hi, All I apologize for late response. And Thank you all very much for great help. ... View more

in case some one get interested: I tested again: the code is working. I waited about 10 minutes before everything is done. when i looked at log, i got following: 110  ODS HTML FILE='C:\Exercise\ASSOCIATION.HTML'; NOTE: Writing HTML Body file: C:\Exercise\ASSOCIATION.HTML 111  PROC PRINT DATA = DATA_ASSOCIATION; 112  RUN; NOTE: There were 4 observations read from the data set WORK.DATA_ASSOCIATION. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.14 seconds       cpu time            0.01 seconds 113  ODS HTML CLOSE; I don't know why it takes 10 minutes; maybe my computer is too old :--) ... View more

Why not  parse the whole row to get this age?If height weight were 3 width, id were 3 width, sex were 1 width ,always. filename FT15F001 temp; data _null_;    infile FT15F001 truncover;    input row $100.; age=input(substr(row,5,length(row)-10),best8.); put age=;    parmcards; 001F36175180 002F9120100 003F110180160 ;;;;    run; Ksharp ... View more