Answer / ranjith

we can store date values using date format
(ex:date9.,ddmmyyyy10.)

Answer / arish kumar

e.g the date is '05/09/2007'

we can use the input function to convert this string into SAS date i.e.
date='05/09/2007'
sasdate=input(date,mmddyy10.);

Also, we can use mdy function.For this first use substr function.

m=substr(date,4,2);
d=substr(date,1,2);
y=substr(date,7,4);
sasdate=mdy(m,d,y);

Answer / vipin choudhary

We can read the date value with the help of date informats.
Say we have the date 09/13/2008.
Now if we want SAS to read this date, we will use the date
informat in the input statement like
"input date mmddyy10."
SAS will store this date in the numerical form as the
number of days passed from 1st january, 1960.

Answer / geoffrey brent

If you don't know in advance how the date will be
formatted, you can use the ANYDTDTE. informat. This will
extract a SAS date from most date/date-time formats.
(Warning: ANYDTDTE doesn't fully support day-month-year
ordering, even if you have this set as your system
preference, but it still copes with most DMY-formatted
dates.)

Answer / komal

For example if we have a date="14/12/2008".

you have to input it first and the format it like
date1=input(date,ddmmyy10.);
format date1 ddmmyy10.;
run;

Answer / srinivas krishnan

in sas :: we can store like this `12-07-2009`d

Answer / vinay

/*let date is '10/07/1985'/*
/*SAS CODING*/
data date;
input date $;
Var_Date=input(date,mmddyy10.);/*Apply format within input
function to convert text value to number value*/
/*now extract value of month,date and year through date
functions*/
m=substr(Var_Date,4,2);
d=substr(Var_Date,1,2);
y=substr(Var_Date,7,4);
sasdate=mdy(m,d,y);
cards;
10/07/1985
;
run;
proc print dtat=date;
run;

Answer / sheetal

data temp;
date='17/12/2009';
m=substr(date,4,2);
d=substr(date,1,2);
y=substr(date,7,4);
d1=mdy(m,d,y);
format d1 mmddyy10.;
run;

Answer / suresh ganapuram

Actually sas stores dates as numbers

eg:: given date 12-07-2009


in sas :: we can store like this `12-07-2009`d

In PROC PRINT, can you print only variables that begin with the letter “A”?

8 Answers  

How to read the file names of a text files from a shared drive using SAS?

1 Answers   HSBC, WNS,

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  

In sas admin differentiate between roles and capabilities? : sas-grid-administration

0 Answers  

what are _numeric_ and _character_ and what do they do? : Sas programming

0 Answers  

what are the three main credit bureau names

1 Answers   Synchrony Financial,

How would you include common or reuse to be processed along with your statements?

0 Answers  

if we dont want to print output what we have to do..???give syntax..???

8 Answers   Accenture, GSK GlaxoSmithKline,

what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  

How would you code the criteria to restrict the output to be produced?

9 Answers  

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers