topic Re: table lookup in SAS Programming

table lookup

Jedrzej — Tue, 23 May 2017 13:24:47 GMT

Hi,

I have two data sets.

First data set contains two variables ID and Description

Second data set has variables with observations that contains numbers. These numbers are corelated with ID numbers from the first data set.

Now my task is to change this numbers from the second data sets to the description from the first set . I've tried with joins but this is not efficient and takes a lot of time. Any ideas ?

first data set

ID Description

14 yellow

second data set

Color

Re: table lookup

art297 — Tue, 23 May 2017 13:29:26 GMT

I'd create and apply a format.

Art, CEO, AnalystFinder.com

Re: table lookup

art297 — Tue, 23 May 2017 13:45:32 GMT

e.g.:

data descriptions;
  input ID   Description $50.;
  cards;
14   yellow
;

data have;
  input Color;
  cards;
14
;

data for4mat;
  set descriptions (rename=(id=start description=label)) end = last;
  retain fmtname 'ccode' type 'N';
run;


proc format cntlin = for4mat;
run;

data want;
  set have;
  length Color_Description $50.;
  Color_Description=put(color,ccode.);
run;

Art, CEO, AnalystFinder.com