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
- 5608 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
how do the in= variables improve the capability of a merge? : Sas programming
Mention some common errors that are usually committed in sas programming.
how sas deals with business intelligence? : Sas-bi
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how will you locate the sas platform applications? : Sas-bi
What are the ways to do a “table lookup” in sas?
what is the difference between unique key and primary key? : Sas-di
What is PROC in SAS?
what are informats in sas? : Sas-administrator
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What are the automatic variables for macro? : sas-macro
explain about data integrator metadata reports? : Sas-di
What is run-group processing?
Name types of category in which SAS Informats are placed?
