cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RobertNYC
‎05-13-2019
  • 111 Posts
  • 6 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Embedding Excel Formals

by Obsidian | Level 7 in ODS and Base Reporting
‎05-30-2012 11:00 AM
‎05-30-2012 11:00 AM
Hi Cynthia-- I was actually looking for documentation embedding excel formulas using PROC REPORT and  TAGATTR style override but I could not find any. Can you recommend something? And yes, the link you provided above was one of the things I was talking about. Thanks! ... View more

Re: Embedding Excel Formals

by Obsidian | Level 7 in ODS and Base Reporting
‎05-30-2012 09:24 AM
‎05-30-2012 09:24 AM
Sorry the formulas are these: % of Regular Beds not in VC    =IF(B3=0,0,C3/B3)   % of FBH Beds Vacant in VC     =IF(E3=0,0,F3/E3) ... View more

Embedding Excel Formals

by Obsidian | Level 7 in ODS and Base Reporting
‎05-30-2012 09:20 AM
‎05-30-2012 09:20 AM
Hi all— I’d like to embed excel formals into a spreadsheet when it generates and I was going to use ExcelXP and proc report. I’m having trouble understanding the documentation – there seem to be a lot of ways to write the code. Below is an example of the finished product I’m trying to produce. A B C D E F G Agency  Regular_Beds Regular_Beds_not_in_VC % of Regular Beds not in VC Beds_in_VC Beds_Vacant_in_VC % of FBH Beds Vacant in VC Agency ABC 71 26 37% 97 16 16%                                                                                  =IF(B3=0,0,C3/B3)                                               =IF(E3=0,0,F3/E3) Any help will be greatly appreciated! ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-27-2012 08:54 AM
‎03-27-2012 08:54 AM
Wherever Haiko is from SAS newbies must be pretty grateful. Ksharp, you’ve answered a couple questions for me too (really well),which helped out in some tricky situations and helped me learn this stuff. Thanks! ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-27-2012 08:50 AM
‎03-27-2012 08:50 AM
Hi  Haikuo. Man, thanks. You seem to me to be an absolutely genius. I don’t know hash code, again (and only if you have time)could you please explain the above to me?  I really don’t understand most of it.  Some day I promise, I’ll answer a question ortwo for you. Thanks! ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-26-2012 11:16 PM
‎03-26-2012 11:16 PM
and this Input (Agency_Name Program_Name) (:&$12.)    var1    var2    var3 ; ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-26-2012 11:13 PM
‎03-26-2012 11:13 PM
Thanks Hikuo. Would you be so kind though and explain to me what you did? I'm still a SAS newbie. The staments in bold I've never used before. Thanks data want; merge have1 have2; by     Agency_Name    Program_Name; Agency_Name2=ifc(q1=.,'',Agency_Name); Program_Name2=ifc(q1=.,'',Program_Name); output; call missing (of q1-q3); run; ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-26-2012 11:09 PM
‎03-26-2012 11:09 PM
Hi, I've tried both sql join and merge and I can't figure it out.  So, yes either is fine. ... View more

A Difficult Join

by Obsidian | Level 7 in SAS Procedures
‎03-26-2012 10:43 PM
‎03-26-2012 10:43 PM
Hi all-- I’ve been trying a lot of different combinations of proc sql join statements but I can’t get this to work. I have two datasets a need to join.  I need to join Dataset 2 to Dataset 1  by Agency_Name and Program_name.  The new data set needs to look a certain way. Please see the data sets below. Data set 1 Agency_Name Program_Name var1 var2 var3 Agency A Program 1 1 1 2 Agency A Program 1 1 1 1 Agency A Program 1 1 1 2 Agency A Program 1 1 1 1 Agency A Program 1 1 1 2 Agency A Program 1 1 1 2 Agency A Program 2 1 1 1 Agency A Program 2 1 1 2 Agency A Program 2 1 1 2 Agency B Program 2 1 1 2 Agency B Program 2 1 1 1 Agency B Program 3 1 1 1 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 1 Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 1 Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Data set 2 Agency_Name Program_Name Q1 Q2 Q3 Agency A Program 1 1 1 2 Agency A Program 1 1 1 1 Agency A Program 2 1 1 2 Agency A Program 2 1 1 1 Agency A Program 2 1 1 2 Agency B Program 2 1 1 2 Agency B Program 2 1 1 1 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 1 Agency C Program 3 1 1 1 Agency C Program 3 1 1 2 Agency D Program 1 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 I need to join Dataset 2 to Dataset 1  by Agency_Name and Program_name.  The final product should look like this: NEW Data set Agency_Name Program_Name var1 var2 var3 Agency_Name Program_Name Q1 Q2 Q3 Agency A Program 1 1 1 2 Agency A Program 1 1 1 2 Agency A Program 1 1 1 1 Agency A Program 1 1 1 2 Agency A Program 1 1 1 2 . . . . . Agency A Program 1 1 1 1 . . . . . Agency A Program 1 1 1 2 . . . . . Agency A Program 1 1 1 2 . . . . . Agency A Program 2 1 1 1 Agency A Program 2 1 1 1 Agency A Program 2 1 1 2 Agency A Program 2 1 1 2 Agency A Program 2 1 1 2 Agency A Program 2 1 1 1 Agency B Program 2 1 1 2 Agency B Program 2 1 1 2 Agency B Program 2 1 1 1 Agency B Program 2 1 1 1 Agency B Program 3 1 1 1 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 Agency B Program 3 1 1 2 . . . . . Agency B Program 3 1 1 2 . . . . . Agency B Program 3 1 1 2 . . . . . Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 1 Agency C Program 3 1 1 1 Agency C Program 3 1 1 2 Agency C Program 3 1 1 1 Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 Agency C Program 3 1 1 2 . . . . . Agency C Program 3 1 1 2 . . . . . Agency C Program 3 1 1 1 . . . . . Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 Agency D Program 1 1 1 2 . . . . . Agency D Program 1 1 1 2 . . . . . Agency D Program 1 1 1 2 . . . . . Agency D Program 1 1 1 2 . . . . . Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 Agency D Program 2 1 1 2 . . . . . Agency D Program 2 1 1 2 . . . . . Agency D Program 2 1 1 2 . . . . . Any assistance is greatly appreciated!  Thanks! ... View more

