1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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.

Question Posted / solasa

Answers were Sorted based on User's Feedback



1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / 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

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / amy

Add a colon modifier before the informat (commaw.) and increase the informat width, like the following.

data cityrank;
infile 'D:\miths data\Mithelesh\cityrank.txt' ;
input rank city $12. amount : comma15.;
run;
proc print data=cityrank;
run;

Is This Answer Correct ?    6 Yes 5 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / 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

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / ravikumar

Answer:

data cityrank;
input rank 1-2 @3 city $13. @16 amoutnt comma15.;
datalines;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;
run;

Is This Answer Correct ?    2 Yes 4 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / chandrakanth

To Solasa and others ....whenever you read data from an input file...you need to be careful about the last data value in every dataline you have values like x,xxx,xxx which is total width of 9, when you mention more than 9 the input pointer will go the next data line to get the remaining spaces. So in your code you used comma10. try with using comma9. I am very sure it will work.

Another option is if you want to keep that comma10. use TRUNCOVER in the infile statement, this should fix all the extra spaces you mention in the input statement.

let me know if this does not help you

Is This Answer Correct ?    0 Yes 2 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / poornima

data poo;
infile 'D:\poo.txt ';
input rank country $ 12. salary ;
INFORMAT SALARY COMMA10.;
FORMAT SALARY COMMA10.;
run;

proc print;
run;

Is This Answer Correct ?    0 Yes 2 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / guest

data temp;
infile datalines ;
input sno city & $12.
pop : comma.;
datalines;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;

The ampersand (&) modifier is used to read character values
that contain embedded blanks.
The colon (:) modifier is used to read nonstandard data
values and character values that are longer than eight
characters, but which contain no embedded blanks.

Is This Answer Correct ?    0 Yes 3 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / guest

data temp;
infile datalines ;
input sno city & $12.
pop : comma.;
datalines;
1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900
;

The ampersand (&) modifier is used to read character values
that contain embedded blanks.
The colon (:) modifier is used to read nonstandard data
values and character values that are longer than eight
characters, but which contain no embedded blanks.

Is This Answer Correct ?    1 Yes 4 No

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read ..

Answer / 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

More SAS Interview Questions

What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

0 Answers  

which domain is better in sas? clinical trails or banking

3 Answers  

i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,

How do you debug macros?

3 Answers   Accenture,




Tell me more about the parameters in macro? : sas-macro

0 Answers  

What is the general format of function in sas? : sas-grid-administration

0 Answers  

hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process

2 Answers   HSBC,

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

0 Answers  

What is a macro routine?

0 Answers  

If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

1 Answers   HCL, Quintiles,

What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

3 Answers   TCS,

For more SAS Interview Questions Click Here
Categories