DATA test; / / INPUT score DATALINES; ; PROC MEANS DATA=test; / DATA= / VAR sc

Size: px

Start display at page:

Download "DATA test; /** **/ INPUT score DATALINES; ; PROC MEANS DATA=test; /** DATA= **/ VAR sc"

しなつくまじ
7 years ago
Views:

2 DATA test; /** **/ INPUT score DATALINES; ; PROC MEANS DATA=test; /** DATA= **/ VAR score; /** **/ RUN ; MEANS : score N /* rankout */ PROC RANK DATA=test OUT=rankout DESCENDING; VAR score; RANKS score_rank; /* score_rank */ PROC PRINT DATA=rankout; /**/ score_ OBS score rank

4 ID 1 M F F M F F F F M F

5 PROC UNIVARIATE DATA=sales; VAR total; UNIVARIATE : total N E E H0: Mu0= p Student t t Pr > t <.0001 M Pr >= M <.0001 S Pr >= S <.0001 ( 5 ) 100% % % % % Q % % Q % % % % Obs Obs

6 PROC UNIVARIATE DATA=sales; CLASS sex; /*CLASSsex*/ VAR total; UNIVARIATE : total sex = F ( 5 ) 100% % % % % Q % % Q % % % % Obs Obs : total sex = M ( 5 ) 100% % % % % Q % % Q % % % % Obs Obs PROC UNIVARIATE DATA=sales; HISTOGRAM count / MIDPOINTS=0 TO 10; HISTOGRAM total / MIDPOINTS=0 TO BY 20000;

7 PROC UNIVARIATE DATA=sales; CLASS sex; HISTOGRAM total / MIDPOINTS=0 TO BY 20000; PROC SORT DATA=sales; /**/ BY sex; PROC BOXPLOT DATA=sales; PLOT total*sex;

8 PROC BOXPLOT DATA=sales; PLOT total*sex / BOXSTYLE=SCHEMATIC;

9 MOD(,) CALL DEFINE (column-id, 'attribute-name', value); ODS HTML BODY='c: sashtml report1.html'; PROC REPORT DATA=sashelp.class NOWD STYLE(HEADER)=[BACKGROUND=CX00ccff];NPUT a1 a2 b1 b2 x $ y $ z $; COLUMN name age sex height weight; COMPUTE age; count+1; /* */ IF MOD(count,2)=1 THEN DO; /* */ CALL DEFINE(_ROW_, "STYLE", "STYLE=[BACKGROUND=Aliceblue]"); END; ELSE DO; /* */ CALL DEFINE(_ROW_, "STYLE", "STYLE=[BACKGROUND=CXccffff]"); END; ENDCOMP; PROC IMPORT OUT= WORK.test DATAFILE="C: temp test.csv" DBMS=CSV REPLACE; GETNAMES=YES; DATAROW=2; GUESSINGROWS=200 ; /* 200 */

10 /** **/ DATA a; col1=1; col3=3; col5=5; x=123; /** **/ PROC SQL NOPRINT; SELECT TRIM(name) '=n_' TRIM(name) INTO:varlist separated by ' ' FROM sashelp.vcolumn WHERE libname = "WORK" and memname = "A" and UPCASE(name)? 'COL'; QUIT; /** **/ PROC DATASETS LIBRARY=work NOLIST; MODIFY a; RENAME &varlist; QUIT; /** **/ PROC CONTENTS DATA=a; col1=n_col1 col3=n_col3 col5=n_col5 WHERE ename="&macv" WHERE ename='&macv' %LET macv=allen; PROC SQL; CONNECT TO ORACLE(USER=xxx PASSWORD=xxx PATH="@xxx"); SELECT * FROM CONNECTION TO ORACLE ( SELECT COUNT(*) FROM emp WHERE ename=%str(%'&macv%') ); DISCONNECT FROM oracle; QUIT; COMPRESS(<source><, chars><, modifiers>)

