I wrote the following code :   proc sql; create table new as SELECT * FROM A,B where A.AID= B.BID ;   My output is almost as desired except the ones with missing values. There are few observations in A where AID is missing and in final output instead of getting the set of observations as it is, I am getting it repeated n number of times. Could anybody please tell me the reason for the same. ... View more

 I want to remove the duplicate records but the ones that have missing values as follows Input 1234 12 1234   1234   1235 13 1235 13 1236 11 1237   1237   1237   1237 10 1238   1238     Desired Output 1234 12 1235 13 1236 11 1237 10 1238   ... View more

I am trying to create a distance matrix with the following piece of code   proc distance data=sample shape=SQR out=Dist method=Euclid ; var interval(a2--a6 / std=Std); id a1; run;   Although I am getting the output but all the variable names its taking from a1 have an underscore before it, for example a1 has values 1,2 ,3 ,4 ,5 ....and so, and in the distance matrix the variable names become _1, _2, _3, _4, _5... and so on.   Could anybody please tell me the reason and guide me the way to remove the same. Thanks in advance !  ... View more

I have the follwing table  ID a1 s2 d3 f4 g5 a 1 0 2.56217 3.36783 3.53842 3.00214 s 2 2.56217 0 2.87413 4.1333 3.60389 d 3 3.36783 2.87413 0 2.46764 3.39893 f 4 3.53842 4.1333 2.46764 0 2.97952 g 5 3.00214 3.60389 3.39893 2.97952 0   I want to sort this table rowwise(or may be columnwise) but instead of the observation value I need the variable name as output, something like below   ID id1 id2 id3 id4 id5 a 1 a1 s2 g5 d3 f4 s 2 s2 a1 d3 g5 f4 d 3 d3 f4 s2 a1 g5 f 4 f4 d3 g5 a1 s2 g 5 g5 f4 a1 d3 s2   Some more details: Considering only the first row of the table ID a1 s2 d3 f4 g5 a 1 0 2.56217 3.36783 3.53842 3.00214   Sorting It alonwith variable names ID a1 s2 d3 f4 g5 a 1 0 2.56217 3.36783 3.53842 3.00214   Resulting into ID a1 s2 g5 d3 f4 a 1 0 2.56217 3.00214 3.36783 3.53842 Now taking only the variable names ID           a 1 a1 s2 g5 d3 f4 Doing it for all the rows is my desired output     ... View more