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
- 5607 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 |
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
what is sas data set?
For what purposes have you used sas macros? : sas-macro
How do dates work in sas?
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
What are the functions done while Compilation...?
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
How would you define the end of a macro?
diff between nodup rec and ondup key???
how do u test a pros sql(works or not) without executing it?
How to write duplicate records into a separate dataset using sort?
describe how to adjust the performance of data integrator? : Sas-di
Teradata 
