About janpeter

janpeter · ‎09-29-2022

Hi Allan, thanks for the valuable information. I will use this going forward. The question was more whether you can pull information from one server to another and demonstrate that it has integrity. The generic question is on any file format. This specific is for sas7bdat. I would argue that you would spot if something is of fairly fast if you work with the file since it would probably display "weird" characters or not import at all for that matter. Appreciate your quick answer though. BR jan

janpeter · ‎09-29-2022

Hi SASKiwi, thanks for letting me know about the community. I will probably follow up there. The issue is not compatibility. Regardless of platform. Let's say the case is that you have a repository on one server.. 1. You pull down as sas7bdat file from it. 2. You open it on your platform on a different server Can you be 100% certain that the information you see is the same as in the repository? More background. The same question would apply to xpt files. Can you be certain that if this was xpt that you have the same data? i would argue that sas7bdat is more robust than xpt given the encoding and multiple metadata levels. Anyway thanks for your reply. Appreciated. BR Jan

janpeter · ‎09-28-2022

Hi, not sure this is the right place to ask the question but i'll try. If you have a sas7bdat file on a secure location and pull it down (from one server to another) with some file transport tool. What is the chance that a variable can change content without the user picking up on it? For example if it's numerical value it changes from 5 to 99.234. If it's a character variable it changes from 'ABC' to 'mike'. Note that the data is straight forward ASCII. One way of ensuring the file is the same is to check the md5 sum before and after for example. But i would argue that if you have a scenario where the file is somehow corrupted you would pick it up just by looking at it, i.e. it would be immediately apparent due to strange characters etc.. This would be due to encoding and all the metadata in the format. Am i wrong? If i am what is the likelihood of this occurring? BR Jan

janpeter · ‎06-08-2020

thanks Chris, br JP

janpeter · ‎06-08-2020

Hi Cynthia, sorry for the very late reply. Thank you for your answer. it looks promising. I would guess that this also works for docx? currently i have it as preproduction in my SAS version but it will most likely be the standard to go with in the future. BR jan

janpeter · ‎02-17-2020

Hi my question is whether there is a way to collect existing files (txt, png, rtf etc) into a word document (docx) and create a TOC? Building a docx file from scratch is a possibility but if SAS already has this functionality then it would be good to be aware of it. The desired output (docx) should contain the files according to a pre defined order. ex Table 1 ... Table 10, Graph1, Table11 - Table13, Graph2 - Graph5, ... So running the programs in a given order using ODS is not practical as there can easily become hundreds of them. BR Jan

janpeter · ‎06-12-2019

Sorry i was too fast. I of course meant to write Tom Thanks Tom!!! 😉 BR J

janpeter · ‎06-12-2019

Hi Reeza, that certainly did the trick. Thanks a lot! Yes. I was considering Python as an option but prefer to keep it all in SAS. BR Jan

janpeter · ‎06-12-2019

Hi, im trying to read a large non delimited text file into a dataset. Im using PC SAS 9.4. The file is the document.xml part from a docx file. It does not seem to be possible to read it into one variable and one row in a dataset since it is too large (>300kb). I was thinking that one way of doing this is to pre process the file by reading it character by character and add a CR (carriage return) every time i see a '>'. Then output it and re-read it by using proc import with CR ('0D0A'x) as a delimiter. Can this be done. If yes then how? BR Jan p.s. note that reading the file with a XML libname is not useful here.

Online Status	Offline
Date Last Visited	‎09-29-2022 04:54 AM

Re: stability of sas7bdat format

Re: stability of sas7bdat format

stability of sas7bdat format

Re: Collecting existing files into a word document in a given order

Re: Collecting existing files into a word document in a given order

Collecting existing files into a word document in a given order

Re: read a text file character by character on the fly

Re: read a text file character by character on the fly

read a text file character by character on the fly

Re: read a text file character by character on the fly

Re: stability of sas7bdat format

Re: read a text file character by character on the fly

Re: stability of sas7bdat format

Re: stability of sas7bdat format

stability of sas7bdat format

Re: Collecting existing files into a word document in a given order

Re: Collecting existing files into a word document in a given order

Collecting existing files into a word document in a given order

Re: read a text file character by character on the fly

Re: read a text file character by character on the fly

read a text file character by character on the fly