topic Re: Adding a column with different values in SAS Procedures

Adding a column with different values

srolash — Sat, 18 Apr 2015 16:04:13 GMT

Hi,

I wonder how we add a vector column with different values in the same data-step?

One solution is to create a document with the vector then merge it with the original document.

But, I'm interested to do it in the same document. Any help is extremely appreciable.

Thanks

Re: Adding a column with different values

PGStats — Sat, 18 Apr 2015 18:09:21 GMT

Vectors and documents are not datastep concepts. As a rule, every variable created in a datastep becomes a variable (or column) in the dataset produced.

Please give an example (Input --> Output) of what you are trying to do.

Re: Adding a column with different values

srolash — Sun, 19 Apr 2015 08:16:35 GMT

Dear PGStats,

Thanks for your prompt reply.

Here's the example: to create a document for a planned study that contains:

- two schools, 50 boys and 50 girls from each school - total 200 pupils.

- for each group (e.g. school 1, 50 boys) to randomly assign a number and sort. The first 25 pupils get treatment and the next 25 pupils get control.

What I've done is as follows:

data a;

do school=1,2; do gender='F','M'; do id=1 to 50;

random=uniform(1);

output; end;end;end;

proc sort; by school gender random;

run;

data b; /*creating a vector of changing group values*/

do temp=1 to 4; do group='C','T'; do temp_1=1 to 25;

drop temp temp_1;

output; end;end;end;

run;

data all; merge a b;

run;

This works fine, but I was asked to do it in one document without merging an external document (I was given a tip of using count+1).

Do you have an idea how to resolve this?

Tremendous thanks

Re: Adding a column with different values

srolash — Sun, 19 Apr 2015 08:32:06 GMT

Dear PGStat,

Actually, I've just found out the answer has been posted elsewhere, so thanks for your help, really appreciate it.

With all my best,

srolash