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
- 5772 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 difference between (a-z) and (a--z)
how to delete the duplicate columns permanently in SQL
define table lookup and how may ways it can be done...explian
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
When merging 2 datasets with a common variable (not merge key), how to keep both?
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
How do you add a prefix to some or all variables in a dataset using a SAS macro?
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
What are the scrubbing procedures in sas?
Write a SAS macro to calculate number of numbers in an email address
Teradata 
