About AncaTilea

AncaTilea · ‎02-11-2013

Hi. I think you need to use an additional data step to create the 1/19 of the mean. proc means nway data= para noprint; class Variable; var estimate; output out=two (drop=_type_) mean(estimate)=col1 (1/19)*mean(StdErr)=col2 std(estimate)=col3; run; data want; set two; new_mean = (col1/19)* col2; run; This is assuming that you want to calculate 1/19 of the mean times the std Err; Am I getting this right? Anca.

AncaTilea · ‎02-11-2013

Hi. The AVERR or the AVerage ERRor is the difference between the actual and the predicted target values. I think. Good luck. Anca.

AncaTilea · ‎02-07-2013

I would try to define the path using back-slashes "\" instead of forward slashes "/" ods tagsets.excelxp file="multisheet.xls" path="\rem\sas\data\test1\" style=minimal; proc sort data=sashelp.CARS out=CARS; by Make; run; proc print data=CARS; by Make; run; ods tagsets.excelxp close; It worked for me when I did that. Good luck! Anca.

AncaTilea · ‎02-05-2013

Apparently you could do it as they did it here: http://www2.sas.com/proceedings/forum2008/368-2008.pdf see bottom of page 1.

AncaTilea · ‎02-05-2013

I see. I get it to work. can you close/open SAS to make sure you have no other options set? I added an ods pdf file = "c\pk.pdf"; ...code... ods pdf close; and it worked (see attached); hmmmm.... I try to think what else may cause this?

AncaTilea · ‎02-05-2013

OK, Please see attached. data temp; length new_age $5.; set sashelp.class; if age = 12 then new_age = "12\y"; else new_age = age; run; ods rtf file = "back_slash.rtf"; proc report nowd data=temp; column new_age weight; define new_age/display "Age\over nothing"; define weight /display; run; ods rtf close; Would share the code, please? (with some fake data) Thanks. Anca. PS: I had to attach it as .PDF because it wouldn't allow me to attach .RTF file.

AncaTilea · ‎02-05-2013

When I try this (see code below, which is just a sample code to get an idea for myself) the "\" print in the rtf document. Could you share the code? ods rtf file = "back_slash.rtf"; proc report nowd data=sashelp.class ; column age weight; define age/display "Age\over nothing"; define weight /display; run; ods rtf close; Let me know if it works? Thanks and good luck! Anca.

AncaTilea · ‎02-02-2013

Hi I agree that Tim's solution is the preferred one. I was not aware of being able to write several ODS TAGSETS.EXCEXP in one run. My idea was that the user that posted the question needed to call ODS TAGSETS several times...the one way - I thought - some thing that is needed repeatedly could be accomplished is via macro call. (I don't particularly prefer a macro to everything) Cheers! Anca. PS: I thought we all are trying to offer alternatives, and options on how to solve a given problem.

AncaTilea · ‎02-01-2013

You could try the ODS TAGSETS.EXCELXP and PROC PRINT Anca.

AncaTilea · ‎02-01-2013

:smileylaugh:

AncaTilea · ‎02-01-2013

Arthur Tabachneck wrote: Anca tilea: Actually it does if you have the validvarname option set to ANY, but I wouldn't recommend doing that. sandip patel: It would help if you tell us more and provide a brief example (i.e., NOT with 1,000 variables) Thank you,Arthur. Here is a non SAS question: how do I reference someone in my reply (like you just did)??

AncaTilea · ‎02-01-2013

Try this: format Elapstime time5.; Good luck. Anca.

AncaTilea · ‎02-01-2013

When you do a proc contents on your SAS data set what are the names of your variables? (are they really 235,6789?) I thought SAS doesn't allow for column names to be just digits:smileyconfused:

AncaTilea · ‎02-01-2013

I think : found = (prxmatch('m/end/i', title) > 0); * the 'i' allows for both lower or upper case, it tells SAS that the match is case insensitive; Good luck! Anca.

AncaTilea · ‎02-01-2013

Like this: proc univariate data = sashelp.class; where sex = "F"; var age; histogram age; run; OR: proc univariate data = sashelp.class; where weight > 100; var age; histogram age; run;

Online Status	Offline
Date Last Visited	‎11-18-2024 07:33 PM

Re: Crosstab Dates

Re: why repeated observations??

Re: why repeated observations??

Re: why repeated observations??

Re: Add rivers to US map

Re: Add rivers to US map

Add rivers to US map

Re: # of months between two date vars

Re: ODS Tagsets ExcelXP Creating Multiple Workbooks

Re: Histogram with different fill colors beyond a specified point

Re: Add rivers to US map

Re: Spliting a string into variable

Re: Spliting a string into variable

Re: Histogram with different fill colors beyond a specified point

Re: Anagrams Within Words

Re: Default "view" preferences at startup of SAS

Re: Turn off title in BoxPlots

Re: How to use "labels" (Excel column headers) instead of SAS "names" ...

Re: Residuals in logistic regression

Re: Adding a Variance column in a table

Re: I need to output a fraction of the mean that is (1/19)*mean(StdErr...

Re: Results from the Auto Neural Node in Enterprise Miner

Re: Erro with tagsets.excelxp : physical file does not exist

Re: help with sample size calculation

Re: Print the back slash using proc report.

Re: Print the back slash using proc report.

Re: Print the back slash using proc report.

Re: Export tagsets.ExcelXP to multiple files

Re: Help exporting correct format

Re: best practice to rename

Re: best practice to rename

Re: How to do the format Time value

Re: best practice to rename

Re: Extracting part of a title

Re: how to use 'where' in proc univariate