About Mgarret

Mgarret · ‎12-03-2013

Hi- I have a variable called CreativeName with many different string values. Some of the values (not all) have parts of the strings which need to be deleted. If I use COMPRESS the characters are deleted anywhere in the string; and not the part of the string I specify. The parts that need to be deleted can be found at the beginning or the end of the string value. Here are some examples of the strings that need to be cleaned/modified Yahoo_AS_acq_fios_3x_NeonLastChanceNAT_8999_AmazonVisa_Flash_10282013_728x90.swf | AK & REVSCI Google_AS_acq_fios_3x_NeonLastChancePOTOMAC_8999_AmazonVisa_Flash_10282013_728x90.swf | AK & REVSCI acq_fios_3X_MadDashPot_7999_Visa_Flash_11172013_728x90.swf (copy) AOL_AS_acq_fios_3X_SpeedTiersNY_8999_NAC_Flash_1012013_728x90.swf This is what I have: Data want; Set have; CreativeName= compress(CreativeName,’(Copy)’); CreativeName= compress(CreativeName,’AOD_AS_’); CreativeName= compress(CreativeName,’AOL_AS_’); CreativeName= compress(CreativeName,’Google_AS_’); CreativeName= compress(CreativeName,’Google_’); CreativeName= compress(CreativeName,’Yahoo_AS_’); CreativeName= compress(CreativeName, '| AK & REVSCI'); CreativeName= compress(CreativeName, '| AK'); run; Also for values that are ‘FiOS Presents’ I have to add ‘MF’ to the end. Can I use the TRANSWORD function? Any assistance is appreciated.

Mgarret · ‎11-21-2013

I am using 9.3. Is there I work around if I can't do this in 9.3?

Mgarret · ‎11-21-2013

Hi- I am trying to output put some data to powerpoint point. I keep on getting to error message. I have been searching for a definition of the error message but can't find it; also I can't find much in for information on PresentationML. If someone could point me in the right direction for more information, that would be great. ERROR: Unable to load module 'PresentationML' from template store! ERROR: No body file. POWERPOINT output will not be created.

Mgarret · ‎12-04-2012

Hi all— I’m trying to use base SAS to count points possible and points earned. When counting points possible missing values do not count. I have been trying to use the count function. Is that correct? Your help is appreciated. data want (keep=S1 S2 S3 S4 S5); set have; Points_ Possible=count(S1, S2, S3, S4 ,S5); Not Total_ points=sum(S1, S2, S3, S4 ,S5); run; What I need: Id_Survey S1 S2 S3 S4 S5 Points_ Possible Total_ points 4545 1.0 0.0 1.0 1.0 0.0 5.0 3.0 999 0.0 1.0 . . 1.0 3.0 2.0 784 . 0.5 0.0 1.0 0.0 4.0 1.5 852 0.5 . 1.0 . . 2.0 1.5 Thanks!!!

Mgarret · ‎09-19-2012

This is exactly what I needed. Thanks!

Mgarret · ‎09-19-2012

Hi all— I’m having issues getting the correct totals and percentages in Proc Tabulate tables. I can’t seem to figure out how to negotiate the code to fix the issue (my code is below the two tables). These are the tables I'm generating now with the current vision of my code. INDICATOR Sub-indicator A Q16a: Is there a recorded available during the 6 month review period? Count Yes No Count Total % Total Overall % Count % Count % Program 1 5 11% . . 5 11% Program 2 8 18% . . 8 18% Program 3 16 37% 1 2% 17 39% Program 4 12 27% 1 2% 13 30% Overall Agency Totals 41 95% 2 4% 43 100% Q16a: Is there a recorded available? Count Yes No Skipped Count Total % Total Overall % Count % Count % Count % Program 1 5 1% . . . . 5 1% Program2 7 1% 1 0% . . 8 1% Program 3 15 3% 1 0% 1 0% 17 3% Program 4 11 2% 1 0% 1 0% 13 3% Overall Agency Totals 38 8% 3 0% 2 0% 43 10% Below is what I need instead. You will notice the response percentages are being calculated by dividing the Overall Agency Totals’ % Total. INDICATOR Sub-indicator A Q16a: Is there a recorded available? Count Yes No Count Total % Total Overall % Count % Count % Program 1 5 11.6% 0 0.0% 5 100% Program 2 8 18.6% 0 0.0% 8 100% Program 3 16 37.2% 1 2.3% 17 100% Program 4 12 27.9% 1 2.3% 13 100% Overall Agency Totals 41 95.3% 2 4.7% 43 100% Q17: Is the assessment in the most recent ? Count Yes No Skipped Count Total % Total Overall % Count % Count % Count % Program 1 5 11.6% 0 0.0% 0 0.0% 5 100% Program2 7 16.3% 1 2.3% 0 0.0% 8 100% Program 3 15 34.9% 1 2.3% 1 2.3% 17 100% Program 4 11 25.6% 1 2.3% 1 2.3% 13 100% Overall Agency Totals 38 88.4% 3 7.0% 2 4.7% 43 100% Here is my code: proc tabulate data=have (where=(question in('Q16' 'Q17',) & Program_Type in(&program))) style=[background=white foreground=black font_face='Arial Narrow' font_size=10.5pt just=c cellwidth=.6in]; title1 "^S={font_face='Arial Narrow' font_weight=bold font_size=12pt} INDICATOR"; title2 "^S={font_face='Arial Narrow' font_weight=bold font_size=12pt} Sub-indicator A"; class question program_name / style={font_face='Arial Narrow' font_weight=bold font_size=11pt cellheight=50 }; class Responce1 / order=formatted style={font_face='Arial Narrow' font_weight=bold font_size=11pt cellwidth=.6in}; classlev question /style=[font_face='Arial Narrow' font_size=11pt]; classlev program_name /style={font_face='Arial Narrow' font_size=10pt cellwidth=.6in cellheight=.4in just=l}; classlev Responce1 /style={font_face='Arial Narrow' font_size=11pt }; table Question=' ', program_name =' ' all='Overall Agency Totals', Responce1=' '*(n='Count'*f=best8. pctn='%'*f=p.) n='Count Total' pctn='% Total' *f=p. /style={font_face='Arial Narrow' font_size=11pt cellwidth=.6in} row=float box={label='Count^{newline 1}Overall^_%' style={font_face='Arial Narrow' font_size=10pt font_weight=bold cellwidth=.6in}}; format question $ques.; format responce1 $resp.; keyword n pctn / style=[font_weight=bold foreground=black font_face='Arial Narrow' font_size=10pt just=c]; keyword all/ style=[font_weight=bold foreground=black font_face='Arial Narrow' font_size=10pt just=l]; run; The percentage format is defined with this code: proc format ; picture p low-high='0099%'; run; Any help is greatly is greatly appreciated!!!

