topic Re: converting character value into numeric value in SAS Programming

topic Re: converting character value into numeric value in SAS Programming https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780851#M248846 Thanks , it worked .<BR /><BR /><BR /><BR /> Wed, 17 Nov 2021 19:55:48 GMT u52766097 2021-11-17T19:55:48Z converting character value into numeric value https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780820#M248826 <P>hello,</P><P>I am trying to convert the ASSEV variables values into numeric values . I created format for that and then used that format , but the numeric variable (AESEVN) values are missing. What wrong I am doing ,could u plz check .</P><P>Format  and note is below ;</P><P>/****************************************/</P><P>proc format;<BR />invalue sev<BR />"mild" = 1<BR />"moderate" = 2<BR />"severe" = 3;<BR />run;</P><P> </P><P>data test;<BR />set ae;<BR />aesevn = input(aesev,??sev.);<BR />run;</P><P> </P><P>note is showing into the log:</P><P> </P><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE1 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=1</DIV><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE1 aesev=Severe aeser= aediscon= aesevn=. _ERROR_=1 _N_=2</DIV><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE2 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=3</DIV><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE2 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=4</DIV><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE3 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=5</DIV><DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV><DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE3 aesev=Mild aeser= aediscon=1 aesevn=. _ERROR_=1 _N_=6</DIV><DIV class=""> </DIV><DIV class=""> </DIV><DIV class="">Thanks </DIV> Wed, 17 Nov 2021 18:38:51 GMT https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780820#M248826 u52766097 2021-11-17T18:38:51Z Re: converting character value into numeric value https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780821#M248827 <P>Spelling counts. "mild" is not "Mild" , which appears in your data.</P> <P>Try this:</P> <PRE>proc format; invalue sev (upcase) "MILD" = 1 "MODERATE" = 2 "SEVERE" = 3; run;</PRE> <P>The upcase option will turn the text into upper case before comparing the values in the informat list. So spellings in the source of "mild" "Mild" "mILD" "milD" and other possible typos all use "MILD" for assigning the numeric value.</P> <P>If your data is clean, then use the proper spelling to begin with. I tend to use the UPCASE option on all my character to numeric informats just because I don't trust my sources (with good reason) to spell things consistently.</P> <P> </P> <P> </P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/364694">@u52766097</a> wrote:<BR /> <P>hello,</P> <P>I am trying to convert the ASSEV variables values into numeric values . I created format for that and then used that format , but the numeric variable (AESEVN) values are missing. What wrong I am doing ,could u plz check .</P> <P>Format  and note is below ;</P> <P>/****************************************/</P> <P>proc format;<BR />invalue sev<BR />"mild" = 1<BR />"moderate" = 2<BR />"severe" = 3;<BR />run;</P> <P> </P> <P>data test;<BR />set ae;<BR />aesevn = input(aesev,??sev.);<BR />run;</P> <P> </P> <P>note is showing into the log:</P> <P> </P> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE1 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=1</DIV> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE1 aesev=Severe aeser= aediscon= aesevn=. _ERROR_=1 _N_=2</DIV> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE2 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=3</DIV> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE2 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=4</DIV> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-15 aeterm=AE3 aesev=Mild aeser= aediscon= aesevn=. _ERROR_=1 _N_=5</DIV> <DIV class="">NOTE: Invalid argument to function INPUT at line 71 column 10.</DIV> <DIV class="">usubjid=1001 aestdtc=2021-01-25 aeterm=AE3 aesev=Mild aeser= aediscon=1 aesevn=. _ERROR_=1 _N_=6</DIV> <DIV class=""> </DIV> <DIV class=""> </DIV> <DIV class="">Thanks </DIV> <HR /></BLOCKQUOTE> <P> </P> Wed, 17 Nov 2021 18:44:49 GMT https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780821#M248827 ballardw 2021-11-17T18:44:49Z Re: converting character value into numeric value https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780851#M248846 Thanks , it worked .<BR /><BR /><BR /><BR /> Wed, 17 Nov 2021 19:55:48 GMT https://communities.sas.com/t5/SAS-Programming/converting-character-value-into-numeric-value/m-p/780851#M248846 u52766097 2021-11-17T19:55:48Z