99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

熱線電話:13121318867

登錄
首頁(yè)精彩閱讀SAS-一些有用的語(yǔ)句
SAS-一些有用的語(yǔ)句
2017-06-21
收藏

SAS-一些有用的語(yǔ)句

今天本想繼續(xù)介紹 summary過程的,但是發(fā)現(xiàn)別人整理的比我更好,于是周末再更,好好整理一下描述性統(tǒng)計(jì)分析及評(píng)分卡建模,今天給大家介紹一些sas有用的語(yǔ)句吧。

1.如果在同一程序中需要多次調(diào)用print語(yǔ)句,用%str可以節(jié)省程序書寫;

%let print=%str(proc print data=sashelp.class;run;);

&print;

2.查看變量類型;

data a;

  set sashelp.class;

  w=vtype(age);

run;

3.結(jié)構(gòu)查詢語(yǔ)言;

 select語(yǔ)句用來檢索數(shù)據(jù)(order從句,format選項(xiàng)) ;

create語(yǔ)句創(chuàng)建表格;

update語(yǔ)句增加或修改表格中列的數(shù)值(insert和delete語(yǔ)句插入和刪除行,用alter語(yǔ)句增加、修改、刪去列)

例子:

data employee;

  input empname $ empcity $ empyears emptitle $ sales;

  cards;

aa   beijing   3   engineer 2300

bb   shangqiu  2   teacher  3000

cc   changsha  32  worker   4000

dd   changsha  20  salesrep 1000

;

proc sql;

  create table changsha as   /*對(duì)表格的操作*/

  select empname,

         empcity,

         empyears format=yymmdd8.,/*對(duì)表格列的操作*/

         sales*2 as totalsales,

         /*count(empyears) as count_emp,*//*計(jì)算by排序文件的觀測(cè)數(shù)、均值(avg)*/

         /*10*(sales-empyears) as total,*//*有效的表達(dá)式*/

         emptitle

  from employee

  where empcity='changsha'

  order by empyears asc;  /*asc升序,desc降序*/

  alter table changsha add gender char(1);/*對(duì)表格列的操作,添加性別變量,相似modify,drop*/

  update changsha/*對(duì)表格值的操作:賦值*/

     set gender='f'

     where empname in ('aa','cc');

  update changsha

     set gender='m'

     where gender is missing;

  insert into changsha    /*對(duì)表格行的操作,插入一條觀測(cè)*/

     values('ff', 'changsha',10, 8000,'teacher','m');

  delete from changsha    /*對(duì)表格行的操作*/

    where empyears>20;

quit;

proc print data=changsha;

run;

4.計(jì)算行數(shù);

%let dsid=%sysfunc(open(sashelp.class,i));  

%let n=%sysfunc(attrn(&dsid,nobs));

%let rc=%sysfunc(close(&dsid));

%put obsnum=&n;

 5.scan()用法:

data a;

  arg='ABC.DEF(X=Y)';

  word=scan(arg,-3);

/*put word;*/

run;

data c;

arg='ABC.DEF(X=Y)';

word=scan(arg,-20);

put word;

run;

data d;

input Arr $ & 22.;

ArrivalGate=scan(Arr,1,' ');

DepartureGate = scan(Arr,2,' ');

put  DepartureGate  ArrivalGate arr;

cards;

Arrival DepartureGates

;

run;

6.sysfunc()用法;

data a;

input group $ number point;

cards;

A 1 85

A 2 66

B 1 69

C 3 55

D 4 24

;

run;


%macro macro_name(group,number,point);

data out_&group.;

group="&group";

number=&number.;

point=&point.;

run;

%mend;


%macro test;

*打開存放參數(shù)的數(shù)據(jù)集;

%let dsid=%sysfunc(open(work.a,i));

%put &dsid;        *%put是在日志輸出改宏變量的值;

*fetch是為了判斷是否讀取完數(shù)據(jù)集記錄,若已讀完,則返回-1,否則返回0,賦給宏變量rc;