Assigning labels to a large amount of variables

by Obsidian | Level 7 in SAS Procedures
‎03-09-2012 04:49 PM
‎03-09-2012 04:49 PM
I have a dataset with about 500 variables. The all startwith the prefix “ftc”. So, ftc1, ftc2, ftc3, ftc4…. I have to assign a label to each one removing the “ftc” and replacing it with a “Q” so Q1, Q2, Q3, Q4. Isthere a ay to do this to a very large group of variables at once? ... View more

Re: Formatting Crosstabs

by Obsidian | Level 7 in SAS Procedures
‎02-21-2012 12:36 AM
‎02-21-2012 12:36 AM
As soon as i get back to my computer, i wil try this out and let you know. Thanks! ... View more

Formatting Crosstabs

by Obsidian | Level 7 in SAS Procedures
‎02-20-2012 04:00 PM
‎02-20-2012 04:00 PM
Hi Art- this is great, thanks so much. I am away from my computer so I can't test this out. I do have a few questions. Is "myheader"  a statement? Do I repeat this process with every crosstab for every question I want to run frequencies for? Since every question has a different title and the ODS statment only has one crosstab, I'm a little confused. How do I change the font? Thanks so much. ... View more

Formatting Crosstabs

by Obsidian | Level 7 in SAS Procedures
‎02-20-2012 12:23 PM
‎02-20-2012 12:23 PM
Yes, I have. That's exactly what I was looking at. If you notice the example code I'm useing, its from that paper. I'm still have trouble figureing it out. ... View more

Formatting Crosstabs

by Obsidian | Level 7 in SAS Procedures
‎02-20-2012 11:52 AM
‎02-20-2012 11:52 AM
Hi all-- I have a series of crosstab tables I would like to format for a report. All I want is to is change the font,add % signs, add titles for all the questions and sections and add page numbers.  I have been trying to figure out proc template but I’m been having trouble. This is an example of what I'm trying to format. SECTION ONE How long have you lived XYZ? procfreq data=work.data; tablesOffice*Q1 / norow nocol; run; Do you like to read? procfreq data=work.data; tablesOffice*Q2 / norow nocol; run; SECTION TWO Do you like to play chess? procfreq data=work.data; tablesOffice*Q3 / norow nocol; run; What is your favorite restaurant? procfreq data=work.data; tablesOffice*Q4 / norow nocol; run; Here is an example of the code Ihave being experimenting with: proctemplate; definecrosstabs Base.Freq.CrossTabFreqs; cell_style={font=fonts('Arial Narrow') foreground= whatever }; row_total_style={foreground=whatever}; col_total_style={foreground=whatever }; grand_total_style={foreground=whatever }; end; odslisting close; odshtml file=test.pdf; Any help is greatly appreciated. Thanks. ... View more

Proc SQL: When Then Else

by Obsidian | Level 7 in SAS Procedures
‎02-12-2012 09:57 PM
‎02-12-2012 09:57 PM
Hi Hai.kuo-- I tried to run your code and it did not work. I recived an error messsage that was like "If" is not vali. Id the code supposed to be: newpoints=ifn(oldpoints>1.05,1.05,oldpoints); and is it ifn or just if? Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-13-2019 07:07 PM
Likes given to
View All
Likes from
View All
Quick links