How would you include common or reuse code to be processed
along with your statements?
Answers were Sorted based on User's Feedback
Answer / selvi
We can code the resusable as seperate macro. And will call
into SAS program where ever there is a need.
Macro should start with %macro macroname(), and end with %
mend.
Syntax for call in datastep-%macroname
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / selvi
To add on above one, if you want to include the another SAS
program then use %include with full SAS code path.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / basha
we can use autocall liobrary in macros which includes
options mautosource
syntax creating auto call lbrary
libname statement
filename
catalog
at last
code:libname<filename><catalog><sourcecode>
note:macroname is same as source file name
| Is This Answer Correct ? | 0 Yes | 0 No |
What does a PROC TRANSPOSE do?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
What do you know about sas and what we do? : sas-grid-administration
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?
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
what are different type of sas servers ? On which server does the sas code execute ?
What is the maximum and minimum length of macro variable
What is difference between (a-z) and (a--z)
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?
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
Which is the best training institute for SAS in Delhi. Please reply
is there any difference between proc summary and proc means?