About AncaTilea

AncaTilea · ‎02-26-2013

Hi, would you please try this addition to your existing code: ods tagsets.tableeditor file="file1.html" event = cell_is_empty path="\\yourPath..." (url=none) style=styles.button options(toc_background="white" ....rest of code.... I think it may work! Actually it will only work if you are summing over all the variables you are printing... Message was edited by: Anca Tilea

AncaTilea · ‎02-26-2013

So, in the SAS Output wahtever you are trying to print will look (more or less) like this: Age Height 12 57.3 12 59.8 12 59.0 12 56.3 12 64.8 ====== 297.2 The 'problem' is the line ===== which translate to a non blank space (nbsp) (I may over-reaching here)...but when you try to filter your data, you also have this option...the ==== So, I need to read/google more to figure out how to 'restrict' it from showing in your html... more later.

AncaTilea · ‎02-26-2013

Hi Vomer, Would you please post the code? Thanks. Anca.

AncaTilea · ‎02-25-2013

hi.first thing i can think of is to place quotes for the last variable..ar3 eq 'PA0'

AncaTilea · ‎02-25-2013

What happens when you run this code: ods tagsets.excelxp file = "\\your_path\to_test.xls" style = sasweb options(autofilter="yes" ); proc print data=sashelp.class noobs label; var name height; where age=12; sum age; label age="Age"; run; ods tagsets.excelxp close; You note I removed the toc_...options because SAS said unrecognized option... Does this work? PS: change the path where the file is saved

AncaTilea · ‎02-25-2013

could you provide a snippet of your code. I am assuming this is a proc report?

AncaTilea · ‎02-25-2013

Ok, so then here is something that could work (I am using sashelp.class data set, and I want to split the data based on the name): proc sql; select cat(" '" || name ||" ' ") into: list_name separated by "," from sashelp.class; quit; %macro nada(); %do i = 1 %to 19; data name_&i.; set sashelp.class; if name = %scan("&list_name", &i., ","); run; %end; %mend; %nada(); Ok, so this is what I am hoping to do: For you the above code could translate into something like this: proc sql; select subjid into: list_ids separated by "," from your_master_data; quit; This macro variable called list_ids should be a string that looks like this: 101, 102, 109,143,165,..., 550 Then the next part: %macro nada(); %do i = 1 %to 550; data step.... .... if subjid = %scan("&list_ids", &i., ","); ... run; %end; %mend; %nada(); So, you want to add the %do i = 1 %to 550: But you also want to add the if subjid = %scan("&list_ids", &i., ","); in your data step. Let me know if this makes any sense. Anca.

AncaTilea · ‎02-25-2013

One quick way is to include a do-loop in your macro BUT this requires that your IDs are consecutive: %macro patprof ( ); %do subjid = 1 %to 550; .. .. .. .. %end; %mend; Now call the macro just once: %patprof();

AncaTilea · ‎02-25-2013

Hi. You can't get the desired data set (temp4) because there is no firm information for data = 5. Please see below: data temp1; input date firm; cards; 1 1 2 1 3 1 4 1 1 2 2 2 3 2 ; data temp2; input date stock $; cards; 1 a 2 b 3 c 4 d 5 e ; data want; input date firm stock $; cards; 1 1 a 2 1 b 3 1 c 4 1 d 5 1 . 1 2 a 2 2 b 3 2 c ; It seems to me that given your data set temp1 - the one that has the information on date and firm...there is no way of knowing that for date 5 you will have firm = 1 (like you want in your desired data set (temp4)) Unless you specifically tell us that for any missing information on firm carry down the information form prior record....?? So, below is the code you provide (which is correct): proc sort data=temp1; by date; run; proc sort data=temp2; by date; run; data temp3; merge temp1(in=frodo) temp2(in=prodo); by date; if prodo; run; This works, but without you specifically telling us that you want a carry down of value when missing, you can't get the desired output. I am talking a bit circular, I think. I hope this helps a bit. Good luck, Anca.

AncaTilea · ‎02-14-2013

Hi Andre, In the example (from SAS) you see that there is an extra data step, where an 'attribute' map is created: See below: data attrmap; retain ID "myid"; retain markersymbol "circlefilled"; input value $ markercolor $ linecolor $ linepattern $; datalines; F orange orange solid M blue blue solid ; run; title1 "SGPanel reg "; proc SGpanel data=sashelp.class dattrmap=attrmap; panelby sex; reg x=height y=weight/group = sex cli clm attrid=myid; run; Good luck! Anca.

AncaTilea · ‎02-12-2013

I was wondering why users prefer the .png to .jpeg? is there any reason for that? My graphs tend to look acceptable in jpeg, and eventually when time gets to publish I make .eps or .tiff... If you have more thoughts on this, I would appreciate your opinion. Thank you in advance.

AncaTilea · ‎02-12-2013

Thank you! :smileygrin:

AncaTilea · ‎02-12-2013

Hi. I have a working code that manifests differently for what seems to me very similar conditions. PLease see below: I have a data set that has estimates from a couple of models (one assessing within the other one between subjects...) I initially had a chart that plotted the estimates from both models in one plot: data have; input measure $ 1-19 model $ Estimate ; cards; First, Measure b_gfr 3.48 First, Measure d_gfr_10 3.56 Second, Measure b_gfr 1.38 Second, Measure d_gfr_10 2.22 Third, Measure b_gfr 1.40 Third, Measure d_gfr_10 2.03 Fourth, Measure b_gfr 1.38 Fourth, Measure d_gfr_10 3.28 Fifth, Measure b_gfr 0.85 Fifth, Measure d_gfr_10 1.51 Sixth, Measure b_gfr 0.07 Sixth, Measure d_gfr_10 0.38 Seventh, Measure b_gfr 0.63 Seventh, Measure d_gfr_10 0.93 Eighth, Measure b_gfr 2.99 Eighth, Measure d_gfr_10 5.17 ; filename models "&plot_path.\models_both.jpeg"; goptions reset = all device = jpeg gsfname = models gsfmode = replace ; options orientation=landscape nodate nonumber ; pattern1 color = graycc; pattern2 color = gray; axis1 label = none minor = none order = (0.0 to 7.0 by 1) value = none major = none c = white; axis2 label = none value = none; axis3 split = "," label = none value = (f = "Arial/Bold" h = 1.2 ) c = black; legend label = none position = (inside top left) mode = protect across = 1 value = (h = 1.7 f = "Arial" "Between-Patient Models" "Within-Patient Models"); proc gchart data = have ; vbar model/ sumvar = estimate NoZero space = 0 group = measure subgroup = model legend = legend type = mean iframe = black raxis = axis1 maxis = axis2 gaxis = axis3 coutline = black ; run;quit; It turns out the request is now for separate plots. Very easy to do, I just split the code and restrict the data to one mode at the time, using a where statement. filename models "&plot_path.\models_cross.jpeg"; goptions device = jpeg gsfname = models gsfmode = replace ; options orientation=landscape nodate nonumber ; axis1 label = none minor = none order = (0 to 7 by 1) value = none major = none c = white; axis2 label = none value = none; axis3 split = "," label = none value = (f = "Arial/Bold" h = 1.2 ) c = black; pattern color = grayee; legend label = none position = (inside top left) mode = protect across = 1 value = (h = 1.7 f = "Arial" "Between-Patient Models"); proc gchart data = have ;where model = 'b_gfr'; vbar model/ sumvar = estimate NoZero space = 0 group = measure legend = legend type = mean iframe = black raxis = axis1 maxis = axis2 gaxis = axis3 coutline = black ; run;quit; filename models "&plot_path.\models_within.jpeg"; goptions device = jpeg gsfname = models gsfmode = replace ; options orientation=landscape nodate nonumber ; axis1 label = none minor = none order = (0 to 7 by 1) value = none major = none c = white; axis2 label = none value = none; axis3 split = "," label = none value = (f = "Arial/Bold" h = 1.2 ) c = black; pattern color = gray; legend label = none position = (inside top left) mode = protect across = 1 value = (h = 1.7 f = "Arial" "Within-Patient Models"); proc gchart data = have ;where model = 'd_gfr_10'; vbar model/ sumvar = estimate NoZero space = 0 group = measure legend = legend type = mean iframe = black raxis = axis1 maxis = axis2 gaxis = axis3 coutline = black ; run;quit; OK, so my problem is that one plot 'fills' the graphic area, the other one seems to be smaller and I can't figure out why. Any help would be highly appreciated. Thank you! Anca.

AncaTilea · ‎02-12-2013

Very nice! Thank you. I never knew of select...when...otherwise... !!!! Excited! Thanks! Anca.

AncaTilea · ‎02-12-2013

Here is a piece of code that (almost) accomplishes what you want (I can't understand why you are not allowed to use proc sort?) The code is based on the data you provided, and it is very 'manual' (or lots of hard-coded values) (so, again, there are quicker and better ways to accomplish this): data want; set email; *create a flag for each ID occurrence; tempA = (custId = "A"); tempB = (custId = "B"); tempC = (custId = "C"); tempD = (custId = "D"); tempE = (custId = "E"); tempF = (custId = "F"); *the retain will help 'retain' a value until a new 'instance/value' is met; retain total_A 0 total_B 0 total_C 0 total_D 0 total_E 0 total_F 0; *sum down the rows; total_A=sum(total_A,tempA); total_B=sum(total_B,tempB); total_C=sum(total_C,tempC); total_D=sum(total_D,tempD); total_E=sum(total_E,tempE); total_F=sum(total_F,tempF); drop temp:; by_var= 1;*to use in the next data step; run; data may_want(Keep = total:); set want; by by_var; if last.temp; run; So the final data is not really in the same 'shape' as what you really want. But these are my thoughts. Good luck! Anca.

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: Question on in table

Re: Question on in table

Re: Question on in table

Re: Help with very simple code!!

Re: Question on in table

Re: Question on in table

Re: Macro to create patient profiles

Re: Macro to create patient profiles

Re: merge and sort

Re: sgpanel color cycle

Re: PROC GCHART graphic area problem

Re: PROC GCHART graphic area problem

PROC GCHART graphic area problem

Re: New user - need help

Re: New user - need help