About ismahero1

ismahero1 · ‎07-16-2020

Hi, I am using XML Mapper engine xmlv2. I am using a map to load 2 or more XML files. I would like to modify the map to have the file name as one of the variables. Any knows how can I get the filenames as part of the variables in my dataset?

ismahero1 · ‎07-16-2020

Hi, I am using SAS XML Mapper engine xmlv2. In the documentation provided by SAS, it says we can have more than one TABLE-PATH in each table. Anyone knows how to do it? Any examples you can provide? Per SAS documentation: The TABLE element can contain one or more of the following elements: TABLE-PATH, TABLE-END-PATH, TABLE-DESCRIPTION, and COLUMN.

ismahero1 · ‎11-21-2019

DATA TOC1 ; INFILE RECIN (THIS IS LOOKING AT THE FILE I AM TRYING TO LOAD) LRECL = 1000000; LENGTH UNQ_KEY $18. RETVER $20.; INPUT @(INDEX(_INFILE_,'')+17) UNQ_KEY $CHAR18. @(INDEX(_INFILE_,'Version=')+15) RETVER $CHAR20. ; IF FIND(RETVER, '"') > 0 THEN RETVER=SUBSTR(RETVER,1,(FIND(RETVER,'"')-1)); NUM_DOCS=COUNT(_INFILE_,' documentId=') ; TEST_LENGTH= LENGTH(_INFILE_); RUN; When I ran the code after adjusting the LRECL I received this error. ERROR: The LRECL / LINESIZE for infile RECIN exceeds the maximum allowable length for an _INFILE_ or _INFILE_= variable (32,767). The DATA STEP will not be executed.

ismahero1 · ‎11-21-2019

Hi, I have a txt file that contains millions of records from an XML file. I am trying to load them to SAS but there are some random records that are longer than 32767. When I load the code, I successfully load all the records but I have problem with those long records present in the file. The txt file in itself is very simple to read and create a code to load, but is the presence of those records that are longer than 32767 that are making me have problems when loading the data. Anyone know how to handle records that are longer than 32767?

Online Status	Offline
Date Last Visited	‎07-16-2020 06:05 PM

XML Mapper Want filename as a variable

XML Mapper Multiple TABLE_PATH

Re: Reading a raw data file with long records

Reading a raw data file with long records

XML Mapper Want filename as a variable

XML Mapper Multiple TABLE_PATH

Re: Reading a raw data file with long records

Reading a raw data file with long records