통계프로그래밍
페이지 정보
작성일 19-06-08 00:07
본문
Download : 통계프로그래밍.hwp
통계프로그래밍 , 통계프로그래밍공학기술레포트 , 통계프로그래밍
통계프로그래밍,공학기술,레포트
레포트/공학기술
통계프로그래밍
설명
순서
통계패키지
1)
filename mydata dde `excel|sheet1!r1c1:r154c3`
data Foodwaste;
infile mydata firstobs=3 dlm=`09`x notab missover dsd
input Date Charge Use_kg ;
informat Date yymmdd10.
informat Charge comma. ;
Amount=int(Use_kg73) ;
retain Balance 0 ;
if Charge=. then Charge=0 ;
if Use_kg=. then Use_kg=0 ;
if Amount=. then Amount=0 ;
Balance+Charge-Amount ;
yy= year(Date) ;
mm=month(Date) ;
proc print data=Foodwaste (obs= 5);
var Date Charge Use_Kg Amount Balance ;
format Date yymmdd10.
format Change comma.
format Balance comma.
run
proc print data=Foodwaste (firstobs= 148);
var Date Charge Use_Kg Amount Balance ;
format Date yymmdd10.
format Change comma.
format Balance comma.
run
proc means sum mean
class yy ;
var Use_kg Amount ;
WHERE yy=2014 or yy=2015 ;
run
proc means sum mean
class yy mm;
var Use_kg Amount ;
WHERE yy^=2013 or mm^=2015 ;
run;
-
(로그)
NOTE: Copyright (c) 2002-xxxx by SAS Institute Inc., Cary, NC, USA.…(drop)
Download : 통계프로그래밍.hwp( 14 )
통계프로그래밍
다.