11 source chars modifiers /* */ DATA sample ; INPUT data1 $CHAR15. ; DATALINES ; aaaaa bbbb /01/10 cc ; RUN ; DATA ext ; SET sample ; /* KD */ rc1 = COMPRESS(data1,,'KD') ; /* KF */ rc2 = COMPRESS(data1,,'KF') ; RUN ; PROC PRINT DATA=ext (KEEP=rc1 rc2) ; RUN ; OBS rc1 rc aaaa bbbb cc %LET execpath=" "; %MACRO setexecpath; %LET execpath=%sysfunc(getoption(sysin)); %IF %LENGTH(&execpath)=0 %THEN %LET execpath=%sysget(sas_execfilepath); %MEND setexecpath; %setexecpath; %PUT &execpath; + - * / < > = ^ ~ ;, blank AND OR NOT EQ NE LE LT GE GT ' " ( ) %LET text1 = %NRSTR(M & A) ; /**/ %LET text2 = M %NRSTR(&) A ; /* & */ %LET an = %NRSTR(&) ; /* & */ %LET text3 = M &an A ; /* */ %PUT text1=&text1 text2=&text2 text3=&text3 ; /* */

12 text1=m & A text2=m & A text3=m & A PROC IML; nobs=100; /** **/ seed=12345; /** **/ mean={ }; /** **/ cov={ , , }; /** **/ /** **/ CALL VNORMAL(rv,mean,cov,nobs,seed); /** SAS mnormal1 **/ CREATE mnormal1 FROM rv; APPEND FROM rv; QUIT; PROC IML; nobs=100; seed=12345; mean={ }; cov={ , , }; CALL RANDSEED(seed); /** **/ /** 1003**/ rvn=j(nobs,ncol(cov),.); CALL RANDGEN(rvn,'NORMAL'); /** **/ /** Choleskey ROOT **/ rv=mean#j(nobs,ncol(cov),1)+rvn*root(cov); /** SAS mnormal2 **/ CREATE mnormal2 FROM rv; APPEND FROM rv; QUIT; PROC IML; nobs=100; seed=12345; mean={ }; cov={ , , }; rv=mean#j(nobs,ncol(cov),1) + RANNOR(J(nobs,NCOL(cov),seed))*ROOT(cov); /** SAS mnormal3 **/ CREATE mnormal3 FROM rv; APPEND FROM rv; QUIT;

13 /** SAS **/ DATA mean1; _NAME_=""; INPUT a1-a3; DATALINES; ; /** SAS **/ DATA cov1; INPUT _NAME_$ col1-col3; DATALINES; col col col ; /** MODEL **/ PROC MODEL DATA=_NULL_ NOPRINT; PARMS a1 a2 a3; col1=a1; col2=a2; col3=a3; /** SOLVEESTDATA= SDATA= RANDOM=SEED=**/ /** SAS9.1PSEUDO=TWISTERMT PSEUDO=DEFAULT SAS8 **/ SOLVE col1-col3/estdata=mean1 SDATA=cov1 RANDOM=100 SEED=12345 PSEUDO=TWISTER OUT=mnormal4(WHERE=(_REP_^=0) DROP=_TYPE MODE ERRORS_); QUIT; %LET nobs=100; /** **/ %LET ncol=3;/** **/ %LET seed=12345; /** **/ %LET out=mnormal5; /** **/ /** SAS **/ /** **/ DATA cov2; INPUT col1-col3 mean; row+1; DATALINES; ; /** 1003 **/ /** RAND RANNOR **/ DATA _random; CALL STREAMINIT(&seed); _TYPE_="SCORE"; _MODEL_="col"; mean=1; ARRAY col{&ncol}; DO num=1 TO &nobs; DO i=1 TO DIM(col); col{i}=rand("normal"); END; output; END; DROP i; /** MIXEDCholesky **/ ODS LISTING CLOSE; ODS OUTPUT CHOLG=_Cholesky; PROC MIXED DATA=cov2; CLASS Row mean; PARMS /NOITER; MODEL mean=; RANDOM row*mean/type=un GDATA=cov2 GC; ODS LISTING; /** SCORE **/ PROC SCORE DATA=_cholesky SCORE=_random OUT=_out(KEEP=col num); BY num; VAR mean col:; PROC TRANSPOSE DATA=_out OUT=&out.(DROP=_NAME_); BY num;

DATA Sample1 /**/ INPUT Price /* */ DATALINES

3180, 3599, 3280, 2980, 3500, 3099, 3200, 2980, 3380, 3780, 3199, 2979, 3680, 2780, 2950, 3180, 3200, 3100, 3780, 3200 DATA Sample1 /**/ INPUT Price @@ /* @@1 */ DATALINES 3180 3599 3280 2980 3500 3099