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
- 4780 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 cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
How would you keep from overlaying the a SAS set with its sorted version?
Describe the ways in which you can create macro variables?
what is sas data set?
Which statement does not perform automatic conversions in comparisons?
Compare sas with other data analytics tools.
Define run-group processing?
What sas features do you use to check errors and data validation?
why is sas data integration studio important? : Sas-di
SAS using companies in chennai
In the flow of DATA step processing, what is the first action in a typical DATA Step?
how many types prompting framework can be broken down to? : Sas-bi
Teradata 
