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
- 4767 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 is the use of catalog?
what is data integration? : Sas-di
wt is a-z and a--z?
How can I remove header from output data set?
what is change analysis in sas di ? : Sas-di
How to convert HTML file into SAS dataset?
What do you feel about hardcoding?
What is difference between sas rename and lable?
How many ways to overcome a missing values???
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
What has been your most common programming mistake?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Teradata 