%let rc=%sysfunc(fetch(&dsid));

        %do %while(&rc=0);

            *trim是去掉字符右邊的空格,left是去掉字符左邊的空格,getvarc(&dsid,1)是讀取數(shù)據(jù)集的第一列,

                讀取第二列則為getvarc(&dsid,2),getvarc是針對(duì)字符,若該列是數(shù)值型的則為getvarn(&dsid,2);

                %let group=%sysfunc(trim(%sysfunc(left(%sysfunc(getvarc(&dsid,1))))));

                %let number=%sysfunc(trim(%sysfunc(left(%sysfunc(getvarn(&dsid,2))))));

                %let point=%sysfunc(trim(%sysfunc(left(%sysfunc(getvarn(&dsid,3))))));

                %put &group;     %put &number;     %put &point;


                %macro_name(&group,&number,&point);*將參數(shù)傳給調(diào)用你所需要運(yùn)行的宏macro_name;


                %let rc=%sysfunc(fetch(&dsid));        *同上fetch;

                %put &rc;

        %end;

                %let rc=%sysfunc(close(&dsid));        *關(guān)閉數(shù)據(jù)集;

                %put &rc;

%mend;


%test;

數(shù)據(jù)分析咨詢請(qǐng)掃描二維碼

若不方便掃碼,搜微信號(hào):CDAshujufenxi

數(shù)據(jù)分析師資訊
更多

OK
客服在線
立即咨詢
客服在線
立即咨詢
') } function initGt() { var handler = function (captchaObj) { captchaObj.appendTo('#captcha'); captchaObj.onReady(function () { $("#wait").hide(); }).onSuccess(function(){ $('.getcheckcode').removeClass('dis'); $('.getcheckcode').trigger('click'); }); window.captchaObj = captchaObj; }; $('#captcha').show(); $.ajax({ url: "/login/gtstart?t=" + (new Date()).getTime(), // 加隨機(jī)數(shù)防止緩存 type: "get", dataType: "json", success: function (data) { $('#text').hide(); $('#wait').show(); // 調(diào)用 initGeetest 進(jìn)行初始化 // 參數(shù)1:配置參數(shù) // 參數(shù)2:回調(diào),回調(diào)的第一個(gè)參數(shù)驗(yàn)證碼對(duì)象,之后可以使用它調(diào)用相應(yīng)的接口 initGeetest({ // 以下 4 個(gè)配置參數(shù)為必須,不能缺少 gt: data.gt, challenge: data.challenge, offline: !data.success, // 表示用戶后臺(tái)檢測(cè)極驗(yàn)服務(wù)器是否宕機(jī) new_captcha: data.new_captcha, // 用于宕機(jī)時(shí)表示是新驗(yàn)證碼的宕機(jī) product: "float", // 產(chǎn)品形式,包括:float,popup width: "280px", https: true // 更多配置參數(shù)說明請(qǐng)參見:http://docs.geetest.com/install/client/web-front/ }, handler); } }); } function codeCutdown() { if(_wait == 0){ //倒計(jì)時(shí)完成 $(".getcheckcode").removeClass('dis').html("重新獲取"); }else{ $(".getcheckcode").addClass('dis').html("重新獲取("+_wait+"s)"); _wait--; setTimeout(function () { codeCutdown(); },1000); } } function inputValidate(ele,telInput) { var oInput = ele; var inputVal = oInput.val(); var oType = ele.attr('data-type'); var oEtag = $('#etag').val(); var oErr = oInput.closest('.form_box').next('.err_txt'); var empTxt = '請(qǐng)輸入'+oInput.attr('placeholder')+'!'; var errTxt = '請(qǐng)輸入正確的'+oInput.attr('placeholder')+'!'; var pattern; if(inputVal==""){ if(!telInput){ errFun(oErr,empTxt); } return false; }else { switch (oType){ case 'login_mobile': pattern = /^1[3456789]\d{9}$/; if(inputVal.length==11) { $.ajax({ url: '/login/checkmobile', type: "post", dataType: "json", data: { mobile: inputVal, etag: oEtag, page_ur: window.location.href, page_referer: document.referrer }, success: function (data) { } }); } break; case 'login_yzm': pattern = /^\d{6}$/; break; } if(oType=='login_mobile'){ } if(!!validateFun(pattern,inputVal)){ errFun(oErr,'') if(telInput){ $('.getcheckcode').removeClass('dis'); } }else { if(!telInput) { errFun(oErr, errTxt); }else { $('.getcheckcode').addClass('dis'); } return false; } } return true; } function errFun(obj,msg) { obj.html(msg); if(msg==''){ $('.login_submit').removeClass('dis'); }else { $('.login_submit').addClass('dis'); } } function validateFun(pat,val) { return pat.test(val); }