I have a dataset as following 

```
ID  A1  A2  A3
A   1.2 1.5 1
A   1.3 1.7 1.3
A   1.4 1.8 1.7
B   1.5 1.8 1.9
B  1.6 1.7 1.0

```

and result I am looking for is 

```
A   1.2 1.5 1 1.3 1.7 1.3 1.4 1.8 1.7

```

I know that SAS variable names cannot be repeated but when I tried Proc SQL, with inner join it gives me more rows.