About Martinez77

Martinez77 · ‎05-13-2014

Thanks all, I ended up realizing how limited SAS is in the regards of GUI creation. Because I was unable to create a program based on SAS alone I decided to just make a macro and hope the users will be able to understand. The idea was exactly as RW9 was describing. In python you can create functions and when the user calls the function/macro/method a small box describing the parameter is available. This provides the user more information. I just decided to use the window function to display everything once they call the macro. RW9 your link failed to bring anything up, but I'll keep trying thanks. Thank you all for your help. Sorry for the delayed response. It was a little time sensitive.

Martinez77 · ‎03-17-2014

Hello SASers, I have been creating macros(methods) in sas and would like to add a hover message to my macros . The idea is to display data to the user when the user calls the macro to further explain the parameters that should be input. Best,

Martinez77 · ‎08-21-2013

Astounding, Perfect, thank you very much. Out of Curiosity what is the difference between the two? Martinezz

Martinez77 · ‎08-21-2013

Hey all, 1.I need to calculate a percentage in proc tabulate. I am trying to sum a variable (totalsch) then find it's percentage of the column total. I believe the code below would do that, however, when I check the calculation the percentage is incorrect. Any thoughts? proc tabulate data = Collegeofmusic style=untpdf; class acad_plan acad_term_desc; var totalsch; Table acad_plan All='Total',acad_term_desc*totalsch*(sum colpctn) ALL='Total'; run; Thanks Martinezz

Martinez77 · ‎08-13-2013

all Thank you all very much. I had a typo in my format. Fixed it and the datepart function worked great. Another sas win. Thanks, Martinez

Martinez77 · ‎08-13-2013

I should have been a little more clear. I have a variable in my data set name enrl_drop_dt which contains date values as below: 29MAR2013:00:00:00 There are missing values with a . if missing. I need them to display as shown below: 03292013 I was hoping I could do it in a data step Data bla; set bla; format enrl_drop_dt mmddyyy6.; run; I hope that shines some light Thanks, Martinez

Martinez77 · ‎08-13-2013

Reeza 29MAR2013:00:00:00 This is what they currently look like. I want it to appear like this: 03292013 Thanks you for your help, Martinez77

Martinez77 · ‎08-13-2013

Hey all, I am trying to format a date variable that currently has a date16 format. There are . for missing values for the variable. I need to reformat this but I get an ERROR: There was a problem with the format so BEST. was used. Not sure what is going on. or how to work around. Thanks

Martinez77 · ‎08-09-2013

Cynthia, You gave me enough information to read and figure it out via research. Thank you so much,

Martinez77 · ‎08-08-2013

Cynthia, This is the simple code that is trying to be executed after bringing in a data set. I hope this helps clarify Proc tabulate data=simsterm; CLASS GENDER VAR CUM_GPA CUR_GPA; TABLE GENDER, CUM_GPA CUR_GPA DIFF=(CUM_GPA – CUR_GPA); RUN; Thanks

Martinez77 · ‎08-08-2013

Vince, Thank you I will start learning about DDE and give it a shot. Appreciate all the help Martinez

Martinez77 · ‎08-08-2013

Vince, DDE sounds like a great solution. I have an excel macro that adds images to a1 cell for every sheet and then apply to all needed workbooks. If I have already closed the ods output could I use dde to insert the image after my ods close statement? Thanks, Martinez

Martinez77 · ‎08-08-2013

Cynthia, Yes I figured out the ods issue. I just added the / box =_page_ and it resolved the problem for now. As far as proc report goes I have never used it. Could you show me some example code of proc report that would reflect a proc tabulate output. My boss just asked me about it recently so still waiting to hear back from him on specific variables. I guess and example would be income1 -income2 =difference all showing in columns Thank you, Martinez

Martinez77 · ‎08-08-2013

Cynthia, I was trying to do the same thing using the ods tagsets.excelxp would I be able to try your third suggestion or was that specific to a particular output type. The idea is to create an automated procedure, but I will check into using a macro in excel also. Thanks, Martinez

Martinez77 · ‎08-08-2013

Hey all, So I would like to get rid of or edit the border at the top of my proc tabulate tables. It is only a problem when their is a variable to page break on. also I would like to add a simple subtraction computation for example income1-income2 =difference. Thanks Here is an image: Note the ugly bordering that is only on the page lable. It is make my template look horrible. Thanks Martinez

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: SAS macro parameter message on hover

SAS macro parameter message on hover

Re: Proc tabulate calculating percentage

Proc tabulate calculating percentage

Re: Problem when formatting a date variable

Re: Problem when formatting a date variable

Re: Problem when formatting a date variable

Problem when formatting a date variable

Re: proc tabulate formatting and computation

Re: proc tabulate formatting and computation

Re: Formatting macro variables

Re: SAS macro parameter message on hover

SAS macro parameter message on hover

Re: Proc tabulate calculating percentage

Proc tabulate calculating percentage

Re: Problem when formatting a date variable

Re: Problem when formatting a date variable

Re: Problem when formatting a date variable

Problem when formatting a date variable

Re: proc tabulate formatting and computation

Re: proc tabulate formatting and computation

Re: Insert Image Using ExcelXP ODS

Re: Insert Image Using ExcelXP ODS

Re: proc tabulate formatting and computation

Re: Insert Image Using ExcelXP ODS

proc tabulate formatting and computation