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
- 5775 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 |
Name statements that are execution only?
How necessary is it to be creative in your work?
what is information maps?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
how can get the first and last observations in a dataset using Proc SQl?
Which date function advances a date, time or datetime value by a given interval?
Do you know the features of sas?
what is the difference between DUPKEY and NODUPKEY???
What is the maximum and minimum length of macro variable
List out some key concept of SAS
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
how to generate means for every subject;
Teradata 
