{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Analyse des données de FAO"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Installation du kernel SAS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: saspy in /opt/conda/lib/python3.6/site-packages (5.100.2)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install saspy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: sas_kernel in /opt/conda/lib/python3.6/site-packages (2.4.13)\n",
      "Requirement already satisfied: metakernel>=0.27.5 in /opt/conda/lib/python3.6/site-packages (from sas_kernel) (0.28.2)\n",
      "Requirement already satisfied: saspy>=3.6 in /opt/conda/lib/python3.6/site-packages (from sas_kernel) (5.100.2)\n",
      "Requirement already satisfied: ipython>=7 in /opt/conda/lib/python3.6/site-packages (from sas_kernel) (7.12.0)\n",
      "Requirement already satisfied: jupyter-client>=6 in /opt/conda/lib/python3.6/site-packages (from sas_kernel) (6.0.0)\n",
      "Requirement already satisfied: jupyter-core in /opt/conda/lib/python3.6/site-packages (from metakernel>=0.27.5->sas_kernel) (4.6.3)\n",
      "Requirement already satisfied: pexpect>=4.2 in /opt/conda/lib/python3.6/site-packages (from metakernel>=0.27.5->sas_kernel) (4.8.0)\n",
      "Requirement already satisfied: jedi<0.18; python_version <= \"3.6\" in /opt/conda/lib/python3.6/site-packages (from metakernel>=0.27.5->sas_kernel) (0.16.0)\n",
      "Requirement already satisfied: ipykernel in /opt/conda/lib/python3.6/site-packages (from metakernel>=0.27.5->sas_kernel) (5.1.4)\n",
      "Requirement already satisfied: traitlets>=4.2 in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (4.3.3)\n",
      "Requirement already satisfied: decorator in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (4.4.1)\n",
      "Requirement already satisfied: setuptools>=18.5 in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (45.2.0.post20200209)\n",
      "Requirement already satisfied: prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0 in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (3.0.3)\n",
      "Requirement already satisfied: backcall in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (0.1.0)\n",
      "Requirement already satisfied: pygments in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (2.5.2)\n",
      "Requirement already satisfied: pickleshare in /opt/conda/lib/python3.6/site-packages (from ipython>=7->sas_kernel) (0.7.5)\n",
      "Requirement already satisfied: tornado>=4.1 in /opt/conda/lib/python3.6/site-packages (from jupyter-client>=6->sas_kernel) (6.0.3)\n",
      "Requirement already satisfied: pyzmq>=13 in /opt/conda/lib/python3.6/site-packages (from jupyter-client>=6->sas_kernel) (17.1.2)\n",
      "Requirement already satisfied: python-dateutil>=2.1 in /opt/conda/lib/python3.6/site-packages (from jupyter-client>=6->sas_kernel) (2.8.1)\n",
      "Requirement already satisfied: ptyprocess>=0.5 in /opt/conda/lib/python3.6/site-packages (from pexpect>=4.2->metakernel>=0.27.5->sas_kernel) (0.6.0)\n",
      "Requirement already satisfied: parso>=0.5.2 in /opt/conda/lib/python3.6/site-packages (from jedi<0.18; python_version <= \"3.6\"->metakernel>=0.27.5->sas_kernel) (0.6.0)\n",
      "Requirement already satisfied: ipython-genutils in /opt/conda/lib/python3.6/site-packages (from traitlets>=4.2->ipython>=7->sas_kernel) (0.2.0)\n",
      "Requirement already satisfied: six in /opt/conda/lib/python3.6/site-packages (from traitlets>=4.2->ipython>=7->sas_kernel) (1.14.0)\n",
      "Requirement already satisfied: wcwidth in /opt/conda/lib/python3.6/site-packages (from prompt-toolkit!=3.0.0,!=3.0.1,<3.1.0,>=2.0.0->ipython>=7->sas_kernel) (0.1.8)\n",
      "Note: you may need to restart the kernel to use updated packages.\n"
     ]
    }
   ],
   "source": [
    "pip install sas_kernel"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Une fois les deux commandes lancées, il faut enregistrer et quitter (et restart the kernel ?). Mais quand on revient on a bien SAS proposé dans les kernel (Kernel > Change kernel)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\u001b[0;31m[<class 'saspy.sasexceptions.SASIOConnectionTerminated'>, SASIOConnectionTerminated(<class 'Exception'>,), <traceback object at 0x7fe1cf696688>]\n",
      "\u001b[0m"
     ]
    }
   ],
   "source": [
    "%load_ext saspy.ipython\n",
    "%%SAS\n",
    "proc import out=table\n",
    "datafile='module2/exo4/cdu_ba_pied.csv' \n",
    "dbms=dlm replace;\n",
    "delimiter=';'; /*csv*/\n",
    "getnames=yes; /*la première ligne donne les noms des variables*/\n",
    "guessingrows=max; /*utilisation du max de lignes pour déterminer le type de variable (numérique / nombre de caractères, etc*/\n",
    "run;\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "ça ne marche pas parce qu'il faut réussir à connecter Jupyter avec SAS (pour la licence je pense) donc j'abandonne (pas sûre que ça vale le coût de passer du temps dessus, mais à voir) et je reste en R."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retour au kernel R"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Je change le Kernel (dans Kernel > Change Kernel > R)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "library(readr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table>\n",
       "<thead><tr><th scope=col>/home/3f624f2cce5b76d09dcee501242941ad/</th></tr></thead>\n",
       "<tbody>\n",
       "\t<tr><td>mooc-rr/module2/exo4/cdu_ba_pied.csv</td></tr>\n",
       "</tbody>\n",
       "</table>\n"
      ],
      "text/latex": [
       "\\begin{tabular}{r|l}\n",
       " /home/3f624f2cce5b76d09dcee501242941ad/\\\\\n",
       "\\hline\n",
       "\t mooc-rr/module2/exo4/cdu\\_ba\\_pied.csv\\\\\n",
       "\\end{tabular}\n"
      ],
      "text/markdown": [
       "\n",
       "/home/3f624f2cce5b76d09dcee501242941ad/ | \n",
       "|---|\n",
       "| mooc-rr/module2/exo4/cdu_ba_pied.csv | \n",
       "\n",
       "\n"
      ],
      "text/plain": [
       "  /home/3f624f2cce5b76d09dcee501242941ad/\n",
       "1 mooc-rr/module2/exo4/cdu_ba_pied.csv   "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "data1 <- read_csv('/home/3f624f2cce5b76d09dcee501242941ad/\n",
    "mooc-rr/module2/exo4/cdu_ba_pied.csv')\n",
    "head(data1)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Bon j'arrive pas à importer le fichier ça me soule"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "R",
   "language": "R",
   "name": "ir"
  },
  "language_info": {
   "codemirror_mode": "r",
   "file_extension": ".r",
   "mimetype": "text/x-r-source",
   "name": "R",
   "pygments_lexer": "r",
   "version": "3.4.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}