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
- 5168 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 the SAS data set?
what is the difference between %put and symbolgen?
what is AE onset date and what is RDS?
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
What does PROC print, and PROC contents do?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
Which are SAS Windows Clients & SAS Java Clients
Name types of category in which SAS Informats are placed?
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
What statement do you code to tell SAS that it is to write to an external file?
how to debug and test the sas program? : Sas-administrator
What are the difficulties u faced while doing vital signs table or dataset?
Teradata 
