topic Re: Daylight Savings Time in SAS Programming https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801173#M315286 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/302621">@Eugenio211</a>&nbsp;- OK, in that case that's an SQL Server problem and nothing to do with SAS. Perhaps you could search on SQL Server forums for a solution?</P> Wed, 09 Mar 2022 19:34:45 GMT SASKiwi 2022-03-09T19:34:45Z Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800861#M315119 <P>Hello! Hope all is doing well.&nbsp; I just wanted to ask assistance in translating a SQL query into a SAS data step,&nbsp; thank you for your help.</P> <P>SELECT DISTINCT TL.[LOCATION]</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,TL.TELLER</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,CASE WHEN CAST(TL.LOGIN_DATE AS date) BETWEEN '3/14/2021' AND '11/6/2021'</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN CONVERT(VARCHAR(7),SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_DST_OFFSET),120)</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE CONVERT(VARCHAR(7),SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_OFFSET),120)</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END AS YEAR_MONTH</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,CASE WHEN CAST(TL.LOGIN_DATE AS date) BETWEEN '3/14/2021' AND '11/6/2021'</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN FORMAT(SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_DST_OFFSET),'ddd')</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE FORMAT(SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_OFFSET),'ddd')</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END AS DAY_OF_WEEK</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,CASE WHEN CAST(TL.LOGIN_DATE AS date) BETWEEN '3/14/2021' AND '11/6/2021'</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; THEN FORMAT(SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_DST_OFFSET),'h tt')</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE FORMAT(SWITCHOFFSET(TL.LOGIN_DATE AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC',C.UTC_OFFSET),'h tt')</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END AS LOCAL_TIME</P> <P>&nbsp;&nbsp;&nbsp; FROM TellerLogin AS TL</P> <P>&nbsp;&nbsp;&nbsp; JOIN TELLERID AS T</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON TL.TELLER = T.TELLER</P> <P>&nbsp;&nbsp;&nbsp; JOIN Company AS C</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON TL.[LOCATION] = C.[LOCATION]</P> <P>&nbsp;&nbsp;&nbsp; WHERE TL.[LOCATION] IS NOT NULL</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND TL.LOGIN_DATE BETWEEN '1/1/2021' AND '2/28/2022'</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND T.SECURITYGROUP_KEY IN (3, 4, 5, 7, <span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span></P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND C.IS_COLLECTIONS = 0</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND C.IS_INTERNET = 0</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND C.STORE_IS_OPEN = 1</P> <P>&nbsp;</P> Tue, 08 Mar 2022 14:54:40 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800861#M315119 Eugenio211 2022-03-08T14:54:40Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800863#M315120 <BLOCKQUOTE> <P><SPAN>Hello! Hope all is doing well.&nbsp; I just wanted to ask assistance in translating a SQL query into a SAS data step,&nbsp; thank you for your help.</SPAN></P> </BLOCKQUOTE> <P><SPAN>You might want to consider explaining what this code does. That would make it easier for someone to help you.</SPAN></P> <P>&nbsp;</P> <P>Here is SAS code to find when daylight savings time begins and ends:&nbsp;<A href="https://support.sas.com/resources/papers/proceedings17/1047-2017.pdf" target="_blank">https://support.sas.com/resources/papers/proceedings17/1047-2017.pdf</A></P> Tue, 08 Mar 2022 15:00:50 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800863#M315120 PaigeMiller 2022-03-08T15:00:50Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800867#M315122 <P>You may want to consider reposting the code in a text box opened on this forum using the &lt;/&gt; icon. If you read your original post at the 4th line from the bottom you may see that something was converted into an emoji instead of a value and a closing parentheses.</P> <P>&nbsp;</P> <P>Do you have a SAS data set already? Are the "date" values actually SAS dates, i.e. variable type numeric with a date format associated such as date9 or (guess here) ddmmyy10?</P> Tue, 08 Mar 2022 15:27:53 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800867#M315122 ballardw 2022-03-08T15:27:53Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800875#M315125 <P>Hello my apology with regards to not being clear.</P> <P>The format of our raw data date/time is '01JAN2021:01:34:00', what I wanted to do is that when the date and time is within the DST period then time is DST when outside DST then to local time. it's like doing case scenarios in the proc sql step.</P> <P>&nbsp;</P> <P>we also have our own offset to DST, below is the data.&nbsp; the data is also based on the province where the location is based.&nbsp;&nbsp;</P> <TABLE width="268"> <TBODY> <TR> <TD width="71">LOCATION</TD> <TD width="114">UTC_DST_OFFSET</TD> <TD width="83">UTC_OFFSET</TD> </TR> <TR> <TD>1</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>2</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>3</TD> <TD>4:39</TD> <TD>4:39</TD> </TR> <TR> <TD>4</TD> <TD>4:39</TD> <TD>4:39</TD> </TR> <TR> <TD>5</TD> <TD>4:39</TD> <TD>4:39</TD> </TR> <TR> <TD>6</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>7</TD> <TD>4:39</TD> <TD>4:39</TD> </TR> <TR> <TD>8</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>9</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>10</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>11</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>12</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>13</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>14</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>15</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>16</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>17</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>18</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>19</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>20</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>21</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>22</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>23</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>24</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>25</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>26</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>27</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>28</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>29</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>30</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>31</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>32</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>33</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>34</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>35</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>36</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>37</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>38</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>39</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>40</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>41</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>42</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>43</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>44</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>45</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>46</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>47</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>48</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>49</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>50</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>51</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>52</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>53</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>54</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>55</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>56</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>57</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>58</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>59</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>60</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>61</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>62</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>63</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>64</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>65</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>66</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>67</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>68</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>69</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>70</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>71</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>72</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>73</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>74</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>75</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>76</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>77</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>78</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>79</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>80</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>81</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>82</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>83</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>84</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>85</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>86</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>87</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>88</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>89</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>90</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>91</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>92</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>93</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>94</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>95</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>96</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>97</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>98</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>99</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>100</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>101</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>102</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>103</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>104</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>105</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>106</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>107</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>108</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>109</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>110</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>111</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>112</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>113</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>114</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>115</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>116</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>117</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>118</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>119</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>120</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>121</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>122</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>123</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>124</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>125</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>126</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>127</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>128</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>129</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>130</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>131</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>132</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>133</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>134</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>135</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>136</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>137</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>138</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>139</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>140</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>141</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>142</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>143</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>144</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>145</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>146</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>147</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>148</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>149</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>150</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>151</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>152</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>153</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>154</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>155</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>156</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>157</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>158</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>159</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>160</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>161</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>162</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>163</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>164</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>165</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>166</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>167</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>168</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>169</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>170</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>171</TD> <TD>-03:00</TD> <TD>-04:00</TD> </TR> <TR> <TD>172</TD> <TD>-05:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>173</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>174</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>175</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>176</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>177</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>178</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>179</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>180</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>181</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>182</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>183</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>184</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>185</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>186</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>187</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>188</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>189</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>190</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>191</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>192</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>193</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>194</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> <TR> <TD>195</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>196</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>197</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>198</TD> <TD>-06:00</TD> <TD>-07:00</TD> </TR> <TR> <TD>199</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>200</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>201</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>202</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>203</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>204</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>205</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>206</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>207</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>208</TD> <TD>-04:00</TD> <TD>-05:00</TD> </TR> <TR> <TD>209</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>210</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>211</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>212</TD> <TD>-07:00</TD> <TD>-08:00</TD> </TR> <TR> <TD>213</TD> <TD>-06:00</TD> <TD>-06:00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 08 Mar 2022 15:53:14 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800875#M315125 Eugenio211 2022-03-08T15:53:14Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800887#M315132 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/302621">@Eugenio211</a>&nbsp;wrote:<BR /> <P>&nbsp;</P> <P>The format of our raw data date/time is '01JAN2021:01:34:00', what I wanted to do is that when the date and time is within the DST period then time is DST when outside DST then to local time.</P> <HR /></BLOCKQUOTE> <P>I would imagine the code at the link I gave will get the job done.</P> Tue, 08 Mar 2022 16:19:51 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800887#M315132 PaigeMiller 2022-03-08T16:19:51Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800946#M315167 <P>What's the reason for translating the SQL? You can easily run it as it is against the same database from SAS using SQL Passthru.</P> Tue, 08 Mar 2022 21:57:21 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/800946#M315167 SASKiwi 2022-03-08T21:57:21Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801056#M315229 Hello, I'm not familiar with SQL Passthru, how do you do that? thanks a lot. Wed, 09 Mar 2022 12:49:10 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801056#M315229 Eugenio211 2022-03-09T12:49:10Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801060#M315232 never mind I got it. Thanks a lot for your help. Wed, 09 Mar 2022 12:57:57 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801060#M315232 Eugenio211 2022-03-09T12:57:57Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801085#M315249 Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13976">@SASKiwi</a>, <BR />I've encountered the error below using SAS passthru, what do you mean by this? thanks.<BR /><BR />ERROR: CLI open cursor error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The timezone provided to builtin function <BR /> switchoffset is invalid. Wed, 09 Mar 2022 14:37:46 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801085#M315249 Eugenio211 2022-03-09T14:37:46Z Re: Daylight Savings Time https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801173#M315286 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/302621">@Eugenio211</a>&nbsp;- OK, in that case that's an SQL Server problem and nothing to do with SAS. Perhaps you could search on SQL Server forums for a solution?</P> Wed, 09 Mar 2022 19:34:45 GMT https://communities.sas.com/t5/SAS-Programming/Daylight-Savings-Time/m-p/801173#M315286 SASKiwi 2022-03-09T19:34:45Z