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
- 5694 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the differnce between SDTM 3.1.2 to 3.1.1 version
what is function of retain statment
If money were no object, what would you like to do?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what is the difference between nodup and nodupkey options? : Sas programming
What areas of SAS are you most interested in?
explain about sas business intelligence? : Sas-bi
What is the maximum length of the macro variable? : sas-macro
how could you generate test data with no input data? : Sas programming
How can you create a macro variable with in data step? : sas-macro
What is a put statement?
What are symget and symput? : sas-macro
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Tell me more about the parameters in macro? : sas-macro
What are common programming errors committed in sas
