I have a dataset that looks like this:

```
df_dummy = data.frame(
  Company=c("0001","0002","0003","0004","0005"),
  Measure=c("A","B","C","D","E"),
  Num=c(10,10,10,10,10),
  Den=c(20,20,20,20,20),
  Rate=c(50.0,50.0,50.0,50.0,50.0)
)

df_dummy$Company <- as.character(df_dummy$Company)
df_dummy$Measure <- as.character(df_dummy$Measure)

```

I am using this to export to an .xpt file

```
write.xport(df_dummy, file = "data/tmp.xpt")
lookup.xport("data/tmp.xpt")

```

In SAS, I use this code to import:

```
libname sasfile 'PATH\data';
libname xptfile xport 'PATH\data\tmp.xpt' access=readonly;
proc copy inlib=xptfile outlib=sasfile;
run;

```

The table looks fine, but the rate doesn't show the decimal point.

In my actual dataset, there are a lot more rows but it's the same format essentially and if I run a lookup.xport I get this:

```
Variables in data set `MEASURES':
  dataset    name      type format flength fdigits iformat iflength ifdigits label  nobs
 MEASURES   ID character              0       0                0        0       29064
 MEASURES MEASURE character              0       0                0        0       29064
 MEASURES     NUM   numeric              0       0                0        0       29064
 MEASURES     DEN   numeric              0       0                0        0       29064
 MEASURES    RATE   numeric              0       0                0        0       29064

```

However, if I use the same SAS code to import this, I get something that looks completely off and I can't figure out what's causing it.

[![enter image description here](https://i.stack.imgur.com/33j9i.png)](https://i.stack.imgur.com/33j9i.png)