In SAS how to read the variable values having different
formats.
eg:mar99,mar1999 (in a single variable)
Answers were Sorted based on User's Feedback
Answer / sankar
data ss;
input name$ s anydtdte9.;
cards;
sankar mar99
mahesh mar1999
run;
proc print data=ss;
format s date9.;
run;
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / poornima
To read the data with mar99 and mar1999, we use eurdfmyw.
informat.
This informat is used to read the data with only month and
year.
eg:
data m;
input n date eurdfmy7.;
format date eurdfmy7.;
cards;
12 mar99
45 mar1999
45 sep98
run;
proc print data=m;
run;
Is This Answer Correct ? | 10 Yes | 3 No |
Answer / chiranjeevi
data code;
input name$ dob monyy7.;
cards;
a mar99
b mar1999
run;
proc print data=code;
format dob monyy7.;
run;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shaik
data m;
input n date monyy7.;
format date monyy7.;
cards;
12 mar99
45 mar1999
45 sep98
run;
we will get output;
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / vijay
for the informats/formats in the question i.e. DATEw.
ones.. we can use the above 2 informats
if the data is in MMDDYYYYw. fashion use EURDFDTw.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / svm
For Date Time check here,
http://www.sfu.ca/sasdoc/sashtml/lrcon/zenid-63.htm
Is This Answer Correct ? | 1 Yes | 0 No |
How are the analysis data sets structured?
what is the difference between the SAS v8 and SAS v9?
Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
What is slibref?
Mention the validation tools used in SAS?
Can you excute a macro within a macro? Describe.
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
How do you add a number to a macro variable?
Do you think professionally?
What is criteria for adverse events and treatment-emergent adverse events?
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,