About jerry898969

jerry898969 · ‎09-12-2011

I'm trying to get the individual numbers after the decimal place and i'm not sure how to do it. Say I have .003 I want to pull out the first 0 in d1 and the second to d2 and 3 into d3. Not sure if the mod function would be the way to go or not. Thank you

jerry898969 · ‎08-04-2011

art, Thank you that was it. Jerry

jerry898969 · ‎08-04-2011

I have a table that has a column called keyid. I need to get the min and max of this field into macro variables so I can use them in a where clause against different tables that also have this field. I'm currently doing it like this proc sql noprint ; select min(keyid) into :min_keyid from tblRaw ; select max(keyid) into :max_keyid from tblRaw; quit ; is there a better way to do this? I can't seem to get both variables assigned with just 1 proc sql. Any help would be greatly appreciated. Jerry

jerry898969 · ‎07-14-2011

Any ideas?

jerry898969 · ‎07-14-2011

I tried this way and it seems to work but it seems too sloppy and that I can do it in less steps. data ex; input @1 var1 $2. @4 var2 $1. @5 var3 $3. @9 var4 $2. @12 var5 $3.; datalines; 1 V1 10 100 V4 20 200 2 V5 30 300 10 V3 40 400 V2 50 500 ; proc sort data=ex ; by var3 ; run ; data ex_ var_ ; set ex ; if var1 = '' then output var_ ; else output ex_ ; run ; filename dump "c:\temp\temp.sas" ; data _null_ ; set ex_ ; where var2 is null ; file dump ; put 'if ' var3 '= ' var4 'then ' var3 '= ' var5 ';' ; run ; data _null_ ; set var_ ; where var2 is null ; file dump mod ; if _n_ = 1 then put / '/*THIS IS A TEST*/' ; put 'if ' var3 '= ' var4 'then ' var3 '= ' var5 ';' ; run ; data ex; input @1 var1 $2. @4 var2 $1. @5 var3 $3. @9 var4 $2. @12 var5 $3.; datalines; 1 V1 10 100 V4 20 200 2 V5 30 300 10 V3 40 400 V2 50 500 ; proc sort data=ex ; by var3 ; run ; data ex_ var_ ; set ex ; if var1 = '' then output var_ ; else output ex_ ; run ; filename dump "c:\temp\temp.sas" ; data _null_ ; set ex_ ; where var2 is null ; file dump ; put 'if ' var3 '= ' var4 'then ' var3 '= ' var5 ';' ; run ; data _null_ ; set var_ ; where var2 is null ; file dump mod ; if _n_ = 1 then put / '/*THIS IS A TEST*/' ; put 'if ' var3 '= ' var4 'then ' var3 '= ' var5 ';' ; run ; Thanks for any help

jerry898969 · ‎07-13-2011

This is an example layout of my data table and data: VAR1 VAR2 VAR3 VAR4 VAR5 1 V6 1 100 V7 5 450 2 V15 23 88 V12 0 99 10 V4 10 101 I need only the rows where VAR2 is null. In my acutal data there are rows that have values in VAR2. I need to take the rows where VAR2 is null and create if statements in a sas file i'm making. This file will be included as part of a different program. This is what I have so far: filename dump "c:\temp.sas" ; data _null_ ; set raw ; where var2 is null ; file dump ; put 'if ' Var3 '= ' Var4 'then ' Var3 '= ' Var5 ';' ; run ; My only problem is that I need to put the rows that have a value in VAR1 first sorted by the value in VAR3 in my file then put a comment then put the rows where VAR1 is null. My sas file should look like this: if V4 = 10 then V4 = 101; if V6 = 1 then V6 = 100 ; if V15 = 23 then V15 = 88 ; /*These are new entries */ if V7 = 5 then V7 = 450 ; if V12 = 0 then V12 = 99 ; 1. Can this be done in one data step? 2. How can I put the comment /*These are new entries */ only one time if I have multiple rows with no VAR1 value? Thank you for any help or advice you can give me.

jerry898969 · ‎06-30-2011

I need to get the value of the first variable first row of a data set without knowing the variable name. The reason for this is I have to create a macro that will loop through many datasets and look at the first variable first row's value. Each data set has a different name for the first variable. Any help would be appreciated. Thank you

jerry898969 · ‎06-17-2011

Ahmed, thank you as well your solution works as well. Thank you

jerry898969 · ‎06-17-2011

Scott, You are the best. This is what I came up with and it seems to work. data t ; set pep (obs=5); cnt = COUNTW(people, '--') ; i=0; do while(i < cnt); i+1; x = scan(people,i,'--') ; output; end; run ; Do you see any issues with the way i'm doing it? Thank you again

jerry898969 · ‎06-17-2011

I have a variable that has a list of people delimited by "--". I want to seperate each person and make each one a row so I can sort then get a distinct list of people. example data Bob Jones--Fred Smith William Feek--Cindy Simpson--Abigail Wii David Davidson Chris Testers--Mindy Sohow I need this as the output Abigail Wii Bob Jones Chris Testers Cindy Simpson David Davidson Fred Smith Mindy Sohow William Feek I was looking at using the scan function but I'm not sure how to cycle through the string.

jerry898969 · ‎06-13-2011

Art & Patrick, Thank you both and I do apologize for not giving test data. I have yet to look at either since I was pulled away onto another project. I will go with your suggestions and use the regex approach. I think it will be the cleanest way to do it. Jerry

jerry898969 · ‎06-10-2011

I have a data set that has a subject variable. This is based on email subjects. The issue I'm having is that I have to find a specific string within this variable but the string isn't consistent. The string 'Inquiry#' is what i'm looking for but it has to have 1 or 2 numbers following it. For ex Inquiry#1 or Inquiry#12. I need the string before and after this string. I have done this so far but I feel I could have done it much cleaner. data inq_2 ; set inq ; subject_ = compress(subject) ; inq_pos = find(subject_ , 'Inquiry#', 'i') ; inq_str = substr(subject_ , inq_pos) ; inq_dash_pos = find(inq_str, '-') ; /*A dash does not always follow. Needs fix */ if inq_pos = 1 then x = substr(subject_ , inq_dash_pos) ; else x = substr(subject_,1,inq_pos -1) || ' ' || substr(subject_, (inq_pos + inq_dash_pos) - 1) ; run ; Thanks for any help

jerry898969 · ‎06-09-2011

Scott, That was it. I didn't have it within my file statement. Thanks for the quick response.

jerry898969 · ‎06-09-2011

I'm outputting some character data and some of the strings are long then 255 and they wrap within my txt file. Is there a way to avoid the wrapping? My text editor can handle more then 255. Thank you

jerry898969 · ‎05-19-2011

Figured it out. I needed to add a "lrecl = 6842" to my file statement.

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

How to pull out each place of a decimal value

Creating Macro variables based on min max of id field

Creating Macro variables based on min max of id field

Putting string in file based on value of variable

Putting string in file based on value of variable

Putting string in file based on value of variable

Getting value from first column first row without knowing the variable...

Re: Splitting variable into multiple rows

Re: Splitting variable into multiple rows

Splitting variable into multiple rows

Re: Issue with replacing string within a string

Issue with replacing string within a string

Re: Output a string longer then 255 without wrapping

Output a string longer then 255 without wrapping

Re: creating text report with very long strings