{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Notebook Python SAS\n",
    "\n",
    "## Import des données dans Python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>speed</th>\n",
       "      <th>dist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  speed  dist\n",
       "0           1      4     2\n",
       "1           2      4    10\n",
       "2           3      7     4\n",
       "3           4      7    22\n",
       "4           5      8    16"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "# data_url = \"https://forge.scilab.org/index.php/p/rdataset/source/file/master/csv/datasets/cars.csv\"\n",
    "data_url = \"cars.csv\"\n",
    "df_python = pd.read_csv(data_url)\n",
    "df_python.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Supression de la première colonne"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>speed</th>\n",
       "      <th>dist</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   speed  dist\n",
       "0      4     2\n",
       "1      4    10\n",
       "2      7     4\n",
       "3      7    22\n",
       "4      8    16"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_python.drop(df_python.columns[[0]], axis=1, inplace=True)\n",
    "df_python.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summary avec Python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>speed</th>\n",
       "      <td>50.0</td>\n",
       "      <td>15.40</td>\n",
       "      <td>5.287644</td>\n",
       "      <td>4.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dist</th>\n",
       "      <td>50.0</td>\n",
       "      <td>42.98</td>\n",
       "      <td>25.769377</td>\n",
       "      <td>2.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>120.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       count   mean        std  min   25%   50%   75%    max\n",
       "speed   50.0  15.40   5.287644  4.0  12.0  15.0  19.0   25.0\n",
       "dist    50.0  42.98  25.769377  2.0  26.0  36.0  56.0  120.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_python.describe().transpose()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summary avec SAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SAS Connection established. Subprocess id is 4708\n",
      "\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Libref  = WORK\n",
       "Table   = _df\n",
       "Dsopts  = {}\n",
       "Results = Pandas"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import saspy\n",
    "session_sas = saspy.SASsession(cfgname='winlocal')\n",
    "df_sas = session_sas.df2sd(df_python)\n",
    "df_sas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "- La fonction `df2sd()` produit un objet Python, ici `df_sas`, qui contient une table SAS nommée `_df`.\n",
    "- `SASPy` fournit des objets Python de haut niveau pour les principales procédures SAS.\n",
    "- Toutes les fonctions SAS sont exécutables à l'aide de la commande magique `%%SAS`.\n",
    "- On applique les fonctions Python sur l'objet `df_sas` et les fonctions SAS sur l'objet `_df`."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Variable</th>\n",
       "      <th>N</th>\n",
       "      <th>NMiss</th>\n",
       "      <th>Median</th>\n",
       "      <th>Mean</th>\n",
       "      <th>StdDev</th>\n",
       "      <th>Min</th>\n",
       "      <th>P25</th>\n",
       "      <th>P50</th>\n",
       "      <th>P75</th>\n",
       "      <th>Max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>speed</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>15.40</td>\n",
       "      <td>5.287644</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>19</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>dist</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>42.98</td>\n",
       "      <td>25.769377</td>\n",
       "      <td>2</td>\n",
       "      <td>26</td>\n",
       "      <td>36</td>\n",
       "      <td>56</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Variable   N  NMiss  Median   Mean     StdDev  Min  P25  P50  P75  Max\n",
       "0    speed  50      0      15  15.40   5.287644    4   12   15   19   25\n",
       "1     dist  50      0      36  42.98  25.769377    2   26   36   56  120"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sas.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<!DOCTYPE html>\r\n",
       "<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n",
       "<head>\r\n",
       "<meta charset=\"utf-8\"/>\r\n",
       "<meta content=\"SAS 9.4\" name=\"generator\"/>\r\n",
       "<title>Sortie SAS</title>\r\n",
       "<style>\r\n",
       "/*<![CDATA[*/\r\n",
       ".body.c section > table, .body.c section > pre, .body.c div > table,\r\n",
       ".body.c div > pre, .body.c article > table, .body.c article > pre,\r\n",
       ".body.j section > table, .body.j section > pre, .body.j div > table,\r\n",
       ".body.j div > pre, .body.j article > table, .body.j article > pre,\r\n",
       ".body.c p.note, .body.c p.warning, .body.c p.error, .body.c p.fatal,\r\n",
       ".body.j p.note, .body.j p.warning, .body.j p.error, .body.j p.fatal,\r\n",
       ".body.c > table.layoutcontainer, .body.j > table.layoutcontainer { margin-left: auto; margin-right: auto }\r\n",
       ".layoutregion.l table, .layoutregion.l pre, .layoutregion.l p.note,\r\n",
       ".layoutregion.l p.warning, .layoutregion.l p.error, .layoutregion.l p.fatal { margin-left: 0 }\r\n",
       ".layoutregion.c table, .layoutregion.c pre, .layoutregion.c p.note,\r\n",
       ".layoutregion.c p.warning, .layoutregion.c p.error, .layoutregion.c p.fatal { margin-left: auto; margin-right: auto }\r\n",
       ".layoutregion.r table, .layoutregion.r pre, .layoutregion.r p.note,\r\n",
       ".layoutregion.r table, .layoutregion.r pre, .layoutregion.r p.note,\r\n",
       ".layoutregion.r p.warning, .layoutregion.r p.error, .layoutregion.r p.fatal { margin-right: 0 }\r\n",
       "article, aside, details, figcaption, figure, footer, header, hgroup, nav, section { display: block }\r\n",
       "html{ font-size: 100% }\r\n",
       ".body { margin: 1em; font-size: 13px; line-height: 1.231 }\r\n",
       "sup { position: relative; vertical-align: baseline; bottom: 0.25em; font-size: 0.8em }\r\n",
       "sub { position: relative; vertical-align: baseline; top: 0.25em; font-size: 0.8em }\r\n",
       "ul, ol { margin: 1em 0; padding: 0 0 0 40px }\r\n",
       "dd { margin: 0 0 0 40px }\r\n",
       "nav ul, nav ol { list-style: none; list-style-image: none; margin: 0; padding: 0 }\r\n",
       "img { border: 0; vertical-align: middle }\r\n",
       "svg:not(:root) { overflow: hidden }\r\n",
       "figure { margin: 0 }\r\n",
       "table { border-collapse: collapse; border-spacing: 0 }\r\n",
       ".layoutcontainer { border-collapse: separate; border-spacing: 0 }\r\n",
       "p { margin-top: 0; text-align: left }\r\n",
       "span { text-align: left }\r\n",
       "table { margin-bottom: 1em }\r\n",
       "td, th { text-align: left; padding: 3px 6px; vertical-align: top }\r\n",
       "td[class$=\"fixed\"], th[class$=\"fixed\"] { white-space: pre }\r\n",
       "section, article { padding-top: 1px; padding-bottom: 8px }\r\n",
       "hr.pagebreak { height: 0px; border: 0; border-bottom: 1px solid #c0c0c0; margin: 1em 0 }\r\n",
       ".stacked-value { text-align: left; display: block }\r\n",
       ".stacked-cell > .stacked-value, td.data > td.data, th.data > td.data, th.data > th.data, td.data > th.data, th.header > th.header { border: 0 }\r\n",
       ".stacked-cell > div.data { border-width: 0 }\r\n",
       ".systitleandfootercontainer { white-space: nowrap; margin-bottom: 1em }\r\n",
       ".systitleandfootercontainer > p { margin: 0 }\r\n",
       ".systitleandfootercontainer > p > span { display: inline-block; width: 100%; white-space: normal }\r\n",
       ".batch { display: table }\r\n",
       ".toc { display: none }\r\n",
       ".proc_note_group, .proc_title_group { margin-bottom: 1em }\r\n",
       "p.proctitle { margin: 0 }\r\n",
       "p.note, p.warning, p.error, p.fatal { display: table }\r\n",
       ".notebanner, .warnbanner, .errorbanner, .fatalbanner,\r\n",
       ".notecontent, .warncontent, .errorcontent, .fatalcontent { display: table-cell; padding: 0.5em }\r\n",
       ".notebanner, .warnbanner, .errorbanner, .fatalbanner { padding-right: 0 }\r\n",
       ".body > div > ol li { text-align: left }\r\n",
       ".c { text-align: center }\r\n",
       ".r { text-align: right }\r\n",
       ".l { text-align: left }\r\n",
       ".j { text-align: justify }\r\n",
       ".d { text-align: right }\r\n",
       ".b { vertical-align: bottom }\r\n",
       ".m { vertical-align: middle }\r\n",
       ".t { vertical-align: top }\r\n",
       ".aftercaption {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "    padding-top: 4pt;\r\n",
       "}\r\n",
       ".batch > colgroup {\r\n",
       "    border-left: 1px solid #c1c1c1;\r\n",
       "    border-right: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".batch > tbody, .batch > thead, .batch > tfoot {\r\n",
       "    border-top: 1px solid #c1c1c1;\r\n",
       "    border-bottom: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".batch { border: hidden; }\r\n",
       ".batch {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: 1px solid #c1c1c1;\r\n",
       "    border-collapse: separate;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: 'SAS Monospace', 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    padding: 7px;\r\n",
       "    }\r\n",
       ".beforecaption {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".body {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    margin-left: 8px;\r\n",
       "    margin-right: 8px;\r\n",
       "}\r\n",
       ".bodydate {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    text-align: right;\r\n",
       "    vertical-align: top;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".bycontentfolder {\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: none;\r\n",
       "    margin-left: 6pt;\r\n",
       "}\r\n",
       ".byline {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".bylinecontainer > col, .bylinecontainer > colgroup > col, .bylinecontainer > colgroup, .bylinecontainer > tr, .bylinecontainer > * > tr, .bylinecontainer > thead, .bylinecontainer > tbody, .bylinecontainer > tfoot { border: none; }\r\n",
       ".bylinecontainer {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: none;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".caption {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".cell, .container {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".contentfolder, .contentitem {\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: none;\r\n",
       "    margin-left: 6pt;\r\n",
       "}\r\n",
       ".contentproclabel, .contentprocname {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".contents {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: decimal;\r\n",
       "    margin-left: 8px;\r\n",
       "    margin-right: 8px;\r\n",
       "}\r\n",
       ".contentsdate {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".contenttitle {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".continued {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".data, .dataemphasis {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".dataemphasisfixed {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".dataempty {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".datafixed {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".datastrong {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".datastrongfixed {\r\n",
       "    background-color: #ffffff;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".date {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".document {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".errorbanner {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".errorcontent {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".errorcontentfixed {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".extendedpage {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 1pt;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "    text-align: center;\r\n",
       "}\r\n",
       ".fatalbanner {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".fatalcontent {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".fatalcontentfixed {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".folderaction {\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: none;\r\n",
       "    margin-left: 6pt;\r\n",
       "}\r\n",
       ".footer {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".footeremphasis {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".footeremphasisfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".footerempty {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".footerfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".footerstrong {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".footerstrongfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".frame {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".graph > colgroup {\r\n",
       "    border-left: 1px solid #c1c1c1;\r\n",
       "    border-right: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".graph > tbody, .graph > thead, .graph > tfoot {\r\n",
       "    border-top: 1px solid #c1c1c1;\r\n",
       "    border-bottom: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".graph { border: hidden; }\r\n",
       ".graph {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: 1px solid #c1c1c1;\r\n",
       "    border-collapse: separate;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    }\r\n",
       ".header {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".headeremphasis {\r\n",
       "    background-color: #d8dbd3;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".headeremphasisfixed {\r\n",
       "    background-color: #d8dbd3;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".headerempty {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".headerfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".headersandfooters {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".headerstrong {\r\n",
       "    background-color: #d8dbd3;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".headerstrongfixed {\r\n",
       "    background-color: #d8dbd3;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #000000;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".index {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".indexaction, .indexitem {\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: none;\r\n",
       "    margin-left: 6pt;\r\n",
       "}\r\n",
       ".indexprocname {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".indextitle {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".layoutcontainer, .layoutregion {\r\n",
       "    border-width: 0;\r\n",
       "    border-spacing: 30px;\r\n",
       "}\r\n",
       ".linecontent {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".list {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: disc;\r\n",
       "}\r\n",
       ".list10 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: square;\r\n",
       "}\r\n",
       ".list2 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: circle;\r\n",
       "}\r\n",
       ".list3, .list4, .list5, .list6, .list7, .list8, .list9 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: square;\r\n",
       "}\r\n",
       ".listitem {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: disc;\r\n",
       "}\r\n",
       ".listitem10 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: square;\r\n",
       "}\r\n",
       ".listitem2 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: circle;\r\n",
       "}\r\n",
       ".listitem3, .listitem4, .listitem5, .listitem6, .listitem7, .listitem8, .listitem9 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: square;\r\n",
       "}\r\n",
       ".note {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".notebanner {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".notecontent {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".notecontentfixed {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".output > colgroup {\r\n",
       "    border-left: 1px solid #c1c1c1;\r\n",
       "    border-right: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".output > tbody, .output > thead, .output > tfoot {\r\n",
       "    border-top: 1px solid #c1c1c1;\r\n",
       "    border-bottom: 1px solid #c1c1c1;\r\n",
       "}\r\n",
       ".output { border: hidden; }\r\n",
       ".output {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: 1px solid #c1c1c1;\r\n",
       "    border-collapse: separate;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    }\r\n",
       ".pageno {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border-spacing: 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "    text-align: right;\r\n",
       "    vertical-align: top;\r\n",
       "}\r\n",
       ".pages {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: decimal;\r\n",
       "    margin-left: 8px;\r\n",
       "    margin-right: 8px;\r\n",
       "}\r\n",
       ".pagesdate {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".pagesitem {\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    list-style-type: none;\r\n",
       "    margin-left: 6pt;\r\n",
       "}\r\n",
       ".pagesproclabel, .pagesprocname {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".pagestitle {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".paragraph {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".parskip > col, .parskip > colgroup > col, .parskip > colgroup, .parskip > tr, .parskip > * > tr, .parskip > thead, .parskip > tbody, .parskip > tfoot { border: none; }\r\n",
       ".parskip {\r\n",
       "    border: none;\r\n",
       "    border-spacing: 0;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "    }\r\n",
       ".prepage {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    text-align: left;\r\n",
       "}\r\n",
       ".proctitle {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".proctitlefixed {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowfooter {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowfooteremphasis {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowfooteremphasisfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowfooterempty {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowfooterfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowfooterstrong {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowfooterstrongfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowheader {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowheaderemphasis {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowheaderemphasisfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: italic;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowheaderempty {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowheaderfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".rowheaderstrong {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".rowheaderstrongfixed {\r\n",
       "    background-color: #edf2f9;\r\n",
       "    border-color: #b0b7bb;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 0 1px 1px 0;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier, monospace;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".systemfooter, .systemfooter10, .systemfooter2, .systemfooter3, .systemfooter4, .systemfooter5, .systemfooter6, .systemfooter7, .systemfooter8, .systemfooter9 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".systemtitle, .systemtitle10, .systemtitle2, .systemtitle3, .systemtitle4, .systemtitle5, .systemtitle6, .systemtitle7, .systemtitle8, .systemtitle9 {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size: small;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".systitleandfootercontainer > col, .systitleandfootercontainer > colgroup > col, .systitleandfootercontainer > colgroup, .systitleandfootercontainer > tr, .systitleandfootercontainer > * > tr, .systitleandfootercontainer > thead, .systitleandfootercontainer > tbody, .systitleandfootercontainer > tfoot { border: none; }\r\n",
       ".systitleandfootercontainer {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: none;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".table > col, .table > colgroup > col {\r\n",
       "    border-left: 1px solid #c1c1c1;\r\n",
       "    border-right: 0 solid #c1c1c1;\r\n",
       "}\r\n",
       ".table > tr, .table > * > tr {\r\n",
       "    border-top: 1px solid #c1c1c1;\r\n",
       "    border-bottom: 0 solid #c1c1c1;\r\n",
       "}\r\n",
       ".table { border: hidden; }\r\n",
       ".table {\r\n",
       "    border-color: #c1c1c1;\r\n",
       "    border-style: solid;\r\n",
       "    border-width: 1px 0 0 1px;\r\n",
       "    border-collapse: collapse;\r\n",
       "    border-spacing: 0;\r\n",
       "    }\r\n",
       ".titleandnotecontainer > col, .titleandnotecontainer > colgroup > col, .titleandnotecontainer > colgroup, .titleandnotecontainer > tr, .titleandnotecontainer > * > tr, .titleandnotecontainer > thead, .titleandnotecontainer > tbody, .titleandnotecontainer > tfoot { border: none; }\r\n",
       ".titleandnotecontainer {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    border: none;\r\n",
       "    border-spacing: 1px;\r\n",
       "    color: #000000;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "    width: 100%;\r\n",
       "}\r\n",
       ".titlesandfooters {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".usertext {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".warnbanner {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: bold;\r\n",
       "}\r\n",
       ".warncontent {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: Arial, 'Albany AMT', Helvetica, Helv;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       ".warncontentfixed {\r\n",
       "    background-color: #fafbfe;\r\n",
       "    color: #112277;\r\n",
       "    font-family: 'Courier New', Courier;\r\n",
       "    font-size:  normal;\r\n",
       "    font-style: normal;\r\n",
       "    font-weight: normal;\r\n",
       "}\r\n",
       "/*]]>*/\r\n",
       "</style>\r\n",
       "</head>\r\n",
       "<body class=\"l body\">\r\n",
       "<h1 class=\"body toc\">Sortie SAS</h1>\r\n",
       "<section data-name=\"Means\" data-sec-type=\"proc\">\r\n",
       "<h1 class=\"contentprocname toc\">La MEANS Procédure</h1>\r\n",
       "<article id=\"IDX\">\r\n",
       "<h1 class=\"contentitem toc\">Statistiques descriptives</h1>\r\n",
       "<table class=\"table\" style=\"border-spacing: 0\">\r\n",
       "<colgroup><col/></colgroup><colgroup><col/><col/><col/><col/><col/></colgroup>\r\n",
       "<thead>\r\n",
       "<tr>\r\n",
       "<th class=\"b header\" scope=\"col\">Variable</th>\r\n",
       "<th class=\"r b header\" scope=\"col\">N</th>\r\n",
       "<th class=\"r b header\" scope=\"col\">Moyenne</th>\r\n",
       "<th class=\"r b header\" scope=\"col\">Ecart-type</th>\r\n",
       "<th class=\"r b header\" scope=\"col\">Minimum</th>\r\n",
       "<th class=\"r b header\" scope=\"col\">Maximum</th>\r\n",
       "</tr>\r\n",
       "</thead>\r\n",
       "<tbody>\r\n",
       "<tr>\r\n",
       "<th class=\"data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>speed</div>\r\n",
       "<div>dist</div>\r\n",
       "</div>\r\n",
       "</th>\r\n",
       "<td class=\"r data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>50</div>\r\n",
       "<div>50</div>\r\n",
       "</div>\r\n",
       "</td>\r\n",
       "<td class=\"r data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>15.40</div>\r\n",
       "<div>42.98</div>\r\n",
       "</div>\r\n",
       "</td>\r\n",
       "<td class=\"r data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>5.29</div>\r\n",
       "<div>25.77</div>\r\n",
       "</div>\r\n",
       "</td>\r\n",
       "<td class=\"r data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>4.00</div>\r\n",
       "<div>2.00</div>\r\n",
       "</div>\r\n",
       "</td>\r\n",
       "<td class=\"r data\">\r\n",
       "<div class=\"stacked-cell\">\r\n",
       "<div>25.00</div>\r\n",
       "<div>120.00</div>\r\n",
       "</div>\r\n",
       "</td>\r\n",
       "</tr>\r\n",
       "</tbody>\r\n",
       "</table>\r\n",
       "</article>\r\n",
       "</section>\r\n",
       "</body>\r\n",
       "</html>\r\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%SAS session_sas\n",
    "ods title;\n",
    "ods noproctitle;\n",
    "proc means data=_df maxdec=2;\n",
    "run;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Liens utiles\n",
    "\n",
    "**Code SAS dans notebook Jupyter :**\n",
    "\n",
    "- https://blogs.sas.com/content/sasdummy/2016/04/24/how-to-run-sas-programs-in-jupyter-notebook/\n",
    "- https://blogs.sas.com/content/sasdummy/2017/04/08/python-to-sas-saspy/\n",
    "- https://sassoftware.github.io/saspy/\n",
    "\n",
    "**Export vers pdf :**\n",
    "\n",
    "- https://github.com/sassoftware/sas_kernel/issues/13\n",
    "- https://stackoverflow.com/questions/43965823/convert-notebook-generated-html-snippet-to-latex-and-pdf\n",
    "- https://github.com/jupyter/nbconvert/issues/474\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}