The below code we are using for creating more than one
macro variables in proc sql using into clause. How we
can use same code to create macro variables vara, varb,
varc instead of var1, var2, var3.?
proc sql noprint;
select count(distinct(patient)) into :var1 - :var3
from dataset1
group by trtreg1c
;
quit;
- 1 Answers
- 5233 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / gk
ONly Var1 will be assigned based on the distinct patient
count. Var2 & Var3 macro variables will not be created .
We can not use :Vara - :Varc in into clause of select
statement for creating macro variables .Sinxe it is not a
array format.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is by-group processing?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is Difference between PROC SQL JOINS and MERGE?
what is sas application server? : Sas-di
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
What is difference between sas rename and lable?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
How to sort in descending order?
What are the differences between sum function and using “+” operator?
How do you put an elephant in the refrigerator?
What was the last computer book you purchased? Why?
Teradata 
