Hi, We have about 1,600 xml files with different map to be read into SAS. It is extremely painful to run the XML mapper manualy and then use Libname XML to import into SAS. Is there any macro sample that can run batch  XML mapper and XML engine to sutomate the import of these XML files ? or there are other better idea ? Thanks for all your help ! David ... View more

Hi, I need to read in a zipped encrypted file in Unix using the following filename statement: filename inf 'gzcat /..../ .zip' pass=" " ; data test; infile inf ; input..... ;; run; SAS give an invalid option error. Do anyone has any idea how to read the file into SAS without manually unencrypt/unzip the file ? Thanks ... View more

Hi, Do you know what is the SAS function or routine that can convert a string such as 7.8E+5 or 000078E-5 into the correct numeric values with decimal places? I tried the EXP function but the base values already defined e. Thanks Kwok ... View more

I try to do a quick and dirty extract of portions from a huge flat file and write out to another file with the same position using the following code. DATA ONE; INFILE INF TRUNCOVER; INPUT VAR1 $ 127-165 VAR2 $ 265-434 VAR3 $ 457-507 VAR4 $ 527-597 VAR5 $ 660-860 VAR6 $ 861-1060 VAR7 $ 1061-1207 ; RUN; DATA _NULL_ ; SET ONE; FILE OUTC ; PUT VAR1 127-165 VAR2 265-434 VAR3 457-507 VAR4 527-597 VAR5 660-860 VAR6 861-1060 VAR7 1061-1207 ; RUN; However, there is nothing in the output file. Can anyone offer some tips why this is not writing out and how to resolve this porblem, ? Thanks ... View more

Hi All, Is there any way to extract the value of variable lable and convert to the value of a seperate variable within a datastep ? For example, If i want to create a variable label_desc which has the value of the the lable of the corrosponding variable ? Just want to see there is a better way then doing it with proc contents , sorted and then merging back to the dataset. Thanks ... View more