l******9
发帖数: 579 | 1 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: change year format in Access by SQL query
发信站: BBS 未名空间站 (Mon Oct 13 12:50:53 2014, 美东)
I am working on Access 2012 on win 7. In a table, I need to change a year
date format from '1-Jan-06' to 2006 and from '1-Jan-90' to 1990. I only need
year.
This is my query
SELECT *,
CASE
WHEN CAST(right(year_date,2) , INT) <= 12
THEN 2000 + CAST(right(year_date,2) , INT)
ELSE 1900 + CAST(right(year_date,2) , INT)
END
FROM my_table;
I ... 阅读全帖 |
|
P********s
发帖数: 15 | 2 Here is the code snippet ( managed C++)
...
Int32 nTemp = 10;
String * pMsg = String::Format("Display an integer here: {0}", nTemp);
...
I got an error message when tried to compile the program:
error C2665: 'System::String::Format' : none of the 5 overloads can convert pa
rameter 2 from type 'int'
Am I missing anything here? Thanx in advance. |
|
z***a
发帖数: 138 | 3 Hi,
I am fixing a bug in an app that builds a Word 2007 document using
Office Open XML format. There is already a .zip package for the
document. The App will build an XML formatted data which then is
imported by the document.
In the document there is one field for a street address and there is a
corresponding XML node with address data containing street address line
1 and 2. (City, State, zip is in another field so they do not matter).
I need to split the address into two lines if second line ad... 阅读全帖 |
|
L****i
发帖数: 379 | 4 My pc has office 2000, and I install "Microsoft Office Compatibility Pack
for Word, Excel, and PowerPoint 2007 File Formats," the 2007 file icons
still look like corrupt files.
What should I do? Is that the correct format converter? |
|
l*******n
发帖数: 373 | 5 32G吧。估计是format成FAT32了，在disk management里删掉partition，重新format成
NTFS。 |
|
t****t
发帖数: 6806 | 6 quick format == clean/create index only
full format == clean all data and index
玩笑 |
|
c**********u
发帖数: 203 | 7 移动硬盘有3个区，我不小心format /q了第一个，导致整个硬盘都无法识别了
请问怎么修复呢？
被format的那个分区里面的数据倒不重要，关键是其它两个分区找不到了:(
谢谢 |
|
o**n
发帖数: 1249 | 8 最近发现我的老ipod photo，听一些歌经常死机，可重复的，怀疑是硬盘有bad sector
，我用mkdosfs -F 32 -c format了一次，花了一个多小时发现非常多的bad sectors，
我好奇再运行一次，发现找出的bad sectors和之前居然很多不一样，是不是bad
sector太多拉，有什么low-level format tool？我想低格一次，google了半天，没找
到合适的，请教大家。 |
|
N****w
发帖数: 21578 | 9 what do you mean?
little-endian vs. big-endian?
there is nothing called ARM format for data.
x86 |
|
s********g
发帖数: 49 | 10 Window 2000 won't allow me to format primary drive C:".
going to DOS, and it said "Format not supported on drive C:".
PC got virus, I need a clean C; before I regenerate the Window. |
|
M*******8
发帖数: 85 | 11 多谢指点！
这个
do x = (x << 7)|(b[i] & 0x7f) until (b[i] & 0x80) == 0
是从multi-byte integer format转为regular integer 吧?
如何从integer转为 multi-byte integer format？ 谢谢 |
|
l******9
发帖数: 579 | 12 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: change year format in Access by SQL query
发信站: BBS 未名空间站 (Mon Oct 13 12:50:53 2014, 美东)
I am working on Access 2012 on win 7. In a table, I need to change a year
date format from '1-Jan-06' to 2006 and from '1-Jan-90' to 1990. I only need
year.
This is my query
SELECT *,
CASE
WHEN CAST(right(year_date,2) , INT) <= 12
THEN 2000 + CAST(right(year_date,2) , INT)
ELSE 1900 + CAST(right(year_date,2) , INT)
END
FROM my_table;
I ... 阅读全帖 |
|
g****e
发帖数: 167 | 13 刚开始接触spark. 我只会用SaveAsTextFile 保存结果，但是结果需要formatting. 请
问有什么办法可以format么？多谢！ |
|
s********g
发帖数: 49 | 14 Window 2000 won't allow me to format primary drive C:".
going to DOS, and it said "Format not supported on drive C:".
PC got virus, I need a clean C; before I regenerate the Window. |
|
s*******k
发帖数: 71 | 15
Convert PS to EPS (encapsulated postscript) and Powerpoint would be able to
recognize it, or use WMF format. In principle, any vector-format image files
would be better than bitmap image files.
SH |
|
y******p
发帖数: 336 | 16 help.
sorry i cannot write in chinese.
yesterday, i buy a new dell laptop with window vista.
at first it run well. and then i try to partition the c disk with "partition
magic" but it does not work. the soft showed that it is a error for c disc.
then i run it again, it does not work at all and i try to repair from image.
it does not work and i try to format and reintall. however, i canot format
the c disc. this thing never happen before.
what should i do?
help.
thanks |
|
|
f******e
发帖数: 582 | 18 Anyone knows how to convert video file in .rmvb format to either (.avi,
..wmv. mpeg4,)?
I need to record a .rmvb file onto DVD. however, the software I am
using does not recognize .rmvb format...
or anyone could recommend a software that can direct record .rmvb file
onto DVD?
Thanks. |
|
z*****n
发帖数: 7639 | 19 I am writing a paper using ACM format.
There is one problem: the list of references is not
numbered. But in the text those numbers are visible.
The format I am using is
\documentclass{acmtrans2m}
...
\bibliographystyle{plain}
...
\bibliography{mybibfile}
anyone can give me a suggestion? |
|
o******e
发帖数: 10 | 20 I have a table with the following tex code
\begin{tabular*}{1\textwidth}{ccc}
1 & 2 & 3 \\
1 & 2 & 3 \\
\end{tabular*}
i.e., I want to format the table so that the width of the table is equal to
1 textwidth.
Now I use windows lyx. How can I format this in lyx?
Thanks |
|
b*******x
发帖数: 2469 | 21 you can export endnote file directly to latex format, just like how you
export endnote file to different Journal formats.
There is a "endnote" choice in the list of journals. |
|
x******g
发帖数: 3952 | 22 I've seen your post in Linux board.
I do not have much idea about this problem.
Here are some suggestions:
1. Make sure your HD is detected by BIOS correctly.
2. Try Partition Magic.
3. What's your HD's brand? Most HD manufacturers provide tools
for formatting the HD. I've used Quantum and Seagate tools.
I think you can find them on their web site.
4. Plug and Pray other Big Shrimp can help you.
5. Do not use softwares other than provided by the manufacturer
to low level format th |
|
d*******r
发帖数: 432 | 23 if you can afford the time (to rebuild everything), low
level format is actually a good way to make sure you have a
clean HD.
you'll need to get a utility from your HD manufactorer, I
know quantum,seagate,fujitsu and ibm all have such a
utility.
ps. most refer to this util as zero-fill which write zeroes
to the whole HD, it's not really low level format, cause
modern HD doesn't need it anymore. |
|
y******p
发帖数: 336 | 24 help.
sorry i cannot write in chinese.
yesterday, i buy a new dell laptop with window vista.
at first it run well. and then i try to partition the c disk with "partition
magic" but it does not work. the soft showed that it is a error for c disc.
then i run it again, it does not work at all and i try to repair from image.
it does not work and i try to format and reintall. however, i canot format
the c disc. this thing never happen before.
what should i do?
help.
thanks |
|
q****a
发帖数: 334 | 25 Need more than 40 credits in live format, as there is limitation to take
self study CPE courses. Does anyone know where can take live format CPE
class in NY? Thanks |
|
L*****o
发帖数: 48 | 26 RT. I could NOT get pretty well-formed tube on Matrigel when doing tube
formation assay.I am not sure if the cell starving is required before the
the tube formation assay? Usually how long is the starve duration? Can
anyone help me answer this question? Thanks! |
|
c*********8
发帖数: 125 | 27 不是endnote自带的那个format，至少我的Endnote版本那个PNAS format output 跟
PNAS网站上要求格式完全不一样.
谢谢先! |
|
s*****g
发帖数: 87 | 28 实验室开始做stem cell半年左右，现在想做一个human iPSC strain的 Karyotyping
和 teratoma formation analysis，请问各位做stem cell的大牛什么地方提供这种服
务或者合作？
我在网上查了一下，一个加州的生物公司 （Applied StemCell）提供这两项服务，但
是价格不菲：
Karyotyping 300$/line
teratoma formation analysis 2900$/line
有没有其他更好的地方？
谢谢！ |
|
l****j
发帖数: 70 | 29 看到Bio-rad有Criterion Cell（Vertical midi-format electrophoresis cell），
cat:165-6001,可以loading 12+2well,18well,26well，但是他们只有Criterion Empty
Cassettes卖，没有配套的glass plate
有其他公司的Midi-format electrophoresis cell带配套的glass plate吗？ |
|
t*n
发帖数: 14458 | 30 use format, like
read(*,100) x1,x2,x3,......
100 format(9X, F5.2,1X, F5.2, 1X, F5.2,.....) |
|
o****e
发帖数: 195 | 31 for those who plan to take patent bar, this is the minute taken from a recent
PTO meeting. the test format has changed dramatically, which might affect your
strategies and plans. the most noticeable change is that it can be taken at
any time, so you can tailor the time to avoid collision with the finals.
(Source: Jim Longacre's course www.passthepatentbar.com)
**************************
The PTO held an information session Monday, January 26th, with regard
to the changes in the PTO Exam format. |
|
r*****d
发帖数: 80 | 32 New step 1 format
#509388
lagosboy - 05/27/10 23:38
Hey guys,hope u are all studying hard for the new step1 exam format.
took my exam after may 15th and obviously i had the new set of questions.
Basically the exam has just slight modifications from the previous one,let
me explain it to u guys based on each subject
pharmacology:still the same old way of side effects and mechanism of actions
microbiology:same old way but with emphasis on treatments and diagrams to
make d |
|
s**c
发帖数: 1247 | 33 怎么删除data里面原来的format？我想看原始数据
还有print的时候如何只print原始数据，不用format |
|
z***c
发帖数: 32 | 34 请问proc format library =library;
value name1
1=
2=
3=
;
value name2
1=
2=
3=
4=
;
run;
如果用了name1的名字和name2一样会出现什么情况，是不是name2 override name1?
但是在一个很正规的数据中间看到这个现象，不知道其中有什么奥妙？如果真的后者
override前面的话，为什么还要有前面的那个format呢？
谢谢！ |
|
y*****5
发帖数: 62 | 35 解决了。
我这样做的：
data new;
set old;
format gender;
run;
then format on gender was removed. |
|
P****D
发帖数: 11146 | 36 FORMAT statement可以直接用在PROC PRINT里。
proc print data=old; format gender; run; 就可以了。不用重新建一个名叫new的
dataset。 |
|
b**********i
发帖数: 1059 | 37 收到一堆sas file还是transport 格式，每个variable都有format。用惯了spss了，现
在需要找出sas format 格式然后再在spss里面打label，有点郁闷。刚刚在挣扎是不是
这次就用sas做了，可spss套路熟。在短线和长线利益中彷徨，哈。 |
|
p********a
发帖数: 5352 | 38 手工生成的FORMATS是个文件啊，。CAT 类型的
SAS自带的FORMATS每次自动LOAD |
|
x***x
发帖数: 3401 | 39 the original format is
value city
1='1. Beijing'
2='2. Shanghai'
3='3. Tianjing';
format |
|
D******n
发帖数: 2836 | 40 just make a new format ...lol
parameter里有format name.
稍作改动, 变成 |
|
a********a
发帖数: 346 | 41 I use
\bibliographystyle{plainnat}
\bibliography{dissertation_reference}
the format of the reference is:
Victor De Gruttola and Xin Ming Tu. Modelling progression of CD4-lymphocyte
count and its relationship to survival time. Biometrics, 50:1003-1014, 1994.
But I really want author's last name shows first, then the first name, i.e.
the format shows like the following:
Gruttola, V.D. and Tu, X.M . Modelling progression of CD4-lymphocyte
count and its relationship to survival time. Biometrics, 50:... 阅读全帖 |
|
h********o
发帖数: 103 | 42 proc format;
value fmt 1 = "one" 11 = "one" 111 = "one"
2 = "two" 22 = "two" 222 = "two"
other = "Others";
run;
data one;
input A @@;
format A fmt.;
cards;
1 11 111 2 22 222 123 432
;
data two;
set one;
if(put(A,fmt.)) = "Others";
run;
proc print;
run;
Obs A
1 Others
2 Others |
|
b*********l
发帖数: 466 | 43 How to produce tabular format table without using proc tabulate?
Tabular format is like the following:
|--------+-------------+--------------+--------+-----------+------------|
|lbtest| aaaaaa | bbbbbb |ccccc |ddddd |eeeeee |
|--------+-------------+--------------+--------+-----------+------------| |
|
f*****k
发帖数: 110 | 44 有这样一个dataset：
OBS GENDER WEIGHT . . . . .
1 1 1 . . . . .
2 2 2 . . . . .
3 3 3 . . . . .
. . . . . . . .
. . . . . . . .
当在SAS中打开这个dataset时，由于有permanent format的存在，显示的是这样的：
OBS GENDER WEIGHT . . . . .
1 male NA . . . . .
2 female low . . . . .
3 NA high . . . . .
. . . . . . . .
. . . . . . . .
我有两个与FORMAT有关的问题需要解决。一个就是如何让这个dataset在SAS中显示原本
的数字，而不是数字的value label。
另外一个问题就是如何把'NA'所对应的... 阅读全帖 |
|
k*******a
发帖数: 772 | 45 第一个你可以新建一个data，不含format的
data new;
set old;
format _all_;
run; |
|
c******5
发帖数: 22 | 46 谢谢回答！！！ 我试了试，还是有error：
Format 。。。 not found or couldn't be loaded for variable 。。。
OPTIONS FMTSEARCH=(AA.FORMAT1, AA.FORMAT2, AA.FORMAT3);
中三个formats中间不用逗号我也试了试，还是有error message。太郁闷了～～～
还有建议吗？ 谢谢大家！ |
|
j*******r
发帖数: 412 | 47 proc format;
value gender 1 = ' Male '
2 = ' Female';
run;
我想把这个format在proc tabulate里显示出来，留着blanks这样可以有错位的效果。
结果打印结果是leading blanks被自动删除了。
十分苦恼，求好心的专家点拨：
怎么才能保留这些blanks呢？ |
|
d******9
发帖数: 404 | 48 I find the below option works:
data E;
input ID $ Name $;
cards;
0001 Tom
0003 Jack
6005 Gary
;
run;
filename AAA 'path/AAA.xls';
ODS listing;
ODS HTML file=Amanda
headtext="";
proc report data=E;
column ID name;
define id/display 'ID' width = 10 format = $10. ;
define name/display;
run;
ODS HTML close;
ODS listing; |
|
l****u
发帖数: 529 | 49 This one:define your_variable_name / display style(column)={tagattr='format:
##0.0'};?
This one: your_variable_name
/ style(column)={htmlstyle="mso-number-format:\@"} |
|
p***r
发帖数: 920 | 50 明明 没有用 range 定义 proc format,为什么使用
PROC FORMAT CNTLIN=FMT;RUN;
的时候会出现error:These two ranges overlap; |
|
