topic Re: understanding sas base question in SAS Programming

understanding sas base question

shubhamtiwari — Wed, 28 Aug 2019 05:44:14 GMT

Hi,

Please help me to understand the following question,

Which SAS statement correctly uses column input to read the values in the raw data file below in this order: Address (4th field), SquareFeet (second field), Style (first field),
Bedrooms (third field)?

1--+----10---+----20---+----30

2STORY 5500 7 MUMBAI71 NEW

ALATE 2200 4 RANE STREET

MONTE 5200 3 MUKESH STREET

1. input Address 15-29 SquareFeet 8-11 Style 1-6
Bedrooms 13;
2. input $ 15-29 Address 8-11 SquareFeet $ 1-6 Style
13 Bedrooms;
3. input Address $ 15-29 SquareFeet 8-11 Style $ 1-6
Bedrooms 13;
4. input Address 15-29 $ SquareFeet 8-11 Style 1-6
$ Bedrooms 13;

Doubt= what is the 1--+----10---+----20---+----30 means in the question?

Please help

thank you

Re: understanding sas base question

Kurt_Bremser — Wed, 28 Aug 2019 07:00:36 GMT

@shubhamtiwari wrote:

Hi,

Please help me to understand the following question,

Which SAS statement correctly uses column input to read the values in the raw data file below in this order: Address (4th field), SquareFeet (second field), Style (first field),
Bedrooms (third field)?

1--+----10---+----20---+----30

2STORY 5500 7 MUMBAI71 NEW

ALATE 2200 4 RANE STREET

MONTE 5200 3 MUKESH STREET

1. input Address 15-29 SquareFeet 8-11 Style 1-6
Bedrooms 13;
2. input $ 15-29 Address 8-11 SquareFeet $ 1-6 Style
13 Bedrooms;
3. input Address $ 15-29 SquareFeet 8-11 Style $ 1-6
Bedrooms 13;
4. input Address 15-29 $ SquareFeet 8-11 Style 1-6
$ Bedrooms 13;

Doubt= what is the 1--+----10---+----20---+----30 means in the question?

Please help

thank you

This line is just a ruler for horizontal orientation. It becomes more useful when viewed with a fixed-space font:

1---+----10---+----20---+----30

2STORY 5500 7 MUMBAI71 NEW
ALATE  2200 4 RANE STREET
MONTE  5200 3 MUKESH STREET

Re: understanding sas base question

shubhamtiwari — Wed, 28 Aug 2019 12:07:38 GMT

@Kurt_Bremser than you for the reply, but still i did not understood the meaning of those numbers 1,10,20,30

1--+----10---+----20---+----30

what if we have like this 5--+----15---+----19---+----44

here what does these numbers 5,15,19,44 represent?

Please elaborate.

Re: understanding sas base question

Kurt_Bremser — Wed, 28 Aug 2019 12:20:19 GMT

1 is position 1 in the input line.

The "1" of "10" marks position 10 (the "0" is therefore position 11), and so on.

Only the 10s are been marked like that, so you won't see 5 or 15. This is also close to the way SAS puts a ruler into the log when it shows external data being read by a data step.

Run this code for reference:

filename test temp;

data _null_;
file test;
put "12345";
put "67890";
run;

data _null_;
infile test;
input;
list;
run;

filename test clear;

and read the log.

Re: understanding sas base question

Kurt_Bremser — Wed, 28 Aug 2019 12:24:09 GMT

Just to clarify: the ruler line is NOT part of the data, it is there only to make finding a start position for reading a variable easier.

Re: understanding sas base question

ballardw — Thu, 29 Aug 2019 15:58:42 GMT

@shubhamtiwari wrote:

@Kurt_Bremser than you for the reply, but still i did not understood the meaning of those numbers 1,10,20,30

1--+----10---+----20---+----30

what if we have like this 5--+----15---+----19---+----44

here what does these numbers 5,15,19,44 represent?

Please elaborate.

1---+----10---+----20---+----30
2STORY   5500 7 MUMBAI71 NEW
         111111111122222222223
123456789012345678901234567890

The 3rd and 4th rows expand on the idea. Again important is to view things with a fixed width font

above indicates position number 10, of the first 5 in second row, The + are the values ending in 5 such as 15, 25

Position 20 is the B in Mumbai.

it is only a tool for counting columns. Nothing magic or difficult.