Search Results

https://documentation.sas.com/doc/ja/pgmsascdc/v_061/proccas/n1v6aoomm10yxnn1mf4407trgk90.htm https://documentation.sas.com/doc/ja/pgmsascdc/v_061/lefunctionsref/n0l3n5z2h31h7wn1fmnqd33ibhap.htm

https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/p1da42svmyhzygn1r1f2uq10ntsh.htm

https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/n04ham6nlknk8ln17nuk76nue4vw.htm

https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/n109izonc0diazn0z2gy6wqehync.htm

データグリッド内の値を取得する DATAGRID_GET関数 DATAGRID_GET(データグリッド変数, '取得対象の列名', 取得対象の行番号) https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/n04ham6nlknk8ln17nuk76nue4vw.htm データグリッドに行を追加する DATAGRID_ADDROW関数 DATAGRID_ADDROW(データグリッド変数, <任意>追加する行数) 下記のように記述する...

table.loadTableアクション proc cas; session casauto; table.loadTable / sourceCaslib = "mylib" /* 左辺は caslib でも可 */ , path = "inputdata.sas7bdat" , casout = { caslib = "public" , name = "target_table_name" , replace = true }; run; qu...

table.promoteアクション proc cas; session casauto; table.promote / sourceCaslib = "mylib" /* 左辺は caslib でも可 */ , name = "table_name" , targetCaslib = "public" , target = "target_table_name" , quiet = false ; run; quit; https://documentation.sa...

URLENCODE関数 text = urlencode(input_text); https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n10igvbv55geofn1esixotiud7t9.htm

MDY関数 date_val = mdy(mm, dd, yy); https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n15zqld58pd186n1djkzia6oprza.htm

CAT関数（先頭・末尾の空白を削除しない） 先頭または末尾の空白を削除せずに、連結文字列を返す。 text = cat('aaa', 'bbb', 'ccc'); https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n0somj6dsx2dmkn1vqjabhvt6nv4.htm CATS関数（先頭・末尾の空白を削除する） 先頭と末尾の空白を削除して、連結文字列を返す。 text = cats('aaa', 'bbb', 'ccc'); ht...

LENGTH関数 val = length(str); ... https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n1lbye3jnh3aipn16jqqkbv4gnsg.htm

LOWCASE関数 str = lowcase('INTRODUCTION'); ... https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n0mwurvelifv54n18gbah5nmefn5.htm

SUBSTR関数 trimmed_str = substr(str, start_pos, length); ... https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/p0mce96o6y74fzn1ro3vtputzhut.htm

FIND関数 pos = find(string, substring); pos = find(string, substring, startpos); ... https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/n1v0tzf4xq363mn15mnppqtk2zti.htm

TRANWRD関数 str = tranwrd(inputstr, beforesubstr, after_substr); ... https://documentation.sas.com/doc/ja/pgmsascdc/v_061/ds2ref/p01iwnq51ps93bn1t9d1eztkx8go.htm

DATAGRID_COUNT関数 row_count = DATAGRID_COUNT関数(dataGrid); https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/p0wg7r5h8ayh0bn173vtjch62vql.htm

DATAGRID_MATCHCOUNT関数 row_count = DATAGRID_MATCHCOUNT(dataGrid, column_name, operator, match_value); /* 記述例 */ row_count = DATAGRID_MATCHCOUNT(dataGrid, 'is_complete_flg', '=', 'Y'); 使える演算子は以下。 Operator Description EQ, =, == 一致する NE, !=, ^=, <> 一致しな...

DATAGRID_CREATE関数 DATAGRID_CREATE(dataGrid, jsonString); /* 使用例 */ dcl package datagrid dg(); jsonString = '[{"metadata":[{"column_1":"string"}]},{"data":[["text1"], ["text2"]]}]'; DATAGRID_CREATE(dg, jsonString); https://go.documentation.sas.com/doc/jp/edmc...

DATAGRID_GRIDMATCHCOUNT関数 row_count = DATAGRID_GRIDMATCHCOUNT(dataGrid1, dataGrid2, column1, column2); row_count = DATAGRID_GRIDMATCHCOUNT(dataGrid1, dataGrid2, keyColumn); https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/n1j3q1ssilim7qn16y4q...

DATAGRID_ADDCOLUMN関数 DATAGRID_ADDCOLUMN(dataGrid, columnName, columnType); columnTypeに想定外の値が入っている場合、列の追加は行われない。 使える型名は以下。 boolean, bool, double, decimal, integer, int, long, string https://go.documentation.sas.com/doc/jp/edmcdc/v_056/edmdatagrids/n1djgke...