Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Proc Report Problem
Just a FYI I simpily included display in the define statement for the variable out_type and then included noprint to suppress the actual display of it. I never realised they could all be used together. Thanks for the help provided. :)- Jayla
- Post #6
- Forum: SAS Institute, Inc. solutions
-
Proc Report Problem
Thank you for your help Chris. It certainly provoked me to explore other variations of the syntax. I ended up with: ods html file="t:\james\reports\sas\format_test.html" style=style.newfont; proc report data=rwork.plus_3_trucks_detail nowd; columns total_faults total_trucks account_no...- Jayla
- Post #5
- Forum: SAS Institute, Inc. solutions
-
file renameing (how to)
Here is an example Public Sub RenameFiles() Dim fsoX As FileSystemObject Dim strDirectory As String Dim strCompanyName As String Dim fileX As File Dim intMMW_Length As Integer 'Create a new file system object to work with Set fsoX = New FileSystemObject...- Jayla
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Proc Report Problem
Sorry for triple post I can't see an edit post option. Maybe I should prove read my posts with more care. :-P The second post was refering to my remaining problem being none of the rows have any colour changes applied to them. I assume this is because of either incorrect define statement usage...- Jayla
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Proc Report Problem
OK my apologies, I think I have solved one part of my problem, however I still have an issue: ods html file="t:\james\reports\sas\format_test.html" style=style.newfont; proc report data=rwork.plus_3_trucks_detail nowd; columns total_faults total_trucks account_no account_name address...- Jayla
- Post #2
- Forum: SAS Institute, Inc. solutions
-
Proc Report Problem
Hi! .o/ I'm implementing some changes into an existing report that I currently produce. The report is produced weekly and reports data down to customer level. If a customer was not on the report last week it should appear in the colour red, if it was removed from the report 14 days ago (or...- Jayla
- Thread
- Replies: 5
- Forum: SAS Institute, Inc. solutions
-
Replace "name" with "key"
You could do it with formulas Sheet1 names bob sue jim james bob james sue fred jim fred Sheet2 (NB: now ordered by name) key name key 14 bob 14 25 fred 25 61 james 61 22 jim 22 28 sue 28 Sheet3 key =VLOOKUP(Sheet1!A2,Sheet2!$B$1:$C$6,2,FALSE) =VLOOKUP(Sheet1!A3,Sheet2!$B$1:$C$6,2,FALSE)...- Jayla
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
