About jerry898969

jerry898969 · ‎11-11-2014

Hello, I'm looking at a piece of code a previous program wrote and I'm stuck on what seems like a very simple piece of code but I can't seem to figure out what it is doing. I have 2 tables with the same list of people ids from two separate years. Each row can have up too 3 phone numbers for that person per year. In this code it's merging the two tables by the person id and an array is created for the set of variables from each year. My issue is what is happening in the do loop? Is it just setting the first array equal to the second array? data phone length pid id_a id_b phid1_a phid2_a phid3_a phid1_b phid2_b phid3_b 8 ; merge line_1 (rename=(ID=ID_A PHID1=PHID1_A PHID2=PHID2_A PHID3=PHID3_A)) line_2 (rename=(ID=ID_B PHID1=PHID1_B PHID2=PHID2_B PHID3=PHID3_B)) ; by pid ; array phna {*} phytype_a phone_a ext_a listed_a ; array phnb {*} phytype_b phone_b ext_b listed_b ; do i = 1 to dim(phna) ; phna(i) = phnb(i) ; end ; run ; Thank you for any help.

jerry898969 · ‎09-19-2014

Thank you so much for your help. I was able to get it working and I changed some of the code based on your suggestions. Thank you

jerry898969 · ‎09-19-2014

Hello, This is the code I'm currently using and it seems to work good. I'm splitting strings longer then 200. data TempText ; length textLen cRows startPos 8. TextRows $250 ; set Temp ; textLen = length(testtext) ; cRows = int(textLen / 200) + 1 ; do i=1 to cRows ; startPos = ((i - 1) * 200) + 1 ; TextRows = "'" || tranwrd(trim(substr(testtext, startPos, 200)),"'","''") || "'" ; output ; end ; run ; Do you see any future issues with this approach? Thank you

jerry898969 · ‎09-19-2014

Hello, My process generates sas files for my users based on the variables they select. Based on those variables I pull the formats and create the file. The user does not get the actual data i'm using for my formats they only see the format file. I did find if I split the long sting at the 200 character mark and put the rest on the next row that it works. proc format ; value testing 0 = 'The is a "test". Some of my strings have double quotes.The is a "test". ' 'Some of my strings have double quotes.The is a "test". Some of my strings have ' 'double quotes.The is a "test". Some of my strings have double quotes.The is a "test". ' 'Some of my strings have double quotes.' ; run ; My issue now is how can I automate this process to split the string based on a length? I appreciate all your help.

jerry898969 · ‎09-19-2014

Thank you both for your quick reply. What my process is doing is it is pulling data from a formats table that lists the code value and text values for a variable that is selected by the user. This will create a proc format statement like this proc format ; VALUE Testing 1 = 'TEST 1' 2 = 'TEST 2' 0 = 'The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.' ; run ; It can be from 1 to over 1000 formats. It's when I'm running this proc format that the warning appears. How would I edit this proc format to correct it? I can't split the lines since it would make some of the files very large. Thank you again for your help

jerry898969 · ‎09-19-2014

Hello, I have a process that creates proc format statements for my data. For some of the formats I get this warning: "The quoted string currently being processed has become more than 262 characters long". I know I can use OPTIONS NOQUOTELENMAX to suppress this warning, but I want to know if there is any effect on the formats. I have users who will be creating data sets and will be generating proc formats and I have to make sure it is all correct. Here is an example: data _null_; x='The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.The is a "test". Some of my strings have double quotes.'; run; The variable x is one continuous string within sas. Thank you

jerry898969 · ‎08-21-2014

jwillis, Thank you so much. That is a great idea. I will try that out. Another thing I was going to try was to limit the number of rows to 100 and at least that would tell me something is wrong and I can get an idea of what the situation is. Thank you

jerry898969 · ‎08-21-2014

Hello, I have a process that will send me an email if there are errors found in a log file. It has been working fine until the other day when I didn't receive the email. When I checked the data was incorrect but I didn't get to see the log because the file overwrites itself. The issue that the email didn't go out is that the length of the message was really large. I'm using code similar to this code: options emailsys=smtp emailhost=test.smtp.com emailport=89; filename mymail email "test@test.com" subject="TEST ERROR"; data _null_ ; set DataDump ; file mymail ; put ErrorText ; run ; I want to put checks in so the message will not exceed this size so I can still see that there are issues and check the log right away. Thank you.

jerry898969 · ‎07-02-2014

Thank you so much Tom. Using pathname function on the work library and pointing to the data file was exactly what I needed.

jerry898969 · ‎07-02-2014

I have a 3rd party tool that can export data into any format I want. I'm trying to use the x command statement to execute this process. The issue i'm having is that the data set is part of my sas session and does not exist on the local computer. Can I pass this data set to this process through x command or do I have to save off the data set then access the data through the x command statement? example code: options noxwait ; x 'C:\PROGRA~1\DataTrans\dt.exe work.temp c:\temp\temp.xlsx'; Thank you

jerry898969 · ‎06-10-2014

I'm doing the following proc export on a SAS 9.3 64-bit TS1M0 server version. I'm using the pc file server. I was unable to create an xlsx file so I read that it has to be an xlsb file. But when it generates it always goes to the last row of data but you can't see that row. I have to scroll up to see any data at all. Is there an option to correct this? proc export data = test outfile="d\test.xlsb" replace dbms=excelcs ; run; Thank you

jerry898969 · ‎06-09-2014

Hi Reeza, here is some test code i'm using to create a pdf file. How can I use this to create a text file? ods listing ; title; footnote ; options orientation=portrait topmargin=1in bottommargin=1in rightmargin=1in leftmargin=1in pageno=1 ; options nodate nonumber nocenter ; ods listing close ; ods escapechar='^' ; ods pdf file = "c:\temp\temp.pdf" notoc ; footnote1 j=c height=8pt font='Courier New' 'Page ^{thispage} of ^{lastpage}' ; data _null_ ; set vinfo ; by year ; if _n_ = 1 then declare odsout obj() ; if first.vname then do ; obj.table_start(overrides: 'frame=void rules=none cellpadding=0in cellspacing=.06in ' ) ; obj.body_start() ; obj.row_start() ; obj.format_cell(text: vlabel, column_span: 2, overrides: "cellwidth=6.5in backgroundcolor=white just=left fontweight=bold font_face='Courier New' font_size=10pt ") ; obj.row_end() ; end ; if last.vname then do ; obj.body_end() ; obj.table_end() ; end ; run ; ods pdf close ;

jerry898969 · ‎06-09-2014

Hi Reeza, Thank you for the reply. I'm using odsout with a data _null_ statement. So i'm creating a table and rows with my data and it looks good in a pdf file. I want to show the data in a .txt file with the same spacing between the columns and rows without the formating other then justification. I can't use RTF even though that works because we have users from all over the world and we have to put the data in the lowest know format so that is a text file for us. Thank you for your help

jerry898969 · ‎06-09-2014

Hello, I have a pdf file that i'm working to create using ODS PDF and ODSOUT. I have part of that working correctly. I would like to take the same out that I have for the pdf and just point it to a text file. Is this possible with ODS or do I have to go through putting put statements and spacing the data out? Thank you

jerry898969 · ‎06-05-2014

Hi Cynthia, Thank you for your reply. When I run this code I don't have any links on my PDF other then the bookmarks on the left side panel. I did just put in a request to tech support. I apologize for all my varying questions. Thank you for all your help.

Online Status	Offline
Date Last Visited	‎05-17-2021 12:05 PM

ODS PDF knowing how many rows before page break

Re: Proc GINSIDE Optimization

Re: Two-way freq doesn't show the variable names when displayed

Re: Two-way freq doesn't show the variable names when displayed

Two-way freq doesn't show the variable names when displayed

Re: Use different select value in proc sql based on variable

Use different select value in proc sql based on variable

Re: Right arrow character causes problems only when logging with proc ...

Right arrow character causes problems only when logging with proc prin...

Re: Break up string using count function and how to loop through it

Re: seach text file based on obs in data table

Re: create data rows depending on value in column

Re: create data rows depending on value in column

Re: Add leading zero based on the number of numbers for that value

Re: Add leading zero based on the number of numbers for that value

Creating Macro variables based on min max of id field

Creating Macro variables based on min max of id field

ODS PDF knowing how many rows before page break

Re: Two-way freq doesn't show the variable names when displayed

How to check if server is configured as a unicode server

Looking for help with what code is doing.

Re: Getting quoted string warning with a format definition

Re: Getting quoted string warning with a format definition

Re: Getting quoted string warning with a format definition

Re: Getting quoted string warning with a format definition

Getting quoted string warning with a format definition

Re: Max length of email message

Max length of email message

Re: X command accessing work data set

X command accessing work data set

Proc export to xlsb always opens to the last row and it looks like she...

Re: Create a text file based on ODS out in a data _null_

Re: Create a text file based on ODS out in a data _null_

Create a text file based on ODS out in a data _null_

Re: How to create a link and an anchor using ODSOUT and ODS PDF