Interested to Buy Any Domain ? << Click Here >> for more details...
How do you read in the variables that you need?
- 9 Answers
- 24835 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neeraja
using keep(for selected variables).keep is a dataset
option.the statment keep is used to specify the number of
variables to be remained within a sas dataset or output.
syntax:keep <var list>
data emp;
keep name no;
input name$ no sal job$;
cards;
......
....
| Is This Answer Correct ? | 24 Yes | 2 No |
Answer / murray
I believe it is more efficient to use the KEEP statement on
the input data set, as only required variables are read into
the PDV. This is also true for the WHERE statement.
For small data sets the difference is of course negligible,
however it is always good to practice efficient programming.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / kumaraswamy maduri
Use KEEP or DROP depending on the number of varibales you
require.
Keep: Out of 50 if you require to keep 20 variables it
better to use keep.
Drop: It meaning less to use KEEP when you want to use 35-
40 variables. Its better to drop the remaining variables.
Both mean same but efficient coding is always preffered.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / chiranjeevi
using variable control options.
keep:It decides the no. of variable should remain within the
dataset.
syntax:keep<variablelist>;
example:
data code;
input name$ no sal;
keep name sal;
datalines;
a 32 3000
b 56 7000
c 12 7890
run;
proc print data=code;
run;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / purushotham
I think KEEP option would be the better way to read the
variables that we need. But it's again depends upon how
many number of variables that you want to read from the
input dataset.
Let's say there are 30 variables in data set and you want
to read all the variables except 5 variables from the input
dataset. Then it's efficient to use DROP option to drop
those 5 variables instead of mentioning all 25 variables at
KEEP option.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / aj
Using input statement with column/line pointers,informats and length specifiers.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hitesh
You can read in the variable with INPUT statement.
There are more than 1 ways use input statement.
eg:
input name$ no sal;
...OR you can read selected fields from byte positions at which they appear in the input file.
eg:
INPUT @1 NAME $20.
@21 No 3.
@24 Sal 7.;
| Is This Answer Correct ? | 0 Yes | 1 No |
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
How will you generate test data with no input data?
What is the one statement to set the criteria of data that can be coded in any step?
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
Explain the use of proc gplot? : sas-grid-administration
Mention sas system options to debug sas macros.
define table lookup and how may ways it can be done...explian
Name statements that function at both compile and execution time.
Difference between sum function and using “+” operator?
what is factor analysis? : Sas-administrator
How sas treats the dsd delimiters?
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Teradata 
