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
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
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
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.