Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5715 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 |
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
What is the use of PROC gplot?
how to assign a macro value to a variable?
i want to upload titles and footnotes to excel file?how it is possible?
What are the data types in sas?
where to use sas business intelligence? : Sas-bi
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How do you use the do loop if you don’t know how many times you should execute the do loop?
Approximately what date is represented by SAS date value of 730
What is the pound sign used for in the data_null_ ?
How do you specify the number of iterations and specific condition within a single do loop?
Teradata 
