b2
发帖数: 427 | 1 var1 var2 date
1 missing 2010-1-1
1 missing 2010-1-2
1 a 2010-1-3
1 b 2010-1-4
above data is stored in work.test
code is
proc sql;
create table test2 as
select name from dictionary.columns where libname='work' and
memname='test';
quit;
why resulted test2 has no rows?
thanks |
s******r
发帖数: 1524 | 2 FAINT.
libname='WORK' and memname='TEST'
【在 b2 的大作中提到】
: var1 var2 date
: 1 missing 2010-1-1
: 1 missing 2010-1-2
: 1 a 2010-1-3
: 1 b 2010-1-4
: above data is stored in work.test
: code is
: proc sql;
: create table test2 as
: select name from dictionary.columns where libname='work' and
|
g*********n
发帖数: 441 | 3 可能是格式的问题或者数据的POSITION 的问题，你查一下TEST2 里包含哪些变量，然
后再调整吧。 |
b2
发帖数: 427 | 4 真丢人，谢谢！
【在 s******r 的大作中提到】
: FAINT.
: libname='WORK' and memname='TEST'
|
s******r
发帖数: 1524 | 5 sorry. I should be more patient.
【在 b2 的大作中提到】
: 真丢人，谢谢！
|
p*****o
发帖数: 543 | 6 but at least, the post and response make me laugh twice today...but not b/c
of the questions for sure( i didnt realize the problem either)....lol |
