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;
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 |
At compile time when a SAS data set is read, what items are created?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
For what purpose would you use the RETAIN statement?
How do i read multiple spaces in datasets?
what is SAS/Access and SAS/Connect?what are the uses?
what are input dataset and output dataset options?
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
what are the differences between proc report and proc tabulate?
What are the parameters of scan function?
who is the best SAS clinical Trainer in Hyderabad?
what is Enterprise Guide?what is the use of it?