using & in creating data set

Ronein — Sat, 18 Jul 2020 04:38:10 GMT

Hello

May anyone explain the following code?

What is the using of symbol & in the code?

How many observations we should get ?

data two;
input var1 $ var2 & $20.;
cards;
hope  sad and happy
;

Re: using & in creating data set

Kurt_Bremser — Sat, 18 Jul 2020 05:35:42 GMT

Maxim 1: Read the Documentation.

Maxim 4: If in Doubt, Do a Test Run.

Re: using & in creating data set

Tom — Sat, 18 Jul 2020 17:11:24 GMT

@Ronein wrote:

Hello

May anyone explain the following code?

What is the using of symbol & in the code?

How many observations we should get ?
data two;
input var1 $ var2 & $20.;
cards;
hope  sad and happy
;

The purpose of the & in an INPUT statement is to force SAS to looks for two adjacent delimiters to find the end of the next "word" in the line when using LIST MODE input style. It will also allow you to add an informat specification to your INPUT statement without forcing FORMATTED MODE input style.

Since the second "word" on the line does not have any places with multiple embedded spaces (space is the default delimiter) then for your example it does nothing. If you had removed the & then SAS would have read VAR using FORMATTED MODE so it would have read the next 20 character, whether or not they contained any number of delimiters. And since you are reading from in-line data the input is always padded to the next multiple of 80 characters the fact that 'sad and happy' is only 13 characters long would not have any impact. But if you tried to read that line from a file stead and the line did not have at least 7 spaces after 'happy' then it would read past the end of the line and you would end up with zero observations. So in that case the & would make a difference as it would prevent the $20. informat from attempting to read past the end of the line.

Try this test program:

filename test temp;
options parmcards=test;
parmcards;
123456789012345678901234567890
One   Two  Three  Four
sad and happy
;

data test1;
  infile test;
  input var1 & $20.;
  put var1 = $quote.;
run;

data test2;
  infile test;
  input var1  $20.;
  put var1 = $quote.;
run;

topic using & in creating data set in SAS Programming

using & in creating data set

Re: using & in creating data set

Re: using & in creating data set