topic Re: Help Please Concatenate and interleaving in SAS Programming

Help Please Concatenate and interleaving

nrb — Tue, 22 Nov 2016 05:24:13 GMT

I have attached a screenshot of the question. Please help me figure this out, i'm very lost.

Re: Help Please Concatenate and interleaving

Patrick — Tue, 22 Nov 2016 05:55:30 GMT

1. read the source data using 2 data steps

data table1;

infile datalines ..

input ...

datalines;

your data

;

run;

2. Concatenate

Either use Proc Append or a third data step

3. Interleaving

First sort your data sets by Flavor

Here the detailed docu with code examples of how you can combine SAS data sets

http://support.sas.com/documentation/cdl/en/lrcon/68089/HTML/default/viewer.htm#p15jvywi5avt3cn1bee8r6c33ux1.htm

Re: Help Please Concatenate and interleaving

Shmuel — Tue, 22 Nov 2016 07:27:01 GMT

I'm not sure that I understand the term "cake brand" but you can check next code:

data Duncan;
length flavor $15;
infile datalines dlm=',' truncover;
input flavor $ height;
datalines;
Devil's food ,39
Devil's food ,36.5
White ,30.5
White ,34.5
Yellow , 37.0
Yellow , 35.0
run;

data Betty;
length flavor $15;
infile datalines dlm=',' truncover;
input flavor $ height;
datalines;
Devil's food ,35.5
Devil's food ,36.0
White ,35.5
White ,37.5
Yellow , 32.5
Yellow , 32.5
run;

data all;
set duncan
betty indsname=_dsn;
by flavor;
brand = scan(_dsn,2,'.');
run;

title 'Duncan & Betty results';

proc print data=all;

var brand flavor height;

run;

Re: Help Please Concatenate and interleaving

mkeintz — Tue, 22 Nov 2016 12:29:50 GMT

Duncan Hines and Betty Crocker are two brands of cake mix in the US.
MK