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
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Explain proc sort?
What are types of transport files?
Explain how merging helps to combine data sets.
What is the good sas programming practices for processing large data sets?
What are the limitations for memory allocation for SAS variables
If a variable contains letters or special characters, can it be numeric data type?
What are the different types of sas functions?
what is data integration? : Sas-di
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Give some examples where proc report’s defaults are different than proc print’s defaults?
How to specify variables to be processed by the freq procedure?
Name few SAS functions?
How many data types are there in SAS?
how does sas handle missing values in a merge? : Sas programming