/* 2017.02.06
   1. gyakorlat - SAS
   SZTE, Statisztika gyakorlati alkalmazasai
*/

/* 
SAS profil letrehozasa: https://odamid.oda.sas.com/SASODARegistration/
SAS Studio elerese online: https://odamid.oda.sas.com/SASStudio/
*/

/* SAS kod sablonok a Snippets-ben. Peldaul: */
/** Data / Import XLSX file.  **/
PROC IMPORT DATAFILE="<Your XLSX File>"
		    OUT=WORK.MYEXCEL
		    DBMS=XLSX
		    REPLACE;
RUN;
/** Print the results. **/
PROC PRINT DATA=WORK.MYEXCEL; RUN;
/* Graph / Bar panel - oszlopdiagram */
title 'Mileage by Origin and Type';
proc sgpanel data=sashelp.cars(where=(type in ('Sedan' 'Sports'))) noautolegend;
  panelby Type / novarname columns=2 onepanel;
  vbar origin / response=mpg_city stat=mean group=origin;
  rowaxis grid;
  run;

/* Sajat kod irasa, nem template-bol */
/* Adatallomany tartalmanak megismerese */
proc contents data=maps.hungary;
run;
/* Adatok levalogatasa es kulon adatallomanyba mentese 
Az ideiglenes WORK konyvtarba mentjuk, nem_to neven,
csak azokat a sorokat, ahol a lake valtozo
ne = "not equal"  1 */
data work.nem_to;
 set maps.hungary;
 if lake ne 1 then output;
run;
/* Libraries-ben sajat konyvtar beallitasa: 
My Libraries --> New: 
    Name: sajat_nev
    Path: /home/usernev  --> usernev: amivel a SAS studio-ba beleptunk
   majd ebbe a konyvtarba a HUNGARY adatallomany atmasolasa */
data la17.nem_to;
 set maps.hungary;
 if lake ne 1 then output;
run;