m*******g
发帖数: 3044 | 1 我想把ACCESS里的表导到SAS里。我用SAS的自动import wizard function，可最后总是
显示文件不存在.
ERROR: File _IMEX_.ClaimsData.DATA does not exist.
ERROR: Import unsuccessful. See SAS Log for details. |
|
j*******2
发帖数: 309 | 2 I cannot import access2007 database from SAS import wizard. The menu only
shows MS2000/2002/2003 database. what should I do to fix the problem? Thanks
! |
|
p**5
发帖数: 2544 | 3 谁能看看这个error？谢谢
191
192 PROC IMPORT OUT= WORK.text
193 DATAFILE= "D:\Journal\2009_IF.xls"
194 DBMS=EXCEL REPLACE;
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
NOTE: The previous statement has been deleted.
195 GETNAMES=NO;
NOTE: The previous statement has been deleted.
196 DATAROW=5;
-------
180
ERROR 180-322: Statement is not valid or it is used out of pr... 阅读全帖 |
|
t********1
发帖数: 799 | 4 yes, .csv works, all cols can be imported into dataset.
one more question, in the .csv file there are two sheets, how can i point
out which sheet sas should import?
thank you. |
|
g******d
发帖数: 231 | 5 问题搞清楚了：
PROC IMPORT by default 只scan前20个record, 而我的source file中对应于问题
column的前20个record是空的，所以就读成了character。
于是我加了一个option "GUESSINGROW = 150;" 这样指令proc import 去scan前150行
，当中会遇到有效非空的record。就成了。 |
|
x**********0
发帖数: 163 | 6 I want to import multiple csv file
acc1990
acc1991
..
acc2010
I write a SAS macro like this
%MACRO importAcc (first=1990, last=2010);
%local year;
%do year=&first %to &last;
proc import datafile="C:\Users\acc&year..csv"
out=acc&year
dbms=csv
replace;
getnames=yes;
run;
%end;
%MEND importAcc;
%importAcc
But it is wrong and give back nothing, Can anybody help me with this? Thanks |
|
a*******g
发帖数: 80 | 7 I imported this data set before but after reinstalling sas 9.3, I ran the
same
codes and was returned with sas error:
ERROR: This DBMS table or view cannot be accessed by the SAS System because
it contains column
names that are not unique when a SAS normalized (uppercased) compare
is performed. See
"Naming Conventions" in the SAS/ACCESS documentation.
ERROR: Import unsuccessful. See SAS Log for details.
How can I solve it?
Thanks very much!! |
|
l**********8
发帖数: 305 | 8 请教各位， log这么报错，是为什么
342 PROC IMPORT OUT= WORK.lung
343
344 DATAFILE= "E:summer projectBaliketal.xlsx"
345
346 DBMS=EXCEL REPLACE ;
347
348 GETNAMES=YES;
349
350 MIXED=NO;
351
352 SCANTEXT=YES;
353
354 USEDATE=YES;
355
356 SCANTIME=YES;
357
358 RUN;
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement
另外问一下，我excel 有2页sheet， 是否能一次一次import |
|
a******g
发帖数: 116 | 9 filename in ftp 'newfile.csv'
host = 'hostname.com'
user = 'sasuser'
pass = 'passwd'
port = 11
debug;
proc import datafile = in out =ff dbms =csv replace;
run;
要求直接从server上读。
我是有哪里不对吗，每次都显示
error:invalid reply receieved from ftp server
error:import unsuccessful. see sas log for detail.
请大神帮忙看看。谢谢！ |
|
R***n
发帖数: 25 | 10 【 以下文字转载自 Soccer 讨论区,原文如下 】
发信人: raven (乌鸦嘴), 信区: Soccer
标 题: [转载] Important 通知
发信站: The unknown SPACE (Sun Dec 19 00:45:36 1999), WWW转贴
【 以下文字转载自 Sports 讨论区,原文如下 】
发信人: raven (乌鸦嘴), 信区: Sports
标 题: Important 通知
发信站: The unknown SPACE (Sun Dec 19 00:43:09 1999) WWW-POST
Hi, every buddy,
我乌鸦嘴作为跨千禧年的”人才“上任了，准备为了咱体育版在下个世纪的flourishing
陆续开展一系列的大小型活动，并准备restructure and re-design我版，以加强
众迷们的cohesion, 首次活动初步定于在12/20-12/25这周推出，(the chances are I will
post my announcement about 9:00 pm sometime next week |
|
p*********y
发帖数: 2741 | 11 Future Directions in the Racial Justice Movement
download:
http://www.changelabinfo.com/research-paper/the-importance-of-a
In our previous report, Left or Right of the Color Line, we explored what we
heard from nationwide interviews with racial justice leaders, organizers,
scholars, and artists about Asian Americans and the racial justice movement.
The vast majority of the 57 interviewees who ended up in our analysis were
Asian Americans, except for three African Americans whose work cuts across... 阅读全帖 |
|
|
|
|
w*******y
发帖数: 60932 | 15 Facebook offer for Pier 1 Imports Daily Deals for month of January
Save $10 off $40 purchase.....Offer expires on 1/22/12
Link:
http://www.pier1.com/DailyDealy/tabid/953/Default.aspx
Bring this offer to a Pier 1 Imports store and save $10 on your next
purchase of $40 or more. Offer does not apply to delivery or other service
charges. Offer does not apply to prior purchases and cannot be used on Gift
Card, UNICEF or other non-discountable merchandise purchases. Offer is not
valid in combination w... 阅读全帖 |
|
i**s
发帖数: 332 | 16 我刚刚开始学习python。教材给了一个sample code odbchelper.py,如果我把它下载到
C：,如果我需要import this program,如何import呢？ 是在code里指明路径（设定
library），还是需要把此sample code放到某个特定地方/library？
多谢指教！ |
|
|
a**t
发帖数: 3833 | 18 Chinese should import turkey and thanksgiving to replace pigs.
thanks should be given to chairman Mao. He liberated our Chinese people,
and he defeated the American imperialism. |
|
S*********4
发帖数: 5125 | 19 China Cuts Saudi Oil Imports - 兵者, 诡也
来源: 复兴儒学 于 2014-10-22 19:45:00 [档案] [旧帖] [给我悄悄话] 本文已被阅
读：1423 次 (979 bytes)
字体：调大/重置/调小 | 加入书签 | 打印 | 所有跟帖 | 加跟贴 | 当前最热讨论主题
中国在沙特阿拉伯调低原油价格的情况下, 不但没有增加从沙特的原油进口量, 反而进
一步减少从沙特的原油进口量. 与2013同期比, 沙特原油出口下降2.7%, 伴随美国日均
产油创新高, 沙特的愿油出口将持续下降. 同时, 中国大幅增加从哥伦比亚( 上升389%
), 俄罗撕(58%) 的原油进口量.
显然, 对于低油价, 中国乐见其成, 也作享其成. 我之前有个贴: 控制油价, 美国的一
把双刃剑. 降低从沙特进口, 对沙特形成一钟供, 需的压力,是否继续调地价格? 背后
就是对美国的压力. 对美国在中东的盟友, 沙特, 中国现在不需帮它买单. 沙特之前已
表明, 可已忍耐一段时期的低油价, 那就忍吧. 别蛮冤中国, 支持不住, 找美国算帐.
一石二鸟, 增加从南... 阅读全帖 |
|
a***m
发帖数: 5037 | 20 Donald J. Trump @realDonaldTrump 8m8 minutes ago
More
Getting ready to deliver a VERY IMPORTANT DECISION! 8:00 P.M. |
|
|
发帖数: 1 | 22 我想import data from a text file的时候skip several columns
我看了下可以skip one column
能不能一次skip more than one column |
|
|
w*********r
发帖数: 42116 | 24 WASHINGTON, Feb 6 (Reuters) - The U.S. trade deficit narrowed sharply in
November amid declines in imports of cellphones and petroleum products. |
|
发帖数: 1 | 25 【 以下文字转载自 USANews 讨论区 】
发信人: ThinkHarder (ThinkHarder), 信区: USANews
标 题: Trump, Trevor, Chuck Important Messages to American People
发信站: BBS 未名空间站 (Mon Mar 16 10:11:36 2020, 美东) |
|
g********d
发帖数: 4174 | 26 Posted on Advocate.com August 15, 2011 09:40:00 AM ET
The Most Important LGBT Group You’ve Never Heard Of
By Andrew Harmon
How to conduct an accurate count of the American population — an estimate
that controls congressional seat allocation and the disbursement of billions
in federal dollars to cash-strapped states and municipalities — is a
reliable flashpoint of controversy when the U.S. Census rolls around every
10 years.
What seems to have drawn little controversy in the release of the 2010
C... 阅读全帖 |
|
t*******n
发帖数: 25 | 27 http://www.politico.com/blogs/thecrypt/0808/Hillary_Palins_an_imortant_new_voice_in_debate.html
Hillary: Palin an 'important new voice'
Expecting Hillary Rodham Clinton to blast away at Sarah Palin, after the GOP
veep candidate made a direct appeal to Clinton's white, female base?
Not so much.
Her statement:
"We should all be proud of Gov. Sarah Palin's historic nomination, and I
congratulate her and Sen. McCain. While their policies would take America in
the wrong direction, Gov. Palin will add |
|
l****z
发帖数: 29846 | 28 On Tuesday, the battle for employee freedom won an important victory against
Big Labor's campaign to take over the Wisconsin State Senate.
And your National Right to Work Committee stood strong in the fight, making
sure the pro-forced unionism politicians couldn't hide their record of waste
and corruption.
As you know, Governor Scott Walker led a brave legislative effort to roll
back union-boss power over Wisconsin state workers, including repealing most
withholding of forced dues from paychecks... 阅读全帖 |
|
l****z
发帖数: 29846 | 29 Anatomy of a Victory: The Importance of MJ Rosenberg's Ousting from Media
Matters
By Jared Arluck
The anti-Israel echo chamber has always existed. For a while, this hateful
ideology resonated in the blogosphere louder than it should have. Not
anymore.
Renowned lawyer and Democrat Alan Dershowitz's insistence that Media Matters
distance itself from anti-Israel advocate MJ Rosenberg has worked.
Rosenberg, the controversial senior foreign policy fellow at Media Matters,
was unceremoniously jetti... 阅读全帖 |
|
l****z
发帖数: 29846 | 30 by Jammie
No wonder these douchebags in Washington are in such a hurry to ram through
anti-gun legislation. Have a look at the top four issues concerning
Americans and ask why these idiots are doing nothing about them, instead
distracting us with red herring issues.
Economy in general 24%
Unemployment/Jobs 18%
Dissatisfaction with Government 16%
Federal budget deficit/Federal debt 11%
Obama ... 阅读全帖 |
|
l***o
发帖数: 7937 | 31 牛！
有杀鸡儆猴之效！
Breaking News: President Trump has proposed a 20 percent tax on all Mexican
imports to pay for the border wall |
|
D**s
发帖数: 6361 | 32 墨西哥惨了……
[在 luobo (菠萝) 的大作中提到：]
:牛！
:有杀鸡儆猴之效！
:Breaking News: President Trump has proposed a 20 percent tax on all Mexican
imports to pay for the border wall |
|
t**x
发帖数: 20965 | 33 川普完蛋了
没有想到这么快
应该背后没有任何人支持, 否则不会这么傻逼
: 墨西哥惨了……
: [在 luobo (菠萝) 的大作中提到：]
: :牛！
: :有杀鸡儆猴之效！
: :Breaking News: President Trump has proposed a 20 percent tax on all
Mexican
: imports to pay for the border wall
|
|
b********n
发帖数: 38600 | 34 脑残
A 20% tax on imports from Mexico will not make Mexico pay for the wall. It
will make Americans pay for it.
Mexican |
|
a*******t
发帖数: 891 | 35 tires are probably the most important safty feature of a car. don't try to
save Too much by buying cheapest tires.
if cheapest tires perform badly and increases the car's braking distance, for
example by merely 10 ft, and it causes accident, the $ saved on buying 4
cheapest tires will be spent on fixing the car body, plus many times more. |
|
c*******7
发帖数: 2506 | 36 You cannot even declare the car as goods to follow if don't have a title. If
you don't have a title it is not your car. You cannot import or declare in
goods to follow. Sorry about the bad news.
May be you can try whether you can get another type of loan or cash advance
that can pay off your car loan so that you can get the title. |
|
c**i
发帖数: 6973 | 37 Angus Loten, Small Firms Find Cash Lifeline in China; After Halting
Production, California RV Maker Gets Jump-Start From Big Investor Far From
Home. Wall Street Journal, Mar 1, 2011.
http://online.wsj.com/article/SB10001424052
748704615504576172410117309984.html
Quote:
"Talks with the Chinese electric-car company he'd gone to meet collapsed,
but Mr. Williams was introduced to Winston Chung, whose company, Winston
Global Energy, makes batteries for electric vehicles.
"Over the course of several m... 阅读全帖 |
|
N*****e
发帖数: 2573 | 38 Dealer说？那你现在查carfax 了吗
value
imports |
|
发帖数: 1 | 39 你转发那个douban链接，那个女的也够极品，把车撞了再去退，还要退全款
value
imports |
|
y*******4
发帖数: 3837 | 40 二手交易风险自负！请自行验证是否合法和一手卡！:
我想卖的物品:
Pier 1 Imports $625 @0.81 w/FREE shipping
单张面值:
25x25
可接受价格(必须明码标价！):
0.81
物品新旧要求:
new
邮寄方式要求:
free code or u choose u pay
free shipping if u take all
买卖双方谁承担邮寄损失(Required if not code only):
b4 delivery me, after u
付款方式说明:
boa
non-cc paypal for old ID
其他补充说明:
广告的有效期:
till gone
物品来源(Required for All Cards!):
dp
我的联系方式:
bbs mail
Warranty期限:
3 months
能否证明是合法的一手卡?(Required for All Cards!):
yes |
|
s***k
发帖数: 769 | 41 我想要的物品:
Pier 1 imports GC $400
单张面值:
$25 or more
可接受的价格(必须明码标价！):
0.81
物品新旧要求:
new
邮寄方式要求:
$2.5 for FC+DC
买卖双方谁承担邮寄损失(Required if not code only):
before u after me
付款方式说明:
non-cc paypal
广告的有效期:
till got
物品来源:
legal
我的联系方式:
站内 |
|
j**********t
发帖数: 57 | 42 二手交易风险自负！请自行验证是否合法和一手卡！:
y
我想卖的物品:
Pier 1 Imports up to $250,
Bath and Body Works up to $150
单张面值:
25
可接受价格(必须明码标价！):
0.80+shipping
物品新旧要求:
new
邮寄方式要求:
YCYP
买卖双方谁承担邮寄损失(Required if not code only):
before delivery, seller; after delivery, buyer
付款方式说明:
noncc paypal
其他补充说明:
自用之余出售闲置卡
广告的有效期:
Till gone
物品来源(Required for All Cards!):
DP
我的联系方式:
mitbbs
Warranty期限:
能否证明是合法的一手卡?(Required for All Cards!):
yes |
|
F*******o
发帖数: 4216 | 43 我想要的物品:
Pier 1 Imports $1000 at 0.82
单张面值:
any
可接受的价格(必须明码标价！):
0.82
物品新旧要求:
new in hand
邮寄方式要求:
I choose I pay
买卖双方谁承担邮寄损失(Required if not code only):
default
付款方式说明:
BOA or billpay
其他补充说明:
广告的有效期:
物品来源:
正规合法来源！
我的联系方式:
bbs
二手交易风险自负！请自行验证是否合法和一手卡！:
y |
|
l********e
发帖数: 54 | 44 我想要的物品:
Pier 1 Imports $150 at 0.82
单张面值:
any
可接受的价格(必须明码标价！):
0.82
物品新旧要求:
new in hand
邮寄方式要求:
I choose I pay
买卖双方谁承担邮寄损失(Required if not code only):
default
付款方式说明:
BOA or paypal
其他补充说明:
广告的有效期:
till i got
物品来源:
正规合法来源！
我的联系方式:
bbs
二手交易风险自负！请自行验证是否合法和一手卡！:
y |
|
y*****u
发帖数: 4807 | 45 我想要的物品:
pier1 imports 20% coupon
单张面值:
可接受的价格(必须明码标价！):
20个包子/2刀
物品新旧要求:
邮寄方式要求:
买卖双方谁承担邮寄损失(Required if not code only):
付款方式说明:
其他补充说明:
广告的有效期:
物品来源:
我的联系方式:
二手交易风险自负！请自行验证是否合法和一手卡！: |
|
r***h
发帖数: 100 | 46 二手交易风险自负！请自行验证是否合法和一手卡！:
我想卖的物品:
.75 rate Pier 1 Imports gift cards 2x$25
单张面值:
25 一张， 有两张
可接受价格(必须明码标价！):
75 折，
物品新旧要求:
邮寄方式要求:
you choose you pay
买卖双方谁承担邮寄损失(Required if not code only):
付款方式说明:
non cc paypal
其他补充说明:
广告的有效期:
物品来源(Required for All Cards!):
我的联系方式:
bbs mail
Warranty期限:
能否证明是合法的一手卡?(Required for All Cards!):
yes
state and zip: |
|
M********9
发帖数: 705 | 47 我想要的物品:
pier 1 import gift card 300
单张面值:
25 or more
可接受的价格(必须明码标价！):
0.82
物品新旧要求:
邮寄方式要求:
code only, can be used online
买卖双方谁承担邮寄损失(Required if not code only):
付款方式说明:
PayPal or boa or bill pay
其他补充说明:
广告的有效期:
物品来源:
legal
我的联系方式:
二手交易风险自负！请自行验证是否合法和一手卡！: |
|
c*****n
发帖数: 4880 | 48 target的也有啊
Additional InformationDPCI: 207-00-1000
ASIN: B002BSA298
Catalog #: 12768571
Item can be gift wrapped.
Made in the USA or Imported |
|
m*****i
发帖数: 2676 | 49 这么讲ipad都是imported from China呢 |
|
j****l
发帖数: 1352 | 50 FBA退货。病人直接说unwanted item. 可是还是不需要出运费和import fee。这是什么
道理? |
|
