https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345603#M79516 <P>I haven't looked closely at your code but, in your final datastep, there is no set statement.</P> <P>&nbsp;</P> <P>I would think you should have, as your second line, included a statement like:</P> <P>&nbsp;</P> <PRE>set clean.cleansurvey;</PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Thu, 30 Mar 2017 00:47:08 GMT art297 2017-03-30T00:47:08Z https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345600#M79514 <P>I need help figuring out where I've gone wrong, please.</P><P>&nbsp;</P><P>I have a data set containing 29 observations and 12 variables.&nbsp; After I import my data set, I see the following {below}. I'm attempting to use an array to clean up data. However, once I enter my code, I'm left with 7 variables and 1 observation. I don't know where I am going wrong and would appreciate help.</P><P>Thank you.</P><PRE class="sasLog">&nbsp;<IMG src="https://communities.sas.com/t5/image/serverpage/image-id/8029i87141CE6AF969E9A/image-size/original?v=1.0&amp;px=-1" alt="image.png" title="image.png" border="0" /></PRE><PRE><CODE class=" language-sas">Libname Clean '/folders/myfolders/Week 11'; proc import datafile='/folders/myfolders/Week 11/BAS150 Survey.xlsx' dbms=xlsx out=Clean.CleanSurvey; run; proc print data=clean.cleansurvey; run; proc freq data=clean.cleansurvey; run; data clean.cleansurvey; array clean{*} preferred_browser read_news online_shopping online_gaming facebook twitter other_social_network; do i = 1 TO dim(clean); if clean{i}="Eleven" then clean{i}="11"; if clean{i}=" " then clean{i}="."; if clean{i}="Fire Fox" then clean{i}="Firefox"; if clean{i}="Gogle" then clean{i}="Google"; if clean{i}="Yohoo" then clean{i}="Yahoo"; if clean{i}="99" then clean{i}="."; if clean{i}="Linked In" then clean{i}="LinkedIn"; end; drop i; run;</CODE></PRE><P>&nbsp;Log is as follows:</P><DIV class="sasSource">1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;</DIV><DIV class="sasSource">61</DIV><DIV class="sasSource">62 data clean.cleansurvey;</DIV><DIV class="sasSource">63 array clean{*} preferred_browser read_news online_shopping online_gaming facebook twitter other_social_network;</DIV><DIV class="sasSource">64 do i = 1 TO dim(clean);</DIV><DIV class="sasSource">65 if clean{i}="Eleven" then clean{i}="11";</DIV><DIV class="sasSource">66 if clean{i}=" " then clean{i}=".";</DIV><DIV class="sasSource">67 if clean{i}="Fire Fox" then clean{i}="Firefox";</DIV><DIV class="sasSource">68 if clean{i}="Gogle" then clean{i}="Google";</DIV><DIV class="sasSource">69 if clean{i}="Yohoo" then clean{i}="Yahoo";</DIV><DIV class="sasSource">70 if clean{i}="99" then clean{i}=".";</DIV><DIV class="sasSource">71 if clean{i}="Linked In" then clean{i}="LinkedIn";</DIV><DIV class="sasSource">72 end;</DIV><DIV class="sasSource">73 drop i;</DIV><DIV class="sasSource">74 run;</DIV><DIV class="sasNote">&nbsp;</DIV><DIV class="sasNote">NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).</DIV><DIV class="sasNote">65:15 65:29 66:15 66:24 67:15 67:31 68:15 68:28 69:15 69:28 70:15 70:25 71:15 71:32</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Eleven' , at line 65 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Fire Fox' , at line 67 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Gogle' , at line 68 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Yohoo' , at line 69 column 15.</DIV><DIV class="sasNote">NOTE: Invalid numeric data, 'Linked In' , at line 71 column 15.</DIV><DIV class="sasSource">preferred_browser=11 read_news=11 online_shopping=11 online_gaming=11 facebook=11 twitter=11 other_social_network=11 i=8 _ERROR_=1</DIV><DIV class="sasSource">_N_=1</DIV><DIV class="sasNote">NOTE: The data set CLEAN.CLEANSURVEY has 1 observations and 7 variables.</DIV><DIV class="sasNote">NOTE: DATA statement used (Total process time):</DIV><DIV class="sasNote">real time 0.00 seconds</DIV><DIV class="sasNote">cpu time 0.00 seconds</DIV><DIV class="sasNote">&nbsp;</DIV><DIV class="sasNote">&nbsp;</DIV><DIV class="sasSource">75</DIV><DIV class="sasSource">76 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;</DIV><DIV class="sasSource">89</DIV> Thu, 30 Mar 2017 00:43:07 GMT https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345600#M79514 bldudley 2017-03-30T00:43:07Z https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345603#M79516 <P>I haven't looked closely at your code but, in your final datastep, there is no set statement.</P> <P>&nbsp;</P> <P>I would think you should have, as your second line, included a statement like:</P> <P>&nbsp;</P> <PRE>set clean.cleansurvey;</PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Thu, 30 Mar 2017 00:47:08 GMT https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345603#M79516 art297 2017-03-30T00:47:08Z https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345607#M79517 <P>Thank you. That worked!</P> Thu, 30 Mar 2017 01:16:47 GMT https://communities.sas.com/t5/SAS-Programming/Array-Help-Invalid-numeric-data/m-p/345607#M79517 bldudley 2017-03-30T01:16:47Z