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.
Answer Posted / solasa
data cityrank;
infile 'D:\miths data\Mithelesh\cityrank.txt' ;
input rank city & $12. amoutnt comma10.;
run;
proc print data=cityrank;
run;
problem with amount varible
tell what to do?
| Is This Answer Correct ? | 3 Yes | 12 No |
Post New Answer View All Answers
What are the functions which are used for character handling functions?
Explain the difference between nodup and nodupkey options?
What do you understand by the term Normal Distribution?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
How will you generate test data with no input data?
How do you add a number to a macro variable? : sas-macro
Give some ways by which you can define the variables to produce the summary report (using proc report)?
what are the considerations when picking a SAS/STAT procedure?
Give an example where SAS fails to convert character value to numeric value automatically?
What is the use of function Proc summary?
How many data types are there in SAS?
What are the difference between the sas data step and sas procs?
Describe 5 ways to do a “table lookup” in SAS?
What is the difference between class statement and by statement in proc means?
Have you ever used the SAS Debugger?