Answer / shah

Four ways to create Macro variables:
1. %Let
2. %Macro(Keyword or Positional Parameters)
3. Proc SQL select into:
4. Call Symput

Answer / kamal sharma

1. %LET
2. %GLOBAL
3. %LOCAL
4. Macro parameter
5. %DO loop index variable
6. CALL SYMPUT / CALL SUMPUTX
7. PROC SQL INTO clause
8. ODS OUTPUT statement using the MATCH_ALL option

Answer / paramatma pulivarthi

there are 5 ways to create macro variable
1.by using %global
2.by using %local
3.by using %let
4.by using call symput
5.by using select and into clause
and
6. by passing the values to macro through the parameters.

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

0 Answers  

---

why a stop statement is needed for the point= option on a set statement?

0 Answers  

---

Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com

0 Answers  

---

which date functions advances a date time or date/time value by a given interval? : Sas programming

0 Answers  

---

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  

---

What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 Answers  

---

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,

---

What sas features do you use to check errors and data validation?

0 Answers  

---

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 Answers  

---

What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

1 Answers   Quintiles,

---

what are all the reports you generated in your recent project?

0 Answers   Accenture, Quintiles,

---

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  

---