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 / pravin
data cityrank;
input rank @3 city $ 13. amount : comma15.;
datalines;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;
run;
proc print data=cityrank;
run;
this is the ans only for this example new york has more than
single blank so problem arise hire.if not & modifier can be
used.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
For what purpose would you use the RETAIN statement?
what is change analysis in sas di ? : Sas-di
Mention the difference between ceil and floor functions in sas?
how do you debug and test your sas programs? : Sas programming
Of all your work, where have you been the most successful?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
For clinical entire study how many tables will create approx?
What is the difference between the proc sql and data step?
What are SAS/ACCESS and SAS/CONNECT?
what is sas and what are the functions? : Sas-administrator
what is intially documentation in sas?
Define run-group processing?
How do you control the number of observations and/or variables read or written?
Which are the statements whose placement in the data step is critical?