In SAS how to read the variable values having different
formats.
eg:mar99,mar1999 (in a single variable)

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features included in the new version of SAS Programming Language?

741


What do the mod and int function do? : Sas programming

586


What is Linear Regression?

687


What are the difference between the sas data step and sas procs?

612


Intern stastical programmer written test

288






How do you define proc in sas? : sas-grid-administration

678


explain what is data set in sas? : Sas-administrator

528


I need level 2 to 5 sas using companies in india

1932


Which are the statements whose placement in the data step is critical?

764


how many types prompting framework can be broken down to? : Sas-bi

637


What are the difference between sas functions and procedures?

643


What are all the problems you faced while validating tables and reports?

3016


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1465


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

549


How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2387