What is the pound sign used for the DATA _NULL_?
Answers were Sorted based on User's Feedback
Answer / kranthi arabelly
_NULL_ : specifies that no SAS dataset is to be created
| Is This Answer Correct ? | 20 Yes | 5 No |
Answer / altumish
All the answers provided above are wrong, please read the
question carefully and answer.
BTW-we can use pound sign in data _null_ to read the data
from the specified line.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / rinky
It is just a tricky question to see how we respond. I dont
think it is possible. And the answers above are incorrect
as question is not just about data _NULL_. It is about
having # sign with that which is impossible.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prag s.
we can use _NULL_ for----
reporting purposes
also for modifying a data set
also for not creating a new SAS dataset
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / kumaraswamy maduri
# can't be used
with a data _null_. It's an interview question to confuse.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sreekanth rao
i could not get the question.
can any body detail it.
why the pound sign being used in the question.
are the above ansewers are answering the question
corretly..?
pleas coorect me.
Thnaks
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / murali
data_null_ is a power of datastep without creating a data set
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akash
The _NULL_ DATA step is a specialized case of the DATA step.
When you use the _NULL_ key word, the DATA statement
processes all statements within the DATA step without data
set
creation1.
Some of the uses of DATA _NULL_ are:
To create customized reports with and without ODS. The
reports can be routed to the Output window, directly to a
printer, to an external file, or any destination that can be
defined by the FILE and FILENAME statement.
To create macro variables based on values obtained from
an
input SAS data set or external file.
To create ASCII data (flat) files for importing into MS
Excel,
MS Access or other programs and databases.
To execute special functions or call routines available
within
the DATA step, such as CALL EXECUTE
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sk
Guys, someone has writeen _null_ is used to modify the
datasets. without output dataset how can you modify the
data. Can you please explain.
| Is This Answer Correct ? | 0 Yes | 2 No |
Describe the function and untility of the most difficult SAS macro that you have written.
how do u identify a macro variable
How to read the file names of a text files from a shared drive using SAS?
How do you download a flat file from Mainframe to your local PC using SAS?
What is SAS? What are the functions does it performs?
What is the difference between order and group variable in proc report?
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
what is syntax of proc merge ?
What is the length assigned to the target variable by the scan function?
What report output formats can you generate using SAS?