Wolan1995

Untitled

Mar 28th, 2018
308
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. PROC IMPORT OUT= ZADANIE2.KURSYdoEURO
  2.             DATAFILE= "H:\SAS\Pliki\Kursy_walut_2016.xls"
  3.             DBMS=EXCEL REPLACE;
  4.      RANGE="Kursy średnie$A1:I254";
  5.      GETNAMES=YES;
  6.      MIXED=NO;
  7.      SCANTEXT=YES;
  8.      USEDATE=YES;
  9.      SCANTIME=YES;
  10. RUN;
  11.  
  12.  
  13. proc import datafile="H:\SAS\pliki\dl.txt"
  14. out=zadanie2.lotek
  15. dbms=dlm replace;
  16. delimiter=' ';
  17. getnames=yes;
  18. DATAROW=2;
  19. run;
  20.  
  21. proc export data=zadanie2.BMI
  22. outtable="BMI"
  23. dbms = access replace;
  24. database="H:\SAS\pliki\BMI.mdb";
  25. run;
  26.  
  27. proc export data=zadanie2.BMI
  28. file="H:\SAS\pliki\PRACOWNICY.xls"
  29. dbms=xls replace;
  30. sheet="BMI";
  31. run;
  32.  
  33. data zadanie2.ziemniaki;
  34. set zadanie2.ziemniaki;
  35. rename var1=Data var2=Cena;
  36. run;
  37.  
  38. proc import datafile="H:\SAS\pliki\ziemniakiMiesiac.csv"
  39. out =zadanie2.ziem3
  40. dbms=csv
  41. replace;
  42. delimiter=';';
  43. getnames=no;
  44. run;
RAW Paste Data