https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583736#M166205 <P>????</P> <P>Guess what is missing in this statement:</P> <PRE><CODE class=" language-sas">input name subject score;</CODE></PRE> Sun, 25 Aug 2019 07:20:06 GMT Kurt_Bremser 2019-08-25T07:20:06Z https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583734#M166203 <P>Hello</P> <P>I create a data set but the&nbsp; column area has no values in the data set that was created?</P> <P>What is wrong?</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data tbl1; infile datalines dlm='|'; length name $10 subject $20 score 8 area $10; input name subject score; datalines; John|Math|98|EU John|English|76|EU John|Biology|81|EU John|Physics|69|EU John|Economics|79|EU Tony|Math|65|USA Tony|English|34|USA Tony|Biology|87|USA Tony|Physics|56|USA Tony|Economics|90|USA Jeff|Math|41|EU Jeff|English|45|EU Jeff|Biology|56|EU Jeff|Physics|78|EU Jeff|Economics|34|EU ; run;</CODE></PRE> Sun, 25 Aug 2019 06:41:56 GMT https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583734#M166203 Ronein 2019-08-25T06:41:56Z https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583736#M166205 <P>????</P> <P>Guess what is missing in this statement:</P> <PRE><CODE class=" language-sas">input name subject score;</CODE></PRE> Sun, 25 Aug 2019 07:20:06 GMT https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583736#M166205 Kurt_Bremser 2019-08-25T07:20:06Z https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583737#M166206 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/159549">@Ronein</a>;</P> <P>As&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/11562">@Kurt_Bremser</a>&nbsp;said, you have forgotten AREA in the INPUT statement.&nbsp;</P> <P>But if you coded it as an all-inclusive list (_ALL_), you wouldn't have:</P> <PRE><CODE class=" language-sas">data tbl1 ; informat name $10. subject $20. score 8. area $10. ; input (_all_) (:) ; cards ; John Math 98 EU John English 76 EU John Biology 81 EU John Physics 69 EU John Economics 79 EU Tony Math 65 USA Tony English 34 USA Tony Biology 87 USA Tony Physics 56 USA Tony Economics 90 USA Jeff Math 41 EU Jeff English 45 EU Jeff Biology 56 EU Jeff Physics 78 EU Jeff Economics 34 EU run ; </CODE></PRE> <P>Incidentally, you need neither the delimiter nor the INFILE statement with your input since you have no intervening blanks in your raw data. Plus, the proper instrument for reading raw data is INFORMAT rather than LENGTH. In your simple case the latter works, but if you had something more elaborate to read (date or datetime, say) it wouldn't.&nbsp;</P> <P>&nbsp;</P> <P>Kind regards</P> <P>Paul D.</P> Sun, 25 Aug 2019 07:47:42 GMT https://communities.sas.com/t5/SAS-Programming/create-a-data-set-with-data-entry/m-p/583737#M166206 hashman 2019-08-25T07:47:42Z