BookmarkSubscribeRSS Feed
NewmanChow
Fluorite | Level 6

Hello,all:

When I use XML Engine to read and wirte a xml file.I found the issue.

libname test xml "xmltest.xml";
DATA a;
  X="2:2:1";
  output;
  X="3:3:1";
  output;
Run;

DATA test.a;
  set a;
run;

data b;
  set test.a;
Run;

libname test clear;

X in a is Character,X in b is DateTime.

Any options can retain the X as character in b?

2 REPLIES 2
Cynthia_sas
SAS Super FREQ

Is this an article or a question? If this is a question, then it doesn't belong here. Also, if this is a question, you have 2 objects named "a" -- you have the SAS dataset WORK.A and you have the TEST.A XML file that you create with the XML libname engine. In your "article" you say that "X in a is Character, X in b is DateTime". When you refer to just a, I think of WORK.A -- do you mean that X created in WORK.A is character??? Where is the rest of your article???

cynthia

PS...have you tried a LENGTH statement when you create WORK.B???

data b;

  length x $5;

  set test.a;

run;

NewmanChow
Fluorite | Level 6

Hi,Cynthia:

    This is a question. Sorry,I didn't pay attention to make sure It's a Article or Querstion .Can It be modified to correct?

'X in a is Character' which 'a' is WORK.A .

I tried your advice but got a error:

ERROR: Variable x has been defined as both character and

       numeric.

Sorry , again.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 705 views
  • 0 likes
  • 2 in conversation