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
- 5619 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 are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
How you can read the variables that you need?
I have a dataset with variables empid and doj how to calculate retirement age?
For clinical entire study how many tables will create approx?
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.
i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.
how many types prompting framework can be broken down to? : Sas-bi
Do you need to rearrange the order of the data for the report?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?
Teradata 
