topic Re: How to get the content of the SAS7bdat file with variable name of more than 8 Characters in SAS Programming

How to get the content of the SAS7bdat file with variable name of more than 8 Characters

Mathan — Wed, 11 Jan 2012 12:45:36 GMT

Hi,

I need to get the property (content/Variables View) of *.SAS7BDAT files which consist of variable names of more than 8 characters.

when i tried the below code i'm able to get the xml from all the other sas7bdat files (where their variable names in that sas7bdat file is of maximum 8 characters only).

CODE :

ods xml file="C:\Users\sas\Desktop\text2.xml";

proc contents data='C:\\Users\\sas\\Desktop\\SAS\\cal_sample.sas7bdat' out=contents DETAILS;

run;

ods _all_ close;

In this 'cal_sample.sas7bdat' file its variable name length is of max 8 characters only, so i got the expected test2.XML as output and i proceessed it to get my output.And i can not get that expected XML for other files with more than 8 characters as its variable name.

I'm new to SAS and i knew few thing only about it. I'm in Need of help!!!

Re: How to get the content of the SAS7bdat file with variable name of more than 8 Characters

Tom — Wed, 11 Jan 2012 13:32:37 GMT

It works fine for simple test that I did.

Not sure why you would want the print-out from PROC CONTENTS as XML.

Why don't you export the dataset output by the proc as an XML file? That would not have the confused format needed to convert it to listing.

libname out xml '~/test/contents.xml';

proc contents data=sashelp.class out=out.contents noprint ;

run;

libname out clear;

Re: How to get the content of the SAS7bdat file with variable name of more than 8 Characters

LarryWorley — Wed, 11 Jan 2012 14:01:00 GMT

Mathan,

Can you provide a copy of your sas log when you have this issue? Also can you provide a copy of one of the problem data sets?

Both of those would be very helpful for tracking your problem.

thx:-)

How to get the content of the SAS7bdat file with variable name of more than 8 Characters

twocanbazza — Wed, 11 Jan 2012 20:23:38 GMT

Have a look at the sashelp dictonary tables should contain information that you need to process this...

Barry

Re: How to get the content of the SAS7bdat file with variable name of more than 8 Characters

Mathan — Thu, 12 Jan 2012 07:09:14 GMT

Hi Tom,

I'm totally new to SAS and after long R&D i tried with that code. And my hearty thanks to you. Where this is the one what exactly i'm looking for it....

Happy thanks Tom!!!

Mathan