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 / subbu
data s;
input no 1-2 area $ 3-15 am $ 16-30 ;
amount=input(am,comma15.);
format amount comma15.;
drop am;
cards;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;
proc print;
run;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
how does sas handle missing values in procs? : Sas programming
What are all the problems you faced while validating tables and reports?
Describe the ways in which you can create macro variables?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
what are informats in sas? : Sas-administrator
What is the difference between where and if statement?
What is the use of %include statement?
If a variable contains letters or special characters, can it be numeric data type?
do you prefer proc report or proc tabulate? Why? : Sas programming
Describe the ways in which you can create a macro variable?
What can be the size of largest dataset in SAS?
Which command is used to save logs in the external file?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
Mention the difference between ceil and floor functions in sas?
Explain data_null_?