topic Re: PROC IMPORT Problem in Microsoft Integration with SAS

topic Re: PROC IMPORT Problem in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176656#M1511 <HTML><HEAD></HEAD><BODY><P>You've got hex null characters in your string. VERY BAD.</P><P>Make sure that in the original data these are replaced with blanks (hex 20).</P><P></P><P>Since I have no idea how to input '00'x's in Excel, I suspect that they came there from another application.</P></BODY></HTML> Mon, 23 Feb 2015 08:25:00 GMT Kurt_Bremser 2015-02-23T08:25:00Z PROC IMPORT Problem https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176653#M1508 <HTML><HEAD></HEAD><BODY><P>Hello, after the file import with XLSX I have very strange columns behaviour - length of the actual data is equal to the length of the column, for example I try to create new integer column from string and get the following note:<BR /> NOTE: Invalid numeric data, '22247...' and new column is empty after that.</P><P></P><P>I concatenated '!!!' to all values and got the following result - '22247   !!!' - can't compress it either. Have somebody seen such a thing?</P></BODY></HTML> Fri, 20 Feb 2015 11:42:33 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176653#M1508 sough 2015-02-20T11:42:33Z Re: PROC IMPORT Problem https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176654#M1509 <HTML><HEAD></HEAD><BODY><P>Use $HEX format to see what characters are actually in your data.</P><P>For example if you character variable is named XX and you wanted to create new variable name N from it you could code:</P><P>data new ;</P><P> set old;</P><P> n=input(xx,32.)</P><P> if n=. and x ne ' ' then put 'Invalid Number: ' xx $hex. ;</P><P>run;</P></BODY></HTML> Fri, 20 Feb 2015 13:40:03 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176654#M1509 Tom 2015-02-20T13:40:03Z Re: PROC IMPORT Problem https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176655#M1510 <HTML><HEAD></HEAD><BODY><P><STRONG>Good morning, I ve got the fillowing log</STRONG></P><P></P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3734373538000000</P><P>Values=74758    n=. _ERROR_=1 _N_=1</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3632383037000000</P><P>Values=62807    n=. _ERROR_=1 _N_=2</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3130343232310000</P><P>Values=104221   n=. _ERROR_=1 _N_=3</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3637323431000000</P><P>Values=67241    n=. _ERROR_=1 _N_=4</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3131303138310000</P><P>Values=110181   n=. _ERROR_=1 _N_=5</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3534303537000000</P><P>Values=54057    n=. _ERROR_=1 _N_=6</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3433333535000000</P><P>Values=43355    n=. _ERROR_=1 _N_=7</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3134303033390000</P><P>Values=140039   n=. _ERROR_=1 _N_=8</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3339343035000000</P><P>Values=39405    n=. _ERROR_=1 _N_=9</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3931323334000000</P><P>Values=91234    n=. _ERROR_=1 _N_=10</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3236383334000000</P><P>Values=26834    n=. _ERROR_=1 _N_=11</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3932383131000000</P><P>Values=92811    n=. _ERROR_=1 _N_=12</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3533323037000000</P><P>Values=53207    n=. _ERROR_=1 _N_=13</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3739373639000000</P><P>Values=79769    n=. _ERROR_=1 _N_=14</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3238313834310000</P><P>Values=281841   n=. _ERROR_=1 _N_=15</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3130343831320000</P><P>Values=104812   n=. _ERROR_=1 _N_=16</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3834310000000000</P><P>Values=841      n=. _ERROR_=1 _N_=17</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 3232323437000000</P><P>Values=22247    n=. _ERROR_=1 _N_=18</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 0000000000000000</P><P>Values=         n=. _ERROR_=1 _N_=19</P><P>NOTE: Invalid argument to function INPUT at line 46949 column 7.</P><P>Invalid Number: 0000000000000000</P><P>WARNING: Limit set by ERRORS= option reached.  Further errors of this type will not be printed.</P><P>Values=         n=. _ERROR_=1 _N_=20</P><P>Invalid Number: 0000000000000000</P><P>Invalid Number: 0000000000000000</P><P>Invalid Number: 0000000000000000</P><P>Invalid Number: 3134343936363000</P><P>NOTE: Mathematical operations could not be performed at the following places. The results of the</P><P>      operations have been set to missing values.</P><P>      Each place is given by: (Number of times) at (Line):(Column).</P><P>      24 at 46949:7</P><P>NOTE: There were 24 observations read from the data set WORK.FACT2014050_3.</P><P>NOTE: The data set WORK.AAAA has 24 observations and 2 variables.</P><P>NOTE: DATA statement used (Total process time):</P><P>      real time           0.01 seconds</P><P>      cpu time            0.01 seconds</P></BODY></HTML> Mon, 23 Feb 2015 03:24:08 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176655#M1510 sough 2015-02-23T03:24:08Z Re: PROC IMPORT Problem https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176656#M1511 <HTML><HEAD></HEAD><BODY><P>You've got hex null characters in your string. VERY BAD.</P><P>Make sure that in the original data these are replaced with blanks (hex 20).</P><P></P><P>Since I have no idea how to input '00'x's in Excel, I suspect that they came there from another application.</P></BODY></HTML> Mon, 23 Feb 2015 08:25:00 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/PROC-IMPORT-Problem/m-p/176656#M1511 Kurt_Bremser 2015-02-23T08:25:00Z