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
- 5206 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 will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
how can you import .csv file in to sas? : Sas programming
How many data types are there in SAS?
what is sas metadata repository? : Sas-bi
how to do user inputs and command line arguments in sas?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
what do you mean by data staging area? : Sas-di
what is the purpose of _error_? : Sas programming
Explain what is the use of proc gplot?
Mention sas system options to debug sas macros.
What do the PUT and INPUT functions do?
What can be the size of largest dataset in SAS?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What does P-value signify about the statistical data?
Differentiate between proc means and proc summary.
