Describe how you would pass data to macro.
Answers were Sorted based on User's Feedback
Answer / lakshmi
There are two types of Parameters mainly used to pass a
value for a macro variable.Those are Positional Parameter
and Keyword Parameter regarding on macro variable where we
are creating whether local or globally i.e., inside macro
or outside macro.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chiranjeevi
You use symput to get information from a data step into a
macro variable.
| Is This Answer Correct ? | 1 Yes | 1 No |
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
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 are the Aggregate functions in SQL ?
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
Explain proc sort?
how to know the attributes of first five datasets in a library
Differentiate between sas functions and sas procedures.
How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.
What is the difference between nodupkey and nodup options?
What data sets do you need to produce the report?
IS SAS COMPILER OR INTERPRETER? EXPLAIN?
3 Answers Aon Hewitt, HSBC, SCL, TCS,
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?