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
- 21087 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 |
Why and when do you use proc sql?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the role of administrative users? : sas-grid-administration
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
How do you put a giraffe into the refrigerator?
How would you compile all macros from a folder in a study, within the autoexec program?
what is sas metadata server? : Sas-di
How do you specify the number of iterations and specific condition within a single do loop?
what are scrubing procedures in SAS?
What is the difference between nodupkey and nodup options?
Give e an example of..
How to read the file names of a text files from a shared drive using SAS?
Teradata 
