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
- 5693 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 |
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
how to generate report for 0 observation dataset?
Name and describe few sas character functions that are used for data cleaning in brief.
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
Can anyone help me about SAS Realtime scenarios in Clinical field
what is the difference between SET and MERGE?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
How would you include common or reuse code to be processed along with your statements?
how does sas handle missing values in sort order? : Sas programming
Teradata 
