Help using Base SAS procedures

Associating characters to Do variables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Associating characters to Do variables

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;


Accepted Solutions
Solution
‎02-28-2015 06:06 PM
PROC Star
Posts: 7,468

Re: Associating characters to Do variables

Posted in reply to SasFellow331

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;

View solution in original post


All Replies
PROC Star
Posts: 7,468

Re: Associating characters to Do variables

Posted in reply to SasFellow331

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

;

Occasional Contributor
Posts: 7

Re: Associating characters to Do variables

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.

Solution
‎02-28-2015 06:06 PM
PROC Star
Posts: 7,468

Re: Associating characters to Do variables

Posted in reply to SasFellow331

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 190 views
  • 0 likes
  • 2 in conversation