由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - 请教SAS问题!
相关主题
Urgent help needed, please请教mssql一个问题, 关于add extended properties only to float field
Debugging in SQLPLUS, need helpSQL multiply all values of a column in table (转载)
Oracle questionNeed help with an oracle SQL expression
how to get all numerical data?求教mysql数据库构建
请教2个sql query 问题哪个软件可以支持2500个FIELDS?
in db2怎样得到一个数的整数部分Help!
用SSIS传table从oracle到mssql,遇到一个奇怪的问题mysql 又一问
int or varchar?ADO & DAO &SQL...Help...
相关话题的讨论汇总
话题: type话题: sas话题: key话题: fields话题: numeric
进入Database版参与讨论
1 (共1页)
f*******6
发帖数: 4
1
希望各位SAS 的牛人,帮忙解决下列SAS的问题。万分感谢!!!
1.
a) There is a large file with an ID-Key field and a TYPE field. Both fields
are characters. Also, there are extra fields in addition to those two.
The extra fields are all numeric. The content of the TYPE field is such
that each record contains the name of one and only one of those extra
numeric fields.
You are asked to do the following:
For each record, only output the ID-Key, TYPE and the numeric field that
bears the name of the content of the TYPE reco
f**y
发帖数: 138
2
Your question is too long, here is the first point:
data A(keep=ID_Key type A) B(keep=ID_Key type B);
set input;
if type = 'A' then output A;
else if type = 'B' then output B;
run;
1 (共1页)
进入Database版参与讨论
相关主题
ADO & DAO &SQL...Help...请教2个sql query 问题
求教...初级问题in db2怎样得到一个数的整数部分
Which software do you use for data modeling?用SSIS传table从oracle到mssql,遇到一个奇怪的问题
how to particially delete record in sql server --- there is no field for autonumberint or varchar?
Urgent help needed, please请教mssql一个问题, 关于add extended properties only to float field
Debugging in SQLPLUS, need helpSQL multiply all values of a column in table (转载)
Oracle questionNeed help with an oracle SQL expression
how to get all numerical data?求教mysql数据库构建
相关话题的讨论汇总
话题: type话题: sas话题: key话题: fields话题: numeric