Expand Data Set 1

[smalek]

Hi again
I am back requesting help on data set expansion issue. Here is the current layout of the data:

Code Value
001 15
005 25
225 10

Required output:
Code Value CC
001 15 VC
001 15 VDL
001 15 FC
005 25 VC
005 25 VDL
005 25 FC
225 10 VC
225 10 VDL
225 10 FC

Any suggestions much appreciated.
Thanks

 

[ChrisW75]

data dset2;
  set dset1;

  length CC $3;
  CC = 'VC';
  output;

  CC = 'VDL';
  output;

  CC = 'FC';
  output;
run;

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[smalek]

worked like a charm! Thanks ChrisW75

 

[ChrisW75]

No worries.
You can also get smart and use a "DO FOR" loop to do it as well and reduce the manual coding. For the above example it's not an issue, but if you needed to output say 50 copies of each record, it would save alot of coding.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.