05-24-2021
slb
Calcite | Level 5
Member since
06-23-2011
- 4 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by slb
Subject Views Posted 2722 05-17-2011 03:02 PM 5257 07-03-2008 10:49 AM 5257 07-03-2008 10:47 AM 5257 07-03-2008 10:07 AM -
Activity Feed for slb
- Posted Re: XML Layout file structure on SAS Procedures. 05-17-2011 03:02 PM
- Posted Re: infile errors on SAS Programming. 07-03-2008 10:49 AM
- Posted Re: infile errors on SAS Programming. 07-03-2008 10:47 AM
- Posted Re: infile errors on SAS Programming. 07-03-2008 10:07 AM
05-17-2011
03:02 PM
I'm probably going to ask for the same information that's posted here again. Please forgive me, this is the first I am trying to import an xml file.
1) I am at step one. Here's what I have:
filename xmlinp 'V:\MICHR\Personal\bruestle\Open Clinica Testing\ExportTest1D20110517142141-0400';
proc cdisc model=odm read=xmlinp;
odm odmversion="1.2";
clinicaldata out=results.ae sasdatasetname="AE";
run;
2) If I run the syntax above I get the following message:
ERROR: Physical file does not exist, V:\MICHR\Personal\bruestle\Open Clinica
Testing\ExportTest1D20110517142141-0400.
encountered during CDISCRDR parsing
occurred at or near line 1, column 1
The file really does exist so I'm thinking the problem is more to do with what's in the file, specifically the very first character.
3) Here's the first line of the file:
Can you help me?
... View more
07-03-2008
10:47 AM
Okay, I solved my problem. I didn't have a ' ; ' after the list of variables in the input statement. SAS thought my next line "run;" was another variable without a length and type of variable associated with it.
... View more
07-03-2008
10:07 AM
Can anyone help with the following error? The same error repeats for every other line of data. For the most part it says the invalid data is the length of the character values up to the space. The first variable is $30.
NOTE: Invalid data for run in line 3 1-3.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-
2 ABDR 0.5_12.5_0.5_20 ABDR 0.5/12.5/0.5/20
87 00000000000000 N 77777726724 19970101
173 1010314AWP
259 19990801 20391231 1.89000PLACEBOS
345 ** 1.000
431 0 0.000DummyVar
3 ADV BALANCED NUTR SUPP ADV BALANCED NUTR SUPP
87 00000000000000 21130078170 20000901
173 O 1010314AWP
259 20000901 20391231 0.01000PLACEBOS
345 ** 0.000
431 0 0.000DummyVar
Any ideas?
... View more