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;
......
....

Answer / sheetal

data new (keep = name age sex);
set old;
run;

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.

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.

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;

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.

Answer / aj

Using input statement with column/line pointers,informats and length specifiers.

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.;

Answer / siri

by using 'scan' statement.
scan <variable name>;

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,

how to read character value without using substr function in sas ?

3 Answers  

what is the difference between %put and symbolgen?

6 Answers  

How we will Developing new reports Using Data step programming and Macros ?

4 Answers  

In SAS explain which statement does not perform automatic conversions in comparisons?

0 Answers  

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 Answers  

what is intially documentation in sas?

1 Answers   Accenture,

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers  

Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  

How do you control the number of observations and/or variables read or written?

0 Answers  

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,