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

How would you delete duplicate observations?

9 Answers  

where to use sas business intelligence? : Sas-bi

0 Answers  

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

0 Answers  

what is sas enterprise intelligence architecture? : Sas-bi

0 Answers  

For what purpose(s) would use the RETURN statement?

1 Answers  

Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?

3 Answers  

how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 Answers  

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers  

what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?

2 Answers   Accenture, Infosys,

At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,