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
- 5623 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
Do you need to know if there are any missing values?
what versions of sas have you used (on which platforms)? : Sas programming
why is sas considered self-documenting? : Sas programming
what are the categories that sas informats are used to the place the data? : Sas-administrator
what is metadata? : Sas-bi
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Mention what is the difference between nodupkey and nodup options?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
what are the best practices to process the large data sets in sas programming? : Sas-administrator
what are the types of interactive display types? : Sas-bi
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
what is star schema? : Sas-di
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What are the different servers in sas? : sas-grid-administration
What is the work of tranwrd function?
