Kick-start Your Data Exploration Journey with SAS Information Catalog
Recent Library Articles
Recently in the SAS Community Library: @smanoj introduces you to the SAS Information Catalog, which provides a powerful search engine to find needed data assets.
Hi Need help to Highlight mismatched rows(compare 2-3 , 4-5,6-7 rows so on dynamically) data Using SAS while generating a multi sheet excel file . SAS is on Unix server. I am using SAS EG 7.1 Below is the data I have to compare every two rows and highlight the mismatched data while generating the Excel and send it via email. Note - there are multiple sheets and columns vary (sometimes there maybe 10 columns, sometimes it may be 18) I have SAS code(used ODS) to generate excel with multiple sheets and send it via email and separate a VBA macro to highlight the mismatched data which I run manually. But I am unable to integrate both in to single code so that no manual work is needed, I really appreciate if anyone can suggest any way to do it in one single code. Below is sample dataset , rows and column are dynamically created based on the project. Need to compare 2-3,4-5, 6-7..so-on rows and highlight(I have given blue to the font but i need whole box as yellow) only when they don’t match. ssn firstname lastname empid address city state zip 000-11-1234 abc d 1001 plotno 123 abcd rd 12345 000-11-1234 abc e 1001 plotno 123 abcd rd 12345 111-12-3456 efgh f 2001 house 897 tyui fg 23456-789 111-12-3456 efgh f 2001 hs 897 tyui fg 23456 444-56-7890 wrt y 3001 xc 12345 444-56-7890 wert y 3002 xc 12345 my VBA code: Sub compare_Auto() Dim LastColumn As Long LastColumn = ActiveSheet.Range("A1").CurrentRegion.Columns.Count Dim rng As Range, rngDiff As Range Set rng = Range(Cells(2, 7), Cells(3, LastColumn)) Do While Application.CountA(rng) > 0 'loop while have content Set rngDiff = Nothing 'reset range On Error Resume Next 'ignore "No cells were found" error if no differences Set rngDiff = rng.ColumnDifferences(Comparison:=rng.Cells(1)) On Error GoTo 0 'stop ignoring errors If Not rngDiff Is Nothing Then rngDiff.Interior.ColorIndex = 6 'color all differences rngDiff.Offset(-1).Interior.ColorIndex = 6 End If Set rng = rng.Offset(2) 'two rows down Loop End Sub
... View more
Hi. I'm SupermanJP. I updated SAS plotter, modern data visualization package for SAS base. https://github.com/Superman-jp/SAS_Plotter document https://superman-jp.github.io/SAS_Plotter/ new features new plots " MultiHistogram" was available! multihitogram is histogram created by each category variable and pair variable. Box width of histogram is reflect the response variable. multihistogram is used for frequency comparison of multiple category in small display area. This macro was designed based on the report of Wierenga, Madison R et al. (https://www.ncbi.nlm.nih.gov/pmc/articles/PMC8140601/.) official mail address: sasplotter@picolabs.jp official web site (Japanese) https://picolabs.jp Please feel free to contact me if you have any bug reports, feedback, or requests.
... View more
Hi all, I have 4 datasets as below and requirement for the table want are : - Ignore col1 values which are not common for all 4 tables - join all col1 col2 col3 col4 values in the want table to show all different values for col2 in each table. Table 1 col1 col2 1 yes 2 yes 3 yes 4 yes 5 Table 2 col1 col2 1 yes 2 no1 3 yes 4 no1 Table 3 col1 col2 1 yes 2 no2 3 yes 4 no2 Table 4 col1 col2 1 yes 2 no3 3 yes 4 no3 table want col1 col2 col3 col4 col5 1 yes yes yes yes 2 yes no1 no2 no3 3 yes yes yes yes 4 yes no1 no2 no3 Thanks in advance kajal
... View more
Hello,
When we run proc sql with dictionary.formats, we can get following information:
Could any one tell me what 'B', 'U', 'C' stands for in col 'source'?
Thanks.
... View more
Hi,
it is possible to define the height and width of the graph image using the ods graphics statement.
But I could not find an option to define the height and width of the wall space.
It is possible with proc sgplot and/or proc template?
Cheers
... View more