1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
how to read the above data using input statement
consider the above data is in txt format externally
u have to use infile and input statement.
- 9 Answers
- 10544 Views
- Quintiles, I also Faced
- E-Mail Answers
Answer Posted / chandrakanth
To Solasa and others ....whenever you read data from an input file...you need to be careful about the last data value in every dataline you have values like x,xxx,xxx which is total width of 9, when you mention more than 9 the input pointer will go the next data line to get the remaining spaces. So in your code you used comma10. try with using comma9. I am very sure it will work.
Another option is if you want to keep that comma10. use TRUNCOVER in the infile statement, this should fix all the extra spaces you mention in the input statement.
let me know if this does not help you
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the functions which are used for character handling functions?
What is the use of PROC gplot?
what is star schema? : Sas-di
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Tell me about % include and % eval? : sas-macro
How do you test for missing values?
how do the in= variables improve the capability of a merge? : Sas programming
List out some key concept of SAS
Differentiate input and infile.
What is the basic structure of a sas program?
Explain translate function?
how does sas handle missing values in assignment statements? : Sas programming
What does the trace option do?
How do you specify the number of iterations and specific condition within a single do loop?
Explain bmdp procedure?
