topic Re: question about infile in SAS Programming

question about infile

Amy0223 — Mon, 14 Oct 2019 19:00:34 GMT

Hi, I'm struggling with this question below. Your input is much appreciated!

data all;
infile ‘ubaacs.survey.tariff ’;
input type $1. @;
if type=’m’ then do;
   input nreps 2. id $2.;
   do i=1 to nreps;
       input uear rate;
       output;
    end;
    end;
run;

What variables will be in dataset all?
I think they are type, nreps, id, uear, rate. Please correct me if I'm wrong.
Suppose the raw dataset identified by the infile statement looked like this:
m 3us
87 5.4
88 5.15
89 5.0
i 1us
9.7 11.2
m 2it
88 6.0
89 5.8
What will dataset all look like???

Re: question about infile

PaigeMiller — Mon, 14 Oct 2019 19:14:52 GMT

You could actually run the code, and find out the answer that way.

Re: question about infile

Amy0223 — Mon, 14 Oct 2019 20:29:27 GMT

Thank you. I'm not really sure how to infile this raw data in Data all in order to run the codes.

Re: question about infile

PaigeMiller — Mon, 14 Oct 2019 20:49:25 GMT

You create a text file, with the name given in the infile statement, and then you run the code.

By the way, it seems as if the code you showed was perhaps pasted into here from Microsoft Word, in which case all of the quotes need to be replaced with "un-curly" quotes that SAS will recognize (SAS doesn't recognize the "curly" quotes).

Re: question about infile

Shmuel — Mon, 14 Oct 2019 20:54:10 GMT

Let's do the computer work:

the input              computer work
=======        ==========================
m 3us             type='m' and nreps=3 id='us'
87 5.4            rep1 ==> uear =88  rate=5.4
88 5.15           rep2 ==> complete it by yourself
89 5.0            rep3 ==>
i 1us             type ne 'm' ==> skip it
9.7 11.2          type ne 'm' ==> skip it
m 2it             type = 'm' and nreps=2 id='it'  
88 6.0            rep1 ==>
89 5.8            rep2 ==>

Re: question about infile

Amy0223 — Mon, 14 Oct 2019 21:51:24 GMT

Thank you very much for the information. I will pay attention to it.

Re: question about infile

Amy0223 — Mon, 14 Oct 2019 21:52:35 GMT

Thank you very much for helping me understand this problem. I greatly appreciate it!

Re: question about infile

ChrisNZ — Tue, 15 Oct 2019 03:30:56 GMT

What variables are in the table is determined at compile time.

The data has nothing to do with it.

Hint: you forgot one variable.

Re: question about infile

Kurt_Bremser — Tue, 15 Oct 2019 05:48:51 GMT

You can avoid having to access an external file by using inline data with the datalines file reference and datalines statement:

data all;
infile datalines;
input type $1. @;
if type = 'm' then do;
  input nreps 2. id $2.;
  do i = 1 to nreps;
    input uear rate;
    output;
  end;
end;
datalines;
m 3us
87 5.4
88 5.15
89 5.0
i 1us
9.7 11.2
m 2it
88 6.0
89 5.8
;

Note:

I corrected the artifacts of using a word processor for code
I did some visual formatting on the code to make it readable
I used the "little running man" button to open a window fror posting SAS code, so code is preserved as-is

Re: question about infile

Amy0223 — Tue, 15 Oct 2019 15:09:13 GMT

I was having a lot of errors when running the codes but now I understand why. You are amazing! Thank you very much for taking your precious time to help me. I greatly appreciate it!