Interested to Buy Any Domain ? << Click Here >> for more details...
In SAS how to read the variable values having different
formats.
eg:mar99,mar1999 (in a single variable)
- 8 Answers
- 21636 Views
- GSK GlaxoSmithKline, I also Faced
- E-Mail Answers
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 |
SAS System ?
what is in stream data in SAS?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
Explain the main difference between the sas procedures and functions? : Sas-administrator
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
what is the use of LRECL option.
Describe the function and untility of the most difficult SAS macro that you have written.
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
How would you code a merge that will keep only the observations that have matches from both sets?
how can u create zero observation dataset?
Name few SAS functions?
Teradata 