Mgarret · ‎09-06-2012

Hi Astounding--- Thank you for your help. If you could, would you mind explaining whats going on in the steps below? Thanks! if first.agency then agency_total=0; if first.program then program_total=0; retain agency_total program_total; agency_total = agency_total + active_cases; program_total = program_total + active_cases; run;

Mgarret · ‎09-06-2012

Hi all-- I've been having a heck of a time trying to understand by group processing – I find it tricky to understand. Any help will be greatly appreciated. Again, I’m trying to understand how this works any additional explanation would be so great. I am using this equation to calculate scores: Utilization=Active_Cases+Pending_Cases+(Housing_Subsidy_cases / 2) / Program_Capacity; I have to generate a score for each month by agency and then by program. Below is the code I have, but I know its not correct. I've been having trouble visualizing what actually happens during these steps data want; set have; by Agency program month; if first.agency and first.month then do; Utilization=Active_Cases+Priority_Pending_Cases+(Housing_Subsidy_Only_cases / 2) / Program_Capacity; end; do until last.Agency; end; run; Below is a data set. Again, any help is greatly appreciated. Agency Program Month Active_Cases Pending_Cases Housing_Subsidy_cases Program_Capacity Agency1 ProgramA January 26 6 3 40 Agency1 ProgramA Febuary 27 6 4 40 Agency1 ProgramA March 28 8 4 40 Agency1 ProgramA April 26 7 4 40 Agency1 ProgramA May 30 6 4 40 Agency1 ProgramA June 32 10 4 40 Agency1 ProgramA July 38 5 4 50 Agency1 ProgramA August 37 9 4 50 Agency1 ProgramA September 38 7 3 50 Agency1 ProgramA October 37 5 1 50 Agency1 ProgramA November 42 8 3 60 Agency1 ProgramA December 44 10 4 60 Agency2 ProgramA January 26 6 3 40 Agency2 ProgramA Febuary 27 6 4 40 Agency2 ProgramA March 28 8 4 40 Agency2 ProgramA April 26 7 4 40 Agency2 ProgramA May 30 6 4 40 Agency2 ProgramA June 32 10 4 40 Agency2 ProgramA July 38 5 4 50 Agency2 ProgramA August 37 9 4 50 Agency2 ProgramA September 38 7 3 50 Agency2 ProgramA October 37 5 1 50 Agency2 ProgramA November 42 8 3 60 Agency2 ProgramA December 44 10 4 60 Agency2 ProgramB January 26 6 3 40 Agency2 ProgramB Febuary 27 6 4 40 Agency2 ProgramB March 28 8 4 40 Agency2 ProgramB April 26 7 4 40 Agency2 ProgramB May 30 6 4 40 Agency2 ProgramB June 32 10 4 40 Agency2 ProgramB July 38 5 4 50 Agency2 ProgramB August 37 9 4 50 Agency2 ProgramB September 38 7 3 50 Agency2 ProgramB October 37 5 1 50 Agency2 ProgramB November 42 8 3 60 Agency2 ProgramB December 44 10 4 60

