How would you code the criteria to restrict the output to be
produced?
Answers were Sorted based on User's Feedback
use _null_ in data statemnet when u dont want to create
dataset.to restrict the output to be produced, close the
ods listing destination and this is default destination
and you can also restrict the output using no print option
in some procs such as means,sql,etc...
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / ganesh
In my view use noprint option to restrict the output to be
produce
data g;
input name$ no sal;
datalines;
a 1 2500
b 2 3500
;
proc print data=g noprint;
run;
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / akilan
In Jothi Sankar's answer,
First Choice is correct.
In second choice instead of 'OUT', have to use 'THEN OUTPUT'
Third choice is not correct one.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / linus
1.obs is one option.
2.in input statement we can restrict the variables we need.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sanjeev
proc sql;
select * from sashelp.class;
quit;
gives you an output.
proc sql noprint;
select * from sashelp.class;
quit;
no errors and output is restricted.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sumalatha.ch
_null_ this is not give any output.and nowid option.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / jothi sankar
--> Using VAR can restrict which varibles have to be output
--> Using differnt data sets for each main condition
Eg:
DATA
MyData2
MyData3
MyData4
;
SET MyData1;
if Dept = 'Computer' OUT MyData2;
else if Dept = 'Electronic' OUT MyData3;
else if Dept = 'Chemical' OUT MyData4;
RUN;
--> Using PRINTEM for viewing datas individually
| Is This Answer Correct ? | 1 Yes | 6 No |
what the use of proc glm
How we can call macros with in data step? : sas-macro
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
What is the function of Stop statement in a SAS Program?
How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?
What is the one statement to set the criteria of data that can be coded in any step?
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
how to remove duplicates using proc sql?
At compile time when a SAS data set is read, what items are created?
Explain what is the use of proc gplot?
Explain the purpose of retain statement.