topic Re: Associating characters to Do variables in SAS Procedures

Associating characters to Do variables

SasFellow331 — Sat, 28 Feb 2015 22:05:53 GMT

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;

Re: Associating characters to Do variables

art297 — Sat, 28 Feb 2015 22:27:36 GMT

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

;

Re: Associating characters to Do variables

SasFellow331 — Sat, 28 Feb 2015 22:55:43 GMT

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.

Re: Associating characters to Do variables

art297 — Sat, 28 Feb 2015 23:06:49 GMT

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;