Mgarret · ‎09-05-2012

Hi all— I have a bunch of variables which have to be recoded into new variables. Each original variable has to be split into two variables ending in “N” (numerator) and “D” (Denominator). So variable Q1 is plit into Q1N and Q1D. The values the variables are assigned all depends on what the response code was for Q1 was. I have started writing out decode code for all the varibles but is there a way to do this all at once like using an Array with a Do loop or some other way. Any help is greatly appreciated. Thanks! data decode; set have ; if Q1=1 then Q1N=2; else if Q1=2 then Q1N=0; else if Q1=3 then Q1N=0; else if Q1=4 then Q1N=1; else if Q1=. then Q1N=0; if Q1=1 then Q1D=2; else if Q1=2 then Q1D=2; else if Q1=3 then Q1D=0; else if Q1=4 then Q1D=2; else if Q1=. then Q1D=0; if Q2=1 then Q2N=2; else if Q2=2 then Q2N=0; else if Q2=3 then Q2N=0; else if Q2=4 then Q2N=1; else if Q2=. then Q2N=0; if Q2=1 then Q2D=2; else if Q2=2 then Q2D=2; else if Q2=3 then Q2D=0; else if Q2=4 then Q2D=2; else if Q2=. then Q2D=0; if Q3=1 then Q3N=2; else if Q3=2 then Q3N=0; else if Q3=3 then Q3N=0; else if Q3=4 then Q3N=1; else if Q3=. then Q3N=0; if Q3=1 then Q3D=2; else if Q3=2 then Q3D=2; else if Q3=3 then Q3D=0; else if Q3=4 then Q3D=2; else if Q3=. then Q3D=0;

Mgarret · ‎08-03-2012

Tom Thanks! last question, I just want to make sure I'm understanding you. does _character_ means it applies to all the character variables in the data set. What if I have numeric variables in the data set as well?

Mgarret · ‎08-03-2012

Hi Tom and Linlin-- The issue still seems to happen. But it happens when I combine the data. I use a simple union ststment to do it: proc sql; create table want as select * from have union select * from have; quit; It looks like the variable lengths always stay the same But the Format and Informat values change. How do I keep them at the same value everytime? Thanks.

Mgarret · ‎08-03-2012

Hi Tom-- Thanks for your help. What is this last step do: put agency=; Thanks!

Mgarret · ‎08-03-2012

Hi all— I’m having trouble with the TRANWRD function and variable length. I have a large data set that I continually append data to. In the data set the variable AGENCY has a length of 5. I need to fix the value of ‘ST JO’ contained in the AGENCY variable and swap it out for ‘ST JOHN'. When I add in the LENGTH statement for AGENCY the variable length does change but the value stays as 'ST JO' and does not change/correct to 'ST JOHN'. data want length AGENCY $8; set have AGENCY =TRANWRD(AGENCY,'ST JO','ST JOHN') ; run; Thoughts? Thanks!

Mgarret · ‎07-09-2012

Hi— I’m trying to pull cases which are =< to the last date of the month based on a certain date variable (DISPOSITION_DATE). The dataset contains data for all 12 months of the year so I’m not sure of to take this into account. Proc sql; create table want as select distinct var1, var2, var3 datepart(DISPOSITION_DATE), from have; quit; Any help is greatly appreciated!

Mgarret · ‎05-18-2012

Hi Cynthia-- I thank you for your great help in advance. The destination of interest is PDF. Thanks!

Online Status	Offline
Date Last Visited	‎10-18-2017 05:30 PM

Proc fastclus: Relative importance of Variables within Clusters

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Identifying Lapsed Customers

Re: Multi Sheet Excel Workbook Macro Using tagsets.excelx - Only 1 She...

Re: Multi Sheet Excel Workbook Macro Using tagsets.excelx - Only 1 She...

Re: Identifying Lapsed Customers

Re: Identifying Lapsed Customers

Re: Combining two Arrays which use regular expressions

Re: Combining two Arrays which use regular expressions

Re: tagsets.excelxp and Proc Report: Sheet Formatting/ Styling Questio...

Spanned Header: Changing the font size/type and background color

Re: Spanned Header: Changing the font size/type and background color

Re: Changing a character date var to a real date var

Deleting Parts of a String: Alternatives to Compress

Re: ERROR: Unable to load module 'PresentationML' from template store

ERROR: Unable to load module 'PresentationML' from template store

Count and Sum Function

Re: Proc Tabulate: Wrong totals and Percent Totals

Proc Tabulate: Wrong totals and Percent Totals

Re: By Group Processing Help

By Group Processing Help

Recoding Variables using Arrays and Do Loops

Re: TRANWRD Function and Variable Length.

Re: TRANWRD Function and Variable Length.

Re: TRANWRD Function and Variable Length.

TRANWRD Function and Variable Length.

Proc sql and pulling obs =< the last date of the month

Re: Spanned Header: Changing the font size/type and background color