t**********h 发帖数: 100 | 1 How to create macro variable in xls file? I mean it automatically update xls
file to today’s date or this current such as:
proc export data = files
outfile = "c\filename&week.xls" dbms = xls replace ;
run;
thanks. |
|
w*******y 发帖数: 60932 | 2 Crown XL 5000 rackmount stereo amplifier for $534 shipped!
This is a barn burner price. I see this amp most places for $1k. Crown is
a well recognized and high quality manufactorer. 3 year full warranty.
This amp actually sells on ebay used for more than this new price in in all
of the most recent sales. I don't know that's it's worth flipping because
it weighs 73 pounds and by the time you pay shipping and fees you wouldn't
turn a profit - but it's nice to know you can buy something new for... 阅读全帖 |
|
l*****k 发帖数: 587 | 3 I am setting up an access db by linking multiple xls files to
access table. However, some xls files linked fine, while some
having trouble to show numbers, all number files appears as "#Num!"
in access..
all my files are perl generated .csv files, I transformed them to
xls format... all files are done the same way... I don't know why
some works while some others won't...
Thanks for your help. |
|
s*****r 发帖数: 293 | 4 看版上很多人推荐outlander,上周去开了试试。outlander 2010 XLS 4wd, dealer还有
好多GT的,但XLS不多了。看来销量下滑了不少。有个第三排座,可以完全放下的那种
,可以应急用。 颜色是silver的比白色的好看一点。内车空间感觉不大,但长,有点
高度不够。内饰一般,不比CRV,RAV4的base model的好。3.0 V6 engine, 加速不错。
有switch,可以选择2WD,4WD,AWD。这个还是应有用的,应该比CRV,RAV4的假四驱好点
,不知道能不能算上真四驱。驾驶和悬挂都有点硬,不如CRV和RAV4舒服一点,如果主
要上下班用的话,可能有利于off road.随便问了下价格,otd 给了25,000+。就去看
别的车了。 |
|
y********2 发帖数: 4 | 5 从版主的xls表格可以看出,RD在2014年1月到5月的共有204条(也就是去年从EB2降级
到EB3的)。从4月的inventory来看,这部分约是2000人,所以大约估计本版的报绿率
为10%左右。
xls表格上本财年共有约380条报绿,说明现在EB2C已经批了3800人(??)
如果都成立的话:
RD在2014年1月到5月,共2000人,1700人绿了,还有300没绿。
RD在2015年3,4月的, 共600人,其中360人绿了,240没绿
RD在2015年5月的,共800人,其中160人已绿。
请大家轻拍。。。 |
|
c*****z 发帖数: 183 | 6 2000 Toyota Avalon XLS- $5,800 (Shadyside)
I have for sale 2000 Toyota Avalon XLS Sedan. The vehicle has about 117,500
miles, but in good condition. It has leather seats, dual power seats, Sun
Roof, dark green color, 4 speed automatic, Auto-locking doors, 18.5 gal.
fuel tank capacity, power windows, power door locks, dual airbags, side
airbags, etc.
KBB value is Excellent $7,755
Very Good $7,430
Good $7,255
Fair $6,405
If anyone is in... 阅读全帖 |
|
|
n********6 发帖数: 1511 | 8 Environment: Win2003, SQL2005,
Process: Load .xls by using SSIS Wizard (DB->Task->Import Data)
.xls File Structure: (col1, col2, ..., col8, col9)
Columns: col8:numbers; col9: numbers
First Line: xx, xx,... xx, xx (to set col8, col9 character)
Loading result:col1, col2, ... col8 (nvarchar), col9(float)
Question: Why col8 nvarchar while col9 float?
Thank you. |
|
r****y 发帖数: 26819 | 9 just paste intoVB editor and run it.
Sub ExtractFlash()
Dim tmpFileName As String
Dim FileNumber As Integer
Dim myFileId As Long
Dim MyFileLen As Long
Dim myIndex As Long
Dim swfFileLen As Long
Dim i As Long
Dim swfArr() As Byte
Dim myArr() As Byte
tmpFileName = Application.GetOpenFilename("MS Office File (*.doc;*.xls), *.
doc;*.xls", , "Open MS Office file")
If tmpFileName = "False" Then Exit Sub
myFileId = FreeFile
Open tmpFileName For Binary As #myFileId
MyFileLen = LOF(myFileId)
ReDim myArr( |
|
|
b*****t 发帖数: 9671 | 11 价格很低啊,小心不是骗子就是有问题的
不过ms explorer没有xls吧?你是不是把escape记错成explorer了? |
|
|
n*1 发帖数: 156 | 13 I want to buy Ford Escape XLS(FWD), How much is reasonable for OTD in GA?
Brothers who bought this SUV in GA or other states, please give some
information as reference. Thanks. |
|
B********r 发帖数: 2317 | 14 2010 outlander XLS FWD
dealer给的OTD是22,946
他家网上标的价格是27,038
没有什么package
要不要出手? |
|
B********r 发帖数: 2317 | 15 还有一辆也是XLS 2WD,不过是号称fully loaded,加了sun & sound 和luxury 两个
package
这个要26600,不知道是应该上这个还是上没有什么option的 |
|
R*****h 发帖数: 194 | 16 税前多少?如果v6 xls fwd OTD 22946能拿下很不错了。。。 |
|
B********r 发帖数: 2317 | 17 税前21k多吧
其实还有一个是卖22600左右,v6 xls fwd OTD,什么其他的option都没有 |
|
y*******s 发帖数: 267 | 18 试开了一款车。
2006 Ford Escape XLS, 2.3 L V4 engine.
Local 开挺顺的,40 mph 没问题;
但是到高速就比较不爽,猛踩油门才升到60mph,
如果不加油,一会儿就掉到40 mph。同上原因,
根本没开到70 mph过。
而且猛踩油门的时候,发动机转速也不会上到2000 rpm以上。
这是什么问题?因为车型本来就这样,还是因为这个车的engine可能有些故障? |
|
l********7 发帖数: 1077 | 19 2007 Escape XLS 基本款,fwd manual 78000miles。
dealer的价格是7500刀,我查了carfax,1 owner,没有任何车问题。除了“Loan or
lien reported”,不是clean title?
这个价格是不是低了点?会不会是斯scam?
新手买第一辆车,有些疑神疑鬼。
谢谢! |
|
r*********1 发帖数: 69 | 20 学生买二手车
求鉴定 2004年 8万mile ford explorer XLS 2wd 4.0L V6
carfax很clean, 没有任何不良记录。
$7600靠谱么? KBB上的价钱很低啊,只有$5500左右
差不多什么价钱合适?
谢谢 |
|
m*******f 发帖数: 6 | 21 2003 Ford Explorer XLS 4D for sale by owner.
Navy, 4 Door, 4 Wheel Drive, Automatic w/overdrive Transmission, Alloy
Wheels, Running Boards, Towing Package, Air Conditioning, Cruise Control,
Power Door Locks, Power Mirrors, Power Steering, Power Windows, Rear Air
Conditioning, Rear Defrost, Tilt Steering, Tinted Windows, AM/FM Radio, Anti
-theft, CD Player, Antilock Brakes, Driver Air Bag, Passenger Air Bag.
mileage 80000. Never been in accident. Great condition. Never had major
problems. Well ma |
|
j*********o 发帖数: 7 | 22 2002 Ford Escape XLS
No accidents, clean title. Good maintenance, excellent condition.
Mileage 164,600
Engine: V6 Dohc 24-valve
Transmission: Automatic
Exterior Color: Green
Interior Color: Gray
Ask for : $2800
Please contact: j*********[email protected] or call 612-245-9900 for more
information and schedule for testing drive
Pictures Link: http://www.flickr.com/photos/56468895@N06/ |
|
s*******0 发帖数: 47 | 23 1998 Toyota Avalon XLS for sale. 145K miles, very good condition. black
exterior and black leather interior. Very good condition. Very good gas
mileage, 20 local and 30 highway. Timing belt changed at 90K. KBB value:
$4,200, Ask for $3,200. If interested, please mail s*******[email protected]
* Air Conditioning
* Tilt Wheel
* Dual Air Bags
* Power Steering
* Cruise Control
* ABS (4-Wheel)
* Power Windows
* AM/FM Stereo
* Dual Power Seats
* Power Door Locks
* CD (Single Disc)
* Alloy Wheels
* Dual heat... 阅读全帖 |
|
v***s 发帖数: 4031 | 24 XLS 金色的杆子,确实很好用,我几乎不需适应,第一次挥起来就很顺。 |
|
|
o****n 发帖数: 9475 | 26 想买辆大点的车,现在有辆sedan,拉大点的东西特不方便,每次都要租车,第二辆车
就想买后排座放到能装下比较大的东西的那种
另外想要6缸,4缸车稍微有点坡就很费劲,最好7人座;不喜欢Van,大多数7人座的貌
似都是Van。看到Mitsubishi Outlander XLS,符合我的基本要求,再贵就买不起了
第一辆旧车是Galant,开了三年多,除了胎扎破过几次,没给过我任何大麻烦,隔段时
间换个油就可以了,所以对三菱的影响还不错。旧车后保险杠起皮掉漆,据说三菱的车
好几款有这个问题
懂车的说说这款车有什么优缺点 |
|
t******g 发帖数: 10390 | 27 如果只是doc,xls,可以不可以试试转换成html网页.
如果还有别的文件,估计要复杂一些,
可以去跟一些软件下载网站学学. |
|
h****e 发帖数: 204 | 28 it is a normal bug? of excel
when u convert .csv to .xls, excel will treat any number data or number
related data (say, "124E30", excel 自作主张的认为这是科学技术法 //DD)
as number type, so when the "123E30" goto your access table, it is out
of range, which will be displayed as #num!
well, for me, i'll write a small program to process the csv2xls myself
set the FieldFormat property (or sth. like this) to "Text", instead of
the default value "General", expecially for those string fields. then
everything should |
|
l******y 发帖数: 60 | 29 大牛们,有没有可以import txt或 xls的sql命令?table 已经建好,但不用sqlloader
,也不用toad中的import功能,就是sql 命令,写入script可以直接运行的?
就像SAS 中的
data XXX
infile '.....a.txt'...
或者把文件中的内容直接输入,类似SAS中的 dataline.....,但不要一行一行地
insert
多谢啦 |
|
w*********r 发帖数: 488 | 30 有没有什么library有写好的function直接用来从EXCEL里面引进xls格式的数据呢?
本人超级初学者一名,各位大侠多指教啦~~~~~ 三伏天捂貂皮大衣略表谢意。 |
|
p***o 发帖数: 1252 | 31 Simplest way: save xls as .csv, read by scanf |
|
q**j 发帖数: 10612 | 32 有个.xls table,请问如何快速地把it变成latex里面的一个table?多谢了。 |
|
c****g 发帖数: 156 | 33 DATA _NULL_;
call symput ('today', compbl(put(today(), date9.)));
run;
proc export data = files
outfile = "c:\filename&today." dbms = xls replace ;
run; |
|
P****D 发帖数: 11146 | 34 proc export data = files
outfile = "c:\filename&sysdate9." dbms = xls replace ;
run;
Don't need any DATA step before it. |
|
|
|
v**********m 发帖数: 5516 | 37 http://urre.client.shareholder.com/sec.cfm
please look at these files for more information.
Aggressive insider buying.
8-K current report Apr 11, 2012 24.9 KB View HTML View PDF
View XLS
8-K current report Apr 4, 2012 37.5 KB View HTML View PDF
View XLS
4 lueras, mathew f Apr 3, 2012 26.7 KB View HTML View PDF
View XLS
4 van, horn richard a Apr 3, 2012 25.6 KB View HTML View PDF
View XLS
4 ewigleben, donald c... 阅读全帖 |
|
j*****n 发帖数: 1781 | 38 ☆─────────────────────────────────────☆
Danglegedang (当了个当) 于 (Fri Aug 27 00:14:17 2010, 美东) 提到:
从网上找的图,觉得白色的最好看啊,试开后觉得从各方面都比rav4和crv强强啊。为
啥开人的这么少。
☆─────────────────────────────────────☆
gjg (工具钢) 于 (Fri Aug 27 00:20:18 2010, 美东) 提到:
outlander好讲价吗?税前价格和invoice比一般是什么情况?+/-?
☆─────────────────────────────────────☆
pcher (PCHER) 于 (Fri Aug 27 00:45:06 2010, 美东) 提到:
2010 Mitsubishi Outlander Special
Purchase For
MSRP $ 21,590.00
Capitol Mitsubishi Disc. ... 阅读全帖 |
|
d****n 发帖数: 397 | 39 AutoCheck.com
Your AutoCheck Vehicle History Report
2003 Mitsubishi Outlander XLS
Report Run Date: 2012-01-13 17:47:44.247 EST
Report Summary
Class: CUV - Entry Level
Engine: 2.4L I4 EFI
Country of Assembly: Japan
Vehicle Age: 9 year(s)
Calculated Owners: 6
VIN: JA4LX41G53U060911
Year: 2003
Make: Mitsubishi
Model: Outlander XLS
Style/Body: SUV 4D
This vehicle's AutoCheck Score
The AutoCheck Score is a summary of your... 阅读全帖 |
|
s***0 发帖数: 1106 | 40 车子问题多多。小心。
Your AutoCheck Vehicle History Report
2003 Ford Explorer XLS
many owners many owners Calculated Owners: 2
Class: SUV - Lower Mid Range
Engine: 4.0L V6 EFI
Country of Assembly: United States
Vehicle Age: 12 year(s)
Calculated Owners: 2
VIN: 1FMZU62K93UA07034
Year: 2003
Make: Ford
Model: Explorer XLS
Style/Body: SUV 4D
This vehicle's AutoCheck Score
The AutoCheck Score is a summary of your vehicle's history. It lets you
compare similar vehicles wi... 阅读全帖 |
|
S*******C 发帖数: 7325 | 41 ☆─────────────────────────────────────☆
jqfei (jqfei) 于 (Fri Oct 1 23:18:51 2010, 美东) 提到:
短命的朝代不去说。长一点朝代,猪尾巴的君主比得过西汉,北宋吗?
若论平均素质,就得去掉一个最高分,一个最低分,再去掉一个亡国之君,因为最后那
个纯属赶鸭子上架。这样一比,猪尾巴比西汉差了几条街。然后我们来和北宋比比。
北宋在宋徽宗之前的君主都还不错,虽然整个朝代武力差了点,但基本和对手能打个平
手,就是在北宋末年,镇压个农民起义也是小菜一碟。经济发展的更是不在话下。北宋
之所以亡于金,纯属宋徽宗那个王八蛋瞎搞,并且宋徽宗本来也不该当皇帝,所以是天
亡北宋。
猪尾巴自乾隆之后全是庸碌之辈,虽然不是什么昏君,但绝对没有什么素质。乾隆末期
自己也不是什么好鸟。再论军事,自康熙之后就已经一塌糊涂了。康熙时代说实话也不
怎么样,打个三藩费了老鼻子劲,打个台湾还要靠禁海。至于清末,一个太平天国就搅
翻了天,打外战的水平更是地球人都知道。
☆───────────────────────────────────... 阅读全帖 |
|
p********g 发帖数: 8855 | 42 http://52internet.net/autocheck/vin/1FMYU02132KD26553
Your AutoCheck Vehicle History Report
2002 Ford Escape XLS
Report Run Date: 2010-11-11 22:55:55.197 EST
VIN: 1FMYU02132KD26553
Year: 2002
Make: Ford
Model: Escape XLS
Style/Body: SUV 4D
Class: CUV - Entry Level
Engine: 3.0L V6 SFI
Country of Assembly: United States
Vehicle Age: 8 year(s)
Calculated Owners: 2
Calculated Accidents: 1
Last Reported
Odometer Reading: 88,534
This vehicle's AutoCheck Score
The AutoCheck Score is a ... 阅读全帖 |
|
|
M****6 发帖数: 71 | 44 12.The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
A. libname qtrdata ‘qtr1.xls’;
B. libname ‘qtr1.xls’ sheets=3;
C. libname jan feb mar ‘qtr1.xls’;
D. libname mydata ‘qtr1.xls’ WORK.heets=(jan,feb,
mar);
版上的答案是A。看了... 阅读全帖 |
|
s****y 发帖数: 21 | 45 90%,比预期的高,之前做题勉强80%。
机经之前的帖子已经说得挺多了,我稍微补充点吧:
有两道关于excel文件包含多个sheets的题,一个是问怎样reference:选项有:
libname “aaa.xls”;
libname mydata "aaa.xls";
libname mydata "aaa.xls" work.sheets=(a,b,c);
libname a b c "aaa.xls".
另一个是怎样ref一个excel文件中一个叫north的sheet,选项有:
$north
'north$'e
'north$' n
什么的,完全不知道是什么东东,乱选了一个。
还有一道题是日期的写法,x="01feb2002"d,用的双引号,应该是可以这样写的。
还有个题要找出job中带manager的obs,选项有 where job like '%manager%';
其他的想起来再说吧。
磨磨蹭蹭的花了两三个月看完了little sas 和online tutor,以为就是拿钱换个证书
,后来做
123,50的时候发现只有80%的分,加上换题库,还是有点担心的。不过后来把 |
|