topic Re: how to create a new variable in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378989#M91162 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/55121">@Elena</a> wrote:<BR /> <P>I used</P> <P>tt75 anno 2008= 110</P> <P>tt80 anno 2008=121</P> <P>tt75 anno 2002=148</P> <P>&nbsp;</P> <P>110*121/148=90</P> <P>&nbsp;</P> <P>so the formula is</P> <P>&nbsp;</P> <P>tt80s(anno t) = tt75 (anno t-5) * tt80(anno t-5) / tt75 (anno t-10)</P> <P>&nbsp;</P> <P>(anno is year)</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>Got it. Was constantly looking at the wrong line and confused by the result.</P> <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/18408">@Ksharp</a>'s suggestion is probably the best solution (simple code).</P> <P>&nbsp;</P> Tue, 25 Jul 2017 13:29:02 GMT Kurt_Bremser 2017-07-25T13:29:02Z how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378948#M91138 <P>Hi,<BR />I have this dataset<BR />DATA TEMP;<BR />INPUT @1 codice_comune 5.<BR />&nbsp;&nbsp; &nbsp;&nbsp; @7 anno 4.<BR />&nbsp;&nbsp; &nbsp;&nbsp; <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/70859">@12</a> tt75 3.<BR />&nbsp;&nbsp; &nbsp;&nbsp; @15 tt80 3.<BR />&nbsp;&nbsp; &nbsp; ;<BR />DATALINES;<BR />33001 2002 141&nbsp; 77<BR />33001 2003 148&nbsp; 88<BR />33001 2004 136 104<BR />33001 2005 137 106<BR />33001 2006 134 115<BR />33001 2007 118 122<BR />33001 2008 110 121<BR />33001 2009 117 112<BR />33001 2010 111 109<BR />33001 2011 120 110<BR />33001 2012 133 105<BR />33001 2013 132&nbsp; 94<BR />33001 2014 134&nbsp; 97<BR />33001 2015 131&nbsp; 94<BR />33001 2016 122 105<BR />33001 2017 115 107<BR />33002 2002 227 113<BR />33002 2003 232 122<BR />33002 2004 233 138<BR />33002 2005 233 159<BR />33002 2006 219 172<BR />33002 2007 203 184<BR />33002 2008 210 178<BR />33002 2009 203 181<BR />33002 2010 193 173<BR />33002 2011 217 168<BR />33002 2012 227 163<BR />33002 2013 216 171<BR />33002 2014 205 175<BR />33002 2015 214 157<BR />33002 2016 197 175<BR />33002 2017 196 180<BR />&nbsp;run;<BR /><BR />I must create a new var for every codice_comune from anno 2012 to anno 2022 with this formula<BR /><BR />Tt80s=tt75(anno2007)*tt80(anno2007)/tt75(anno2002)<BR /><BR />The final dataset must be:<BR /><BR />Codice_comune&nbsp;&nbsp; Anno&nbsp;&nbsp;&nbsp; tt75&nbsp;&nbsp;&nbsp; tt80&nbsp;&nbsp;&nbsp; tt80s<BR /><BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2002&nbsp;&nbsp; &nbsp;141&nbsp;&nbsp; &nbsp;77&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2003&nbsp;&nbsp; &nbsp;148&nbsp;&nbsp; &nbsp;88&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2004&nbsp;&nbsp; &nbsp;136&nbsp;&nbsp; &nbsp;104&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2005&nbsp;&nbsp; &nbsp;137&nbsp;&nbsp; &nbsp;106&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2006&nbsp;&nbsp; &nbsp;134&nbsp;&nbsp; &nbsp;115&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2007&nbsp;&nbsp; &nbsp;118&nbsp;&nbsp; &nbsp;122&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2008&nbsp;&nbsp; &nbsp;110&nbsp;&nbsp; &nbsp;121&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2009&nbsp;&nbsp; &nbsp;117&nbsp;&nbsp; &nbsp;112&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2010&nbsp;&nbsp; &nbsp;111&nbsp;&nbsp; &nbsp;109&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2011&nbsp;&nbsp; &nbsp;120&nbsp;&nbsp; &nbsp;110&nbsp;&nbsp; &nbsp;<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2012&nbsp;&nbsp; &nbsp;133&nbsp;&nbsp; &nbsp;105&nbsp;&nbsp; &nbsp;102<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2013&nbsp;&nbsp; &nbsp;132&nbsp;&nbsp; &nbsp;94&nbsp;&nbsp; &nbsp;90<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2014&nbsp;&nbsp; &nbsp;134&nbsp;&nbsp; &nbsp;97&nbsp;&nbsp; &nbsp;96<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2015&nbsp;&nbsp; &nbsp;131&nbsp;&nbsp; &nbsp;94&nbsp;&nbsp; &nbsp;88<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2016&nbsp;&nbsp; &nbsp;122&nbsp;&nbsp; &nbsp;105&nbsp;&nbsp; &nbsp;99<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2017&nbsp;&nbsp; &nbsp;115&nbsp;&nbsp; &nbsp;107&nbsp;&nbsp; &nbsp;118<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2018&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;113<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2019&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;111<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2020&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;111<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2021&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;107<BR />33001&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2022&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;93<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2002&nbsp;&nbsp; &nbsp;227&nbsp;&nbsp; &nbsp;113&nbsp;&nbsp; &nbsp;113<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2003&nbsp;&nbsp; &nbsp;232&nbsp;&nbsp; &nbsp;122&nbsp;&nbsp; &nbsp;111<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2004&nbsp;&nbsp; &nbsp;233&nbsp;&nbsp; &nbsp;138&nbsp;&nbsp; &nbsp;111<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2005&nbsp;&nbsp; &nbsp;233&nbsp;&nbsp; &nbsp;159&nbsp;&nbsp; &nbsp;107<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2006&nbsp;&nbsp; &nbsp;219&nbsp;&nbsp; &nbsp;172&nbsp;&nbsp; &nbsp;93<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2007&nbsp;&nbsp; &nbsp;203&nbsp;&nbsp; &nbsp;184&nbsp;&nbsp; &nbsp;194<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2008&nbsp;&nbsp; &nbsp;210&nbsp;&nbsp; &nbsp;178&nbsp;&nbsp; &nbsp;211<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2009&nbsp;&nbsp; &nbsp;203&nbsp;&nbsp; &nbsp;181&nbsp;&nbsp; &nbsp;245<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2010&nbsp;&nbsp; &nbsp;193&nbsp;&nbsp; &nbsp;173&nbsp;&nbsp; &nbsp;304<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2011&nbsp;&nbsp; &nbsp;217&nbsp;&nbsp; &nbsp;168&nbsp;&nbsp; &nbsp;328<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2012&nbsp;&nbsp; &nbsp;227&nbsp;&nbsp; &nbsp;163&nbsp;&nbsp; &nbsp;165<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2013&nbsp;&nbsp; &nbsp;216&nbsp;&nbsp; &nbsp;171&nbsp;&nbsp; &nbsp;161<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2014&nbsp;&nbsp; &nbsp;205&nbsp;&nbsp; &nbsp;175&nbsp;&nbsp; &nbsp;158<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2015&nbsp;&nbsp; &nbsp;214&nbsp;&nbsp; &nbsp;157&nbsp;&nbsp; &nbsp;143<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2016&nbsp;&nbsp; &nbsp;197&nbsp;&nbsp; &nbsp;175&nbsp;&nbsp; &nbsp;166<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2017&nbsp;&nbsp; &nbsp;196&nbsp;&nbsp; &nbsp;180&nbsp;&nbsp; &nbsp;182<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2018&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;176<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2019&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;177<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2020&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;174<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2021&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;159<BR />33002&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;2022&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;155<BR /><BR /></P><P>thank</P> Tue, 25 Jul 2017 12:38:12 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378948#M91138 Elena 2017-07-25T12:38:12Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378958#M91144 <P>Please review your formula. I can't fit it reasonably to your "want" data. And why does your tt80s start in 2012 for 33001, but in 2002 for 33002?</P> Tue, 25 Jul 2017 12:51:51 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378958#M91144 Kurt_Bremser 2017-07-25T12:51:51Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378963#M91147 <TABLE><TBODY><TR><TD>Codice_comune&nbsp;&nbsp;</TD><TD>&nbsp;Anno&nbsp;&nbsp;&nbsp;</TD><TD>&nbsp;tt75&nbsp;&nbsp;</TD><TD>&nbsp; tt80&nbsp;&nbsp;</TD><TD>&nbsp; tt80s</TD></TR><TR><TD>33001</TD><TD>2002</TD><TD>141</TD><TD>77</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2003</TD><TD>148</TD><TD>88</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2004</TD><TD>136</TD><TD>104</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2005</TD><TD>137</TD><TD>106</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2006</TD><TD>134</TD><TD>115</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2007</TD><TD>118</TD><TD>122</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2008</TD><TD>110</TD><TD>121</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2009</TD><TD>117</TD><TD>112</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2010</TD><TD>111</TD><TD>109</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2011</TD><TD>120</TD><TD>110</TD><TD>&nbsp;</TD></TR><TR><TD>33001</TD><TD>2012</TD><TD>133</TD><TD>105</TD><TD>102</TD></TR><TR><TD>33001</TD><TD>2013</TD><TD>132</TD><TD>94</TD><TD>90</TD></TR><TR><TD>33001</TD><TD>2014</TD><TD>134</TD><TD>97</TD><TD>96</TD></TR><TR><TD>33001</TD><TD>2015</TD><TD>131</TD><TD>94</TD><TD>88</TD></TR><TR><TD>33001</TD><TD>2016</TD><TD>122</TD><TD>105</TD><TD>99</TD></TR><TR><TD>33001</TD><TD>2017</TD><TD>115</TD><TD>107</TD><TD>118</TD></TR><TR><TD>33001</TD><TD>2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>113</TD></TR><TR><TD>33001</TD><TD>2019</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>111</TD></TR><TR><TD>33001</TD><TD>2020</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>111</TD></TR><TR><TD>33001</TD><TD>2021</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>107</TD></TR><TR><TD>33001</TD><TD>2022</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>93</TD></TR><TR><TD>33002</TD><TD>2002</TD><TD>227</TD><TD>113</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2003</TD><TD>232</TD><TD>122</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2004</TD><TD>233</TD><TD>138</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2005</TD><TD>233</TD><TD>159</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2006</TD><TD>219</TD><TD>172</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2007</TD><TD>203</TD><TD>184</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2008</TD><TD>210</TD><TD>178</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2009</TD><TD>203</TD><TD>181</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2010</TD><TD>193</TD><TD>173</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2011</TD><TD>217</TD><TD>168</TD><TD>&nbsp;</TD></TR><TR><TD>33002</TD><TD>2012</TD><TD>227</TD><TD>163</TD><TD>165</TD></TR><TR><TD>33002</TD><TD>2013</TD><TD>216</TD><TD>171</TD><TD>161</TD></TR><TR><TD>33002</TD><TD>2014</TD><TD>205</TD><TD>175</TD><TD>158</TD></TR><TR><TD>33002</TD><TD>2015</TD><TD>214</TD><TD>157</TD><TD>143</TD></TR><TR><TD>33002</TD><TD>2016</TD><TD>197</TD><TD>175</TD><TD>166</TD></TR><TR><TD>33002</TD><TD>2017</TD><TD>196</TD><TD>180</TD><TD>182</TD></TR><TR><TD>33002</TD><TD>2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>176</TD></TR><TR><TD>33002</TD><TD>2019</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>177</TD></TR><TR><TD>33002</TD><TD>2020</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>174</TD></TR><TR><TD>33002</TD><TD>2021</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>159</TD></TR><TR><TD>33002</TD><TD>2022</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>155</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>That's ok!</P> Tue, 25 Jul 2017 13:00:38 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378963#M91147 Elena 2017-07-25T13:00:38Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378966#M91150 <P>Ok, then which values did you use for year 2013 / 33001 that gave you the value 90?</P> Tue, 25 Jul 2017 13:04:42 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378966#M91150 Kurt_Bremser 2017-07-25T13:04:42Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378967#M91151 <P>Here could give a start .</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">DATA TEMP; INPUT codice_comune anno tt75 tt80 ; DATALINES; 33001 2002 141 77 33001 2003 148 88 33001 2004 136 104 33001 2005 137 106 33001 2006 134 115 33001 2007 118 122 33001 2008 110 121 33001 2009 117 112 33001 2010 111 109 33001 2011 120 110 33001 2012 133 105 33001 2013 132 94 33001 2014 134 97 33001 2015 131 94 33001 2016 122 105 33001 2017 115 107 ; run; proc sql; select *,(select tt75 from temp where codice_comune=a.codice_comune and anno=a.anno-5)* (select tt80 from temp where codice_comune=a.codice_comune and anno=a.anno-5)/ (select tt75 from temp where codice_comune=a.codice_comune and anno=a.anno-10) as want from temp as a; quit;</CODE></PRE> Tue, 25 Jul 2017 13:04:57 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378967#M91151 Ksharp 2017-07-25T13:04:57Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378983#M91158 <P>I used</P><P>tt75 anno 2008= 110</P><P>tt80 anno 2008=121</P><P>tt75 anno 2002=148</P><P>&nbsp;</P><P>110*121/148=90</P><P>&nbsp;</P><P>so the formula is</P><P>&nbsp;</P><P>tt80s(anno t) = tt75 (anno t-5) * tt80(anno t-5) / tt75 (anno t-10)</P><P>&nbsp;</P><P>(anno is year)</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 25 Jul 2017 13:24:40 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378983#M91158 Elena 2017-07-25T13:24:40Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378989#M91162 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/55121">@Elena</a> wrote:<BR /> <P>I used</P> <P>tt75 anno 2008= 110</P> <P>tt80 anno 2008=121</P> <P>tt75 anno 2002=148</P> <P>&nbsp;</P> <P>110*121/148=90</P> <P>&nbsp;</P> <P>so the formula is</P> <P>&nbsp;</P> <P>tt80s(anno t) = tt75 (anno t-5) * tt80(anno t-5) / tt75 (anno t-10)</P> <P>&nbsp;</P> <P>(anno is year)</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>Got it. Was constantly looking at the wrong line and confused by the result.</P> <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/18408">@Ksharp</a>'s suggestion is probably the best solution (simple code).</P> <P>&nbsp;</P> Tue, 25 Jul 2017 13:29:02 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/378989#M91162 Kurt_Bremser 2017-07-25T13:29:02Z Re: how to create a new variable https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/379000#M91170 <P>Thank you,</P><P>I'll work on it.</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 25 Jul 2017 13:46:55 GMT https://communities.sas.com/t5/SAS-Programming/how-to-create-a-new-variable/m-p/379000#M91170 Elena 2017-07-25T13:46:55Z