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
- 4783 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
explain the difference between proc means and proc summary?
What is the order of application for output data set options, input data set options and SAS statements?
What are the difficulties u faced while doing vital signs table or dataset?
What is the basic structure of the SAS base program?
What is the use of PROC gplot?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
Differentiate between sas functions and sas procedures.
What makes sas stand out to be the best over other data analytics tools?
Mention the validation tools used in SAS?
What is your favorite all time computer book? Why?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Difference between sum function and using “+” operator?
What do the SAS log messages "numeric values have been converted to character" mean?
What are the data types does SAS contain?
What are the features of SAS?
