Associating characters to Do variables

[SasFellow331]

I am having issues associating the characters within the datalines to the do variable 'time'. can anyone assist me with that?

data new;

do time=1 to 4;

input m1-m3 @;

output;

end;

datalines;

na 4 56

bo 2 45

so 4 30

zd 1 55

;

run;

[art297]

Not sure what you're question is, but the following will do what I think your code was trying to do:

data new;

  format time best32.;

  informat m1 $2.;

  input m1-m3;

  time=_n_;

datalines;

na 4 56

bo 2 45

so 4 30

zd 1 55

;

[SasFellow331]

I am trying to associate the characters in the first column with the 1-4 in the do "time" variable. i want to read the read the na as 1, bo as 2.

[art297 · Accepted solution]

Create and apply either a format or informat.

You have to provide more info. Are you just trying to do something like:

proc format;

  invalue mtime

  'na'=1

  'bo'=2

  'so'=3

  'zd'=4

  ;

run;

data new;

  informat time mtime.;

  input time m2-m3;

datalines;

na 4 56

bo 2 45

so 4 30

zd 1 55

;

run;