設置二進制標誌以連續分組數據嗨伙計,
我有一些雪數據,我希望能夠使用表格確定不同時間間隔(月,水年,年)的雪的起始和結束日期。摘要。
噹噹前行加上雪的下5行包含雪數據(> 0)時,我想將col(x)值設置為1。當我有超過10連續的積雪時,我可以讓它運作良好。當連續的雪行數<10時,我使用以下代碼得到以下結果:
國旗雪
0 0.0
0 0.0
1 1.0
1 2.0
0 3.0
0 4.0
1 5.0
1 6.0
0 0.0
0 0.0
0 0.0
0 0.0
如果(
:名稱(“雪”)> 0和滯後(:名稱(“雪”)> 0,-1)&
滯後(:名稱(“雪”)> 0,-2)和滯後(
:名稱(“雪”)> 0,
-3
)和滯後(:名稱(“雪”)> 0,-4)| :名稱(“雪”)>
0和滯後(:名稱(“雪”)> 0,1)&
滯後(:名稱(“雪”)> 0,2)和滯後(
:名稱(“雪”)> 0,
3
)和滯後(:名稱(“雪”)> 0,4),
1,
0
)
關於如何以正確或更好的方式做到這一點的任何想法?我需要為此計算創建不同的閾值級別,以便能夠連續7天,10天,21天連續工作Re:設置連續分組數據的二進制標誌抱歉,
我忘了我是那樣寫的。你當然解決了原來的問題。我喜歡下面列出的更改。再次感謝您對此問題的幫助。Re:設置連續分組數據的二進制標誌很高興它有所幫助。對於設置標誌的連續行數,我將使用您的原始描述 “當我當前行加上雪的下5行包含雪數據(> 0)時,我想將col(x)值設置為1。”
對於嚴格要求n = 5只需改變
style =“WORD-SPACING:0px; FONT:16px / 20px'Times New Roman'; TEXT-TRANSFORM:none; COLOR:rgb(0,0,0); TEXT-INDENT:0px; WHITE-SPACE:normal; LETTER -SPACING:normal; BORDER-COLLAPSE:separate; TEXT-ALIGN:left; orphans:2; widows:2; webkit-border-horizontal-spacing:0px; webkit-border-vertical-spacing:0px; webkit-text-decorations -in-effect:none; webkit-text-size-adjust:auto; webkit-text-stroke-width:0px“>
類=蘋果式跨度
style =“FONT-SIZE:13px; LINE-HEIGHT:16px; FONT-FAMILY:arial,helvetica,sans-serif”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間>
style =“FONT-SIZE:10pt; COLOR:rgb(0,0,221); FONT-FAMILY:'Courier New'”>如果
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:rgb(0,0,221); FONT-FAMILY:'Courier New'”> Max
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間> 小號
類=蘋果轉換空間> )
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> n
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 0
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間> )
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>;
成
style =“WORD-SPACING:0px; FONT:16px / 20px'Times New Roman'; TEXT-TRANSFORM:none; COLOR:rgb(0,0,0); TEXT-INDENT:0px; WHITE-SPACE:normal; LETTER -SPACING:normal; BORDER-COLLAPSE:separate; TEXT-ALIGN:left; orphans:2; widows:2; webkit-border-horizontal-spacing:0px; webkit-border-vertical-spacing:0px; webkit-text-decorations -in-effect:none; webkit-text-size-adjust:auto; webkit-text-stroke-width:0px“>
類=蘋果式跨度
style =“FONT-SIZE:13px; LINE-HEIGHT:16px; FONT-FAMILY:arial,helvetica,sans-serif”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>
類=蘋果式跨度
style =“WORD-SPACING:0px; FONT:16px / 20px'Times New Roman'; TEXT-TRANSFORM:none; COLOR:rgb(0,0,0); TEXT-INDENT:0px; WHITE-SPACE:normal; LETTER -SPACING:normal; BORDER-COLLAPSE:separate; TEXT-ALIGN:left; orphans:2; widows:2; webkit-border-horizontal-spacing:0px; webkit-border-vertical-spacing:0px; webkit-text-decorations -in-effect:none; webkit-text-size-adjust:auto; webkit-text-stroke-width:0px“>
類=蘋果式跨度
style =“FONT-SIZE:13px; LINE-HEIGHT:16px; FONT-FAMILY:arial,helvetica,sans-serif”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間>
style =“FONT-SIZE:10pt; COLOR:rgb(0,0,221); FONT-FAMILY:'Courier New'”>如果
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:rgb(0,0,221); FONT-FAMILY:'Courier New'”> Max
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間> 小號
類=蘋果轉換空間> )
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>
顏色=紅色> > =
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> n
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 0
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
類=蘋果轉換空間> )
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>;
保持代碼更具可讀性。Re:設置連續分組數據的二進制標誌謝謝你的建議。我學到了很多關於根據你提供的代碼編寫JMP的其他方法。唯一的打嗝是我必須將n = 5改為比期望值小1。也就是說,當n = 5時,設置在二進制標誌之前需要為6的連續雪數據行的數量。通過更改為n = 4,程序在有5個連續的數據行時設置標誌。感謝您的建議和幫助。Re:設置連續分組數據的二進制標誌請嘗試以下公式。“n = 5”定義當一行中> 5行具有雪數據> 0時,它將為所有事件將標誌設置為1。希望這可以幫助。
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”>本地
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
{ 一世
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
ñ
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> =
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 5
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> s
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> =
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”> J
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 2
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> *
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> n
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 2
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 0
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
)}
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:1”>
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”> For
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> i
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> =
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> -
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> n
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> i
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> <=
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
ñ
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
一世
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> ++,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:2”>
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”>如果
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>:
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>雪 [
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”> Row
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>()
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
一世
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”>空
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>()]
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 0
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:3”>
小號 [ 一世
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
ñ
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 2
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>]
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> =
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> s [( 一世
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
ñ
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 2
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>)
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> -
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>]
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”> +
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:2”>
)
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:1”>
)
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>;
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“mso-tab-count:1”>
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”>如果
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:#0000dd; FONT-FAMILY:'Courier New'”> Max
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>(
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> s
)
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”> n
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 1
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>,
style =“FONT-SIZE:10pt; COLOR:teal; FONT-FAMILY:'Courier New'”> 0
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
)
style =“FONT-SIZE:10pt; COLOR:navy; FONT-FAMILY:'Courier New'”>;
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>
style =“FONT-SIZE:10pt; COLOR:black; FONT-FAMILY:'Courier New'”>)