topic Re: How to populate an OBS from one data set to all OBS from another dataset in SAS Programming

How to populate an OBS from one data set to all OBS from another dataset

knveraraju91 — Sat, 21 Jan 2017 01:15:13 GMT

Dear,

I need to populates total number of subjects to all OBS in data1 to calculate percentages.

With my code the values from data2 only polulating to first OBS in data1. Please help. Thanks

code;

data3;

merge data1 data2;

run;

data1

Text 100mg 200mg

Teae due to drug 10 15

Teae due to procedure 5 8

mild teae 3 9

moderate teae 4 6

data2 (Total number of subjects)

100mg 200mg

50 65

output need;

Text 100mg 200mg 100mgTNS 200mgTNS

Teae due to drug 10 15 50 65

Teae due to procedure 5 8 50 65

mild teae 3 9 50 65

moderate teae 4 6 50 65

output getting;

ext 100mg 200mg 100mgTNS 200mg

Teae due to drug 10 15 50 65

Teae due to procedure 5 8

mild teae 3 9

moderate teae 4 6

art297 — Sat, 21 Jan 2017 02:01:14 GMT

This probably isn't the most efficient method, but it will work:

data data3 (drop=n);
  set data1;
  n=1;
  set data2 (rename=(_100mg=_100mgTNS _200mg=_200mgTNS)) point=n;
run;

HTH,

Art, CEO, AnalystFinder.com

Astounding — Sat, 21 Jan 2017 02:14:41 GMT

A commonplace method:

data data3;
  set data1;
  if _n_=1 then 
  set data2 (rename=(_100mg=_100mgTNS _200mg=_200mgTNS));
run;