Merge or append?

peatjohnston — Wed, 12 Aug 2015 15:34:21 GMT

Hi, I have a simple question, I think, but have not found an elegant way to implement it.

I have datasetA with 70 rows and a number of variables. I used PROC UNIVARIATE to find percentiles for some of these variables and OUTPUT these percentiles into a new datasetB,which only has the percentiles (one row of data). I want to merge these so that I have the percentile values represented for every row in datasetA so that I can write some simple equations in a new data step. However, when I try to merge these it only joins the percentiles of datasetB to the first row of datasetA. Is there an easy way to do this?

Thanks in advance,

peat

Re: Merge or append?

Reeza — Wed, 12 Aug 2015 15:56:33 GMT

I think it's like this:

data have;

if _n_=1 then set percentiles;

set data;

run;

Here's a reference if you want several other options:

http://www2.sas.com/proceedings/sugi28/103-28.pdf

topic Re: Merge or append? in SAS Procedures

Merge or append?

Re: Merge or append?