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


Please Help Members By Posting Answers For Below Questions

how will you locate the sas platform applications? : Sas-bi

581


explain what is data set in sas? : Sas-administrator

526


What are the difference between ceil and floor functions in sas?

704


What is the basic syntax of a sas program?

661


why is a stop statement needed for the point=option on a set statement? : Sas programming

583






Mention what is the difference between nodupkey and nodup options?

595


how to debug and test the sas program? : Sas-administrator

570


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

720


Explain substr function?

573


what has been your most common programming mistake? : Sas programming

562


what does the run statement do? : Sas programming

554


For clinical entire study how many tables will create approx?

1520


Mention some common errors that are usually committed in sas programming.

588


Mention the validation tools used in SAS?

654


explain about sas business intelligence? : Sas-bi

596