matlab数据字典怎么用,求教,如何使用数据字典功能

data MainTable; /* main table */

input ID City_Code District_code Admin_code;

datalines;

1001 100 101 10020

1002 200 102 20031

1003 300 103 30022

1005 500 104 50010

; run;

data Admin; /* lookup table for admin name */

input Admin_code AdminName $15.;

datalines;

10020 AdminName1

20031 AdminName2

30022 AdminName3

40031 AdminName4

50010 AdminName5

; run;

Data City;  /* lookup table for city */

input City_code CityName $15.;

datalines;

100 CityName1

200 CityName2

300 CityName3

400 CityName4

500 CityName5

; run;

/* Create a format table for admin */

data Admin_fmt (rename=(admin_code=Start AdminName=label));

set Admin;

retain fmtname 'Admin' type 'n';

run;

/* create a format table for city */

Data city_fmt (rename=(city_code=start cityName=label));

set City;

retain fmtname 'City' type 'n';

run;

/* create the formats for City and Admin */

proc format lib = work Cntlin = admin_fmt; run;

proc format lib = work cntlin = city_fmt; run;

/* display the results */

proc sql;

select ID, City_code as City format=city., admin_code as Admin format=admin.

from maintable;

quit;

data MainTable_with_name (rename=(City_code = City Admin_code = Admin));

set MainTable;

format city_code city.;

format admin_code admin.;

run;

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值