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
- 5718 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 program data vector? : Sas-administrator
Explain what Proc glm does?
Tell e how how dealt with..
what is proc Index? and what is proc document?
what are validation tools that are used in sas? : Sas-administrator
In sas, what are the areas that you are most interested in? : sas-grid-administration
what techniques and/or procs do you use for tables? : Sas programming
Name some categories in sas 9? : sas-grid-administration
What is the role of administrative users? : sas-grid-administration
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
If a variable contains only numbers, can it be a character data type?
what is transformation in sas data integration? : Sas-di
Difference between SAS STATA & SPSS?
Describe the ways in which you can create a macro variable?
What are the default statistics that proc means produce?
