Is there any way to check are there any SAS catalogs and datasets present in a folder ? ... View more

Is there any way to check a variable is holding date value or datetime value ? There are various date and date time formats can be assigned to a variable. So its difficult to know is the variable having date value or date time value. I am doing some processing in my program depending up on the variable datatype (date or datetime). But variables are having different kinds of formats. Can any body suggest me some idea ? Message was edited by: anandbillava ... View more

I am creating a report using proc report which pulls data from oracle databse using proc sql. It takes lot of time when i run it in my local SAS and it crashes when running in Enterprise guide. It gives error saying ERROR: Utility file write failed. Probable disk full condition. or dataset is corrupted. Some of the datasets in this joining has more than 200,000 records. Once the above dataset created from proc sql there are some internal processing required. Some time it crashes during those steps saying dataset is corrupted. Any idea about handling such a big table ? Any tips would be appreciated.. Thanks in advance. Message was edited by: anandbillava Message was edited by: anandbillava Message was edited by: anandbillava Message was edited by: anandbillava ... View more

I have writen a program for SAS to xml conversion and xml to sas conversion. There is a variable which is datetime variable with format ddmmyy10. Converstion of this dataset to xml works fine and the values stored as below 1943-12-11 But while reading back this XML to SAS dataset the datetime variables are converted as missing value. libname out xml 'C:\temp.xml'; data out.temp; set temp; run; Reading back to XML libname in xml 'C:\temp.xml'; data temp; set in.temp; run; The resulting dataset has datetime varialbe as missing values. libname out xml 'C:\temp.xml'; It does work when i set the datetime variable to is8601da10 format while converting it to XML. Conversion back from XML does not require any change in code. format xfer_date is8601da10.; But I have lot of datasets and I am wrting a dynamic program which converts all the sas datasets at one shot to different xml files. So I am not sure which are all the datetime formats there in the sas dataset. Is there a way to set the sas date format globally to is8601da10 format.? Or is there any better solution for this ? ... View more