Help using Base SAS procedures

Adding a column with different values

Reply
New Contributor
Posts: 3

Adding a column with different values

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

Respected Advisor
Posts: 4,659

Re: Adding a column with different values

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.

PG

PG
New Contributor
Posts: 3

Re: Adding a column with different values

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

New Contributor
Posts: 3

Re: Adding a column with different values

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

Ask a Question
Discussion stats
  • 3 replies
  • 243 views
  • 0 likes
  • 2 in conversation