About AlexMoreton

AlexMoreton · ‎02-06-2018

Thank you Art! That worked!

AlexMoreton · ‎02-05-2018

RW9, Sorry about this name="Raynauds_Disease_Display" total="" alreadySet="false"/ The characters in bold would be the part 2. So it begins as " total=""" So I need the space. If I use +(-1) in Put, it takes away the space. and it becomes "total= Which makes it into one whole word. But some other cases, the split would be a word, so it might be to tal. which I need to put together without the space... I hope this is enough information. Thank you

AlexMoreton · ‎02-05-2018

data tags; set work.complete end=last; lrecl=90000; put part1 part2 part3 part4 part5 part6 part7 part8 part9 part10 part11 part12 part13 part14 part15; run; RW9, this is the code. The string is actually an interview so the space in some of the parts are actually needed otherwise it would just mess up the variable names in some cases. Or makes it a weird answer. This is why... Thanks!

AlexMoreton · ‎02-05-2018

Hi all, I have been trying to join up (concatenate) a series of strings(5) for 100 observations. some of the strings begin with a space. EG. " A" However, when I concatenate it with put: data A; set B; lrecl=900000 put part1 part2 part 3 part4 part5; run; So if part1 = "A" part2= "B" etc. to part5="E" one of the parts will have a space as beginning. Such as "AB CDE" Ideally i want it to be ABCDE, but if there is a space as beginning I need it to be there. such as ABC DE. So far if I use put part1 +(-1) part2 +(-)..... part5; it removes an awkward space that separates the strings but Then it becomes A B C D E, which isnt what I want. but if I remove the +(-1), it just becomes ABCDE even if there IS a space. Any ideas? I have thought on using an IF statement. If part1 begins with " ", Then add another space. So then only one space will be removed? Thank you. Also I really need to join them up but I'm just stuck in this dilemma on the code fixes one problem but causes the next.

AlexMoreton · ‎01-30-2018

Hi all, I've been going through my data and realized that I have " • " scattered in my strings... I have been trying to get rid of it via TRANWRD. But it just makes no difference... I then used translate to translate it to my other characters, no changes at all but no error in my log... does anyone know how to remove it? Thank you

AlexMoreton · ‎01-30-2018

Thank you RW9, I played around your code and I managed to get it to do exactly what I wanted. Thank you filename alex 'X:\ALEX TESTING\TRY5.xml'; data tags; set work.complete end=last; file alex lrecl=90000; if _n_=1 then do; put "<Hi>"; end; put Interview; if last then put "</Hi>"; run; I'll accept your answer as the answer but this is just in case you wanted to see.

AlexMoreton · ‎01-30-2018

Thanks RW9, output's not really complicated, I just need to add a tag in front and after the end of the total dataset at alex.interview. Then I can export it and it should be readable on XML Notepad etc. It's just right now I don't know how to do so... the output is basically the same except it will have a new tag in front and at the end of the dataset. which would be <hi> </hi>. Is this not really a good idea to do so? because basically I have rows with the same tags <interview> </interview>. So I just need to create a new tag to become the new root. Thanks for the advise though! I'll keep trying because it feels like I'm only one step away from making this (which I can do manually, but I just think there HAS to be a code for this). Thank you RW9

AlexMoreton · ‎01-30-2018

Hi RW9, I forgot to add in the FILENAME line in the beginning which would have created it into a xml file. I know that the XML files have that format in which it has those things at the beginning. Which makes me think, should I try and create the tags in a data step that i set alex.interview and just actually add <Hi> before _INTERVIEW_ and </Hi> after it? would that be a possible way? Thanks for the help so far!

AlexMoreton · ‎01-30-2018

Hi all, Thanks to help in this community, I was able to extract a super large file from a SQL database and export it into XML format (required by my teacher). I was able to get each row's value (in string) and concatenate them into one file to be read. Right now I'm trying to get it to be read by a XML reader such as XML Notepad. However, as each row has the same root tag, I need to create a new tag So right now i have many strings with the same root tag. <Interview>Row1</Interview> <Interview>Row2</Interview> <Interview>Row3</Interview> Once I add a tag before them it can be read, but I would like to be able to just code for it to do so automatically. to look like this: <Hi> <Interview>Row1</Interview> <Interview>Row2</Interview> <Interview>Row3</Interview> </Hi> As for the code I simply just used this: data Complete; file alex lrecl=90000; set Alex.Interview; *this library already had all the rows in the database and only has one variable which is the interview which I want to merge and become one ; Run; I know the code is basically useless but right now I dont really know what to do... This DOES create one XML file that has all the contents I want in it. But it lacks the tag so XML reader can read it. Thank you

AlexMoreton · ‎01-30-2018

Hi all, I have a dataset like this (obviously i have more than 4 rows though), 1 abc 2 def 3 ghi 4 jkl I want to turn it into 1 abcdefghijkl I've tried using a put function but for some reason i end up with abc . def . ghi . jkl . This is still a string, but just each row is now a paragraph instead, with a weird dot to show the row's end. I would like to remove that and just have the content of the variable from each row to concatenate and become one whole string. Also the data is alphanumeric as it wouldve been A-Z1-100. If anyone has any idea please help.

AlexMoreton · ‎01-19-2018

Hi Tom, Thank you very much! Did the trick!

AlexMoreton · ‎01-17-2018

RW9, I know man... But this is an assignment for my class and for some reason these parts must be done via SAS. Apparently then I need to be able to deal with this with more observations (more similar strings). Which I'm not sure if XML editor can be efficient if it has to be done manually while observations are in the hundreds... If i'm wrong please let me know. Thank you. I've downloaded xmlnotepad to have a go already.

AlexMoreton · ‎01-17-2018

Hi, I am trying to remove a part of text in my xml file. As it is a massive string, I will just show a part of it. I wanted to remove the characters in BOLD so it just looks like this: <Row > <Cell <Data ss:Type="String"><interview><rulebook><name>ALE_UW</name><version>ALEX UW - 1.1</version></rulebook><createdDate>2017-10-23 13:51:30.554 TURN IT INTO <interview><rulebook><name>ALE_UW</name><version>ALEX UW - 1.1</version></rulebook><createdDate>2017-10-23 13:51:30.554 The code I have for it right now (i got it from the internet) looks like this: data Replace ; FILE "D:\XMLCol_Replace.xml" RECFM=N; infile "D\XMLCol_TRY.xml" RECFM=N; input VAR1 $CHAR1. @; IF VAR1 eq '<Row > *this is a carriage return which needs to be deleted too; * it only has one variable (which is the string itself); <Cell <Data ss:Type="String">' THEN input VAR1 $CHAR1. @; *end; put ''; *end; *else PUT VAR1 $CHAR1. ; run; I'd appreciate any pointers, thank you.

AlexMoreton · ‎01-17-2018

Ballard thank you so much! The first code works perfectly! Thank you very much! One quick question, after viewing the new xml file, I realized that the code also generate some extra stuff. <Row > <Cell <Data ss:Type="String"> </Data></Cell> </Row> Is there any way to remove them within the code you have provided or should I just remove them through another code or manually? Thank you for everything you've done so far!!

AlexMoreton · ‎01-16-2018

Hi Ballard, Thank you! I'm sure the code works but unfortunately, the total number of characters in the alex variable will end up being 80700 characters... therefore even though there was no error, no records were written into alex. I think it's because it is too large. therefore basically i can only try and write a code for SAS to just combine the variables and not have any carriage rows because when I copy the variables (texts) by themselves and paste it to word, none of them had carriage rows. So it must be something to do with the export function. Is there any ways to overcome this? Cos I need to combine them together into a xml file (i managed to do so but have LOTS of carriage rows) but the total number of characters is too large for SAS (33000 or so is the limit).

Online Status	Offline
Date Last Visited	‎02-09-2018 10:43 AM

Re: Does • exist?

Re: concatenating but space is removed

Re: concatenating but space is removed

concatenating but space is removed

Does • exist?

Re: creating a root tag for XML

Re: creating a root tag for XML

Re: creating a root tag for XML

creating a root tag for XML

how to join observations into one string?

Re: Does • exist?

Re: creating a root tag for XML

Re: removing texts in a string with infile file

Re: Concatenate during an export

Re: Count everything in the string with countc

Re: Does • exist?

Re: concatenating but space is removed

Re: concatenating but space is removed

concatenating but space is removed

Does • exist?

Re: creating a root tag for XML

Re: creating a root tag for XML

Re: creating a root tag for XML

creating a root tag for XML

how to join observations into one string?

Re: Concatenate during an export

Re: removing texts in a string with infile file

removing texts in a string with infile file

Re: Concatenate during an export

Re: Concatenate during an export