Question: How would you import an online xls file in SAS ?

I tried

```
proc import
    out=test
    datafile='//statbel.fgov.be/fr/binaries/311111Population%20de%20droit%201990-2011_fr_tcm326-55771.xls'
    dbms=excel
    replace;
run;quit;

```

ERROR: DBMS type EXCEL not valid for import.

I also tried DBMS=xls and DBMS=XLSX

SAS 9.3 in SAS enterprise guide 5.1

Operating System: WX64\_SV .  

---Base SAS Software  

---SAS/STAT  

---SAS/GRAPH  

---SAS/ETS  

---SAS/CONNECT  

---SAS/IntrNet  

---SAS Integration Technologies  

---SAS/ACCESS Interface to ODBC  

---SAS Workspace Server for Local Access  

---SAS Workspace Server for Enterprise Access  

---DataFlux Trans DB Driver  

---SAS Framework Data Server  

---SAS Add-in for Microsoft Excel  

---SAS Add-in for Microsoft Outlook  

---SAS Add-in for Microsoft PowerPoint  

---SAS Add-in for Microsoft Word

Answer: 
Making the sidebar position as "fixed" it stays, doesn't matter how much content you have. I don't know if I solve your problem but hope it helps ;)

Here's the code:

```
#sidebar {
    width: 280px;
    position: fixed;
    top: 0;
    bottom: 0;
    background: blue; }

```

Here's the [fiddle](http://jsfiddle.net/ManelMusti/B3bCb/4/)
You have a couple of choices, but the gist is to do with CSS `position`.

The reason `position: absolute;` does not work is because it needs some tweaking for that to work. You need to disable scrolling on the html, body, and wrapper classes, and enable scrolling on the content-area.

```
html, body, wrapper {
  overflow: hidden;
}

.content-area {
  overflow: auto;
}

```

You can see [an example of this here](https://github.com/abitdodgy/sidebar-layout/tree/master). It's a responsive sidebar layout I made.

The other option is to use a `position: fixed;` on the sidebar, as others have noted.