About sarahsasuser

sarahsasuser · ‎07-08-2013

Thanks, the documentation is helpful.

sarahsasuser · ‎07-08-2013

Hi Reeza, I forgot that double quotes were needed. I've substituted double quotes for singles in the proc report statement and around "&name" as this is a character field. I've added the parameters when I call the macro: %do_id_name (building_id,building_name); However I'm still getting this error: 2500 %mend do_id_name; 2501 %do_id_name(building_id,building_name); WARNING: Apparent symbolic reference ID not resolved. WARNING: Apparent symbolic reference NAME not resolved. NOTE: Line generated by the invoked macro "DO_ID_NAME". 1 proc report data=les.all_cover nowd split="/"; where building_id = &id and building_name = - 22 76 1 ! "&name" ; columns .... WARNING: Apparent symbolic reference ID not resolved. WARNING: Apparent symbolic reference NAME not resolved. ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. ERROR 76-322: Syntax error, statement will be ignored.

sarahsasuser · ‎07-08-2013

Hi Reeza and Tom, I don't want to use the #byval because I have 3 report tables I need to make for each building id. If I do a byval, it will run table #1 for each building, and then table 2 for each building and so on. I want instead to run for building 1 tables #1 - table #3, then building 2 tables 1-3, etc. Here is my code. Do I need to call each building id/name combo in the %do_id_name; statement? For instance %do_id_name (1, 1222 smith st)? I'd like for the macro to run through the dataset and run the report for each unique building id/name combo, instead of me having to tell it to. Is that possible? %macro do_id_name(building_id,building_name); proc report data=have nowd split='/'; title '&id and&name'; where building_id = &id and building_name = &name ; columns Type Subtype Region Count Expected count_ontime late pct_within pct_not_within; define Type/display " Type"; define subtype /display "subtype"; define Region/display "Region"; define Count/ display "Count"; define Expected/ display 'Expected'; define count_ontime/display '# Ontime'; define late/display '# late'; define Pct_within/display '% ontime' format=PERCENT7.0; define Pct_not_within/display '% late' format=PERCENT7.0; run; %mend do_id_name; %do_id_name;

sarahsasuser · ‎07-08-2013

I'd like to make the last line in which SAS automatically sums the statistics for me gray and bold? Is it also possible to add "Grand Total" to the row? Code: proc report data=have nowd split='/'; title 'Building_id and Building_name'; by building_id; columns Type Subtype Region Count Expected count_ontime late pct_within pct_not_within; define Type/display " Type"; define subtype /display "subtype"; define Region/display "Region"; define Count/ display "Count"; define Expected/ display 'Expected'; define count_ontime/display '# Ontime'; define late/display '# late'; define Pct_within/display '% ontime' format=PERCENT7.0; define Pct_not_within/display '% late' format=PERCENT7.0; run;

sarahsasuser · ‎07-08-2013

Hi Tom, Thanks for your suggestions. Since I have a couple of different tables I want to create for each building I think using a macro with more than one parameter is the best solution. However, I'm new to macros and am having trouble with the next step. I wrote this marco: %macro do_id_name(id,name). When I call the macro with %do_id_name; I get this error: WARNING: Apparent symbolic reference ID not resolved. WARNING: Apparent symbolic reference NAME not resolved. ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. ERROR 76-322: Syntax error, statement will be ignored. I have: %macro do_id_name(id,name); ....proc report title1 "Annual Report for &id and &name"; ... where building_id = &id and building_name = "&name" ; .... proc report title1 "Annual Report for &id and &name"; ... where building_id = &id and building_name = &name ; .... %mend do_id_name; %do_id_name;

sarahsasuser · ‎07-08-2013

Hi Ksharp, This gives me a blank row. What if I modified the code to take out the rbreak and the compute lines? When I do that SAS automatically sums the statistics for me. However, how do I format that last line so that it is gray and bold? Is it also possible to add "Grand Total" to the row? Thanks, Sarah

sarahsasuser · ‎07-08-2013

Hi All, I'm running a report on building stats. I'm using the by statement in the report so that I get separate tables for each building. I want to add I have the variables building_id and building_name to the title of each report. I am not sure how to create a macro for 2 variables. Can I modify this code to include the building_name as shown below? Also, instead of calling the individual buildings with %do_id at the end, can I build a smarter macro that looks for each unique ID number and runs the report? %macro do_id(building_id); %macro do_name(building_name); title1 "Annual Report for &id and &name; proc report data=buildings; by buiding_id; define ..... run; %mend do_id; %mend do_name; %do_id (A94); %do_id (A02) %do_id (A503); %do_id (A06);

sarahsasuser · ‎07-08-2013

Dear All, I would like to make a report table that looks like the table below. Since all the data is in the dataset, I don't actually want to calculate any fields, I just want the data to display. The log says that Region is a analysis variable, even though it is formatted as a character variable in the dataset. It will not allow me to use display for all of the variables. Further, I need to run this report by building id and name. I'd like both of those variables to show up in the title, but am unable to create a macro for both id and name. Any help is appreciated. Thanks. Building #: 1 2222 Smith St Type Subtype Region Count Expected Timeliness # ontime #late % ontime % late Residential Park 23a 3 4 3 3 1 75% 25% Grand Total 3 4 3 3 1 75% 25% proc report data=have nowd split='/'; title 'Building_id and Building_name'; by building_id; columns Type Subtype Region Count Expected count_ontime late pct_within pct_not_within; define Type/display " Type"; define subtype /display "subtype"; define Region/display "Region"; define Count/ display "Count"; define Expected/ display 'Expected'; define count_ontime/display '# Ontime'; define late/display '# late'; define Pct_within/display '% ontime' format=PERCENT7.0; define Pct_not_within/display '% late' format=PERCENT7.0; rbreak after / summarize suppress style={background=light gray font_weight=bold}; compute Region; if _break_ ne ' ' then call define('Region','style','style=[pretext="Grand Total" font_weight=bold]'); endcomp; */ run;

sarahsasuser · ‎06-18-2013

Thank you, that was exactly what I was looking for.

sarahsasuser · ‎06-18-2013

Thanks Reeza, I'm unable to get that to work either. Is there a second step I'm missing? I've tried the following and the field NewName is not populated. NewName=compress(ID_Number,,'ka'); NewName=scan(LDMS_ID_Number,2," ","ka"); NewName=scan(ID_Number," ","ka"); NewName = PRXCHANGE('s/[^a-zA-Z]//o',-1,ID_Number);

sarahsasuser · ‎06-17-2013

Hi All, I have a data field that I need to split into two new fields. The field is a building code and then name of that building. Example: ID_Number= 1 Bond Street Building I've been using this code to extract the ID_number: do while(scan(ID_Number, i, " ")); new_id=scan(LID_Number, i, " "); output; i+1; end; That code gives me a new_id field of 1. How do I get "Bond Street Building" into another field? Thanks, Sarah

sarahsasuser · ‎06-14-2013

Thanks, I used the order= option in the axis statement. Luckily, I do have 9.3! I found that if I used formats then SAS will order by the alphabetical order of the format, not the underlying value. And I had to wrap the text, and the split statement doesn't work with formats. Please correct me if I'm wrong. Thanks for your help! Sarah

sarahsasuser · ‎06-14-2013

Thanks Robert. How do I get the data in the order I want it in? I want to reorder the group variable by descending. I've sorted the data by the group variable before running the chart and that doesn't work. I've added the descending option to the options after the '/' in the hbar statement and that doesn't work either. Thanks, Sarah

sarahsasuser · ‎06-13-2013

Hi Robert, I'm having an issue with ordering the data using the split option. I'd like the chart to be in descending order, but when I add that option (in bold) the split stops working. Any suggestions? Thanks! Sarah axis1 label=none value=none; axis2 label=none value=(justify=right) split='\' order=descending; proc gchart data=foo; hbar colorvar / discrete type=sum sumvar=my_value subgroup=colorvar group=label space=0 maxis=axis1 gaxis=axis2; run; quit;

sarahsasuser · ‎05-30-2013

Hi Sanjay, I am curious about SGANNO. I know how to add that to the sgplot procedure, but I don't know how to format the annotated dataset so that this will work properly. Can you point me to an example? Thanks, Sarah

Online Status	Offline
Date Last Visited	‎12-03-2019 08:46 PM

Re: Iterative do loop to add days to a date

Re: Iterative do loop to add days to a date

Iterative do loop to add days to a date

Re: Change the title in survival plot produced by phreg

Change the title in survival plot produced by phreg

Re: Calculating time between a series of dates

Re: Calculating time between a series of dates

Calculating time between a series of dates

Subset a data based on values of variables

Re: Datapart and Timepart functions

Re: PROC IMPORT....multiple sheets

Re: Extracting patients based on number of observations

Re: Conditional processing with many conditions (if then else, or an a...

Re: Plotting large values in SGPLOT

Re: Plotting large values in SGPLOT

Re: Merging data sets based on the value of a variable

Re: Resizing xaxis in sgplot

Re: Resizing xaxis in sgplot

Re: Adding a greater than or equal sign to title in sgplot

Re: Importing a .xlsx file into SAS

Re: Creating macros for titles

Re: Creating macros for titles

Re: Creating macros for titles

Styles for last line in proc report

Re: Creating macros for titles

Re: Troubleshooting proc report

Creating macros for titles

Troubleshooting proc report

Re: Scan Function

Re: Scan Function

Scan Function

Re: Wrap Text of Values on Y axis in proc sgplot

Re: Wrap Text of Values on Y axis in proc sgplot

Re: Wrap Text of Values on Y axis in proc sgplot

Re: Wrap Text of Values on Y axis in proc sgplot