Guys, I am trying to create an excel report, by using ods tagsets.excelxp.   Title1:I got this Title2: Ineed this Title2: I need this       Month Previous Month Future Month       Mar Feb Apr Apr Mar May   ods tagsets.excelxp file="...\abc.xml" options(embed_titles='yes'); title "I got this"; proc print...; run; ods tagsets.excelxp close;   What changes, do I need to do for the code, if I want Title2 and Title3, respective to Previous Month and Future Month Columns?   Thank YOU ... View more

I've the below data. If an item from the below dataset, is more thatn 10% of the whole items, I want it separate bucket. Thanks. ITEM apples apples tomotos tomotos peppers peppers xyz abc xyz abc abc xyz abc xyz abc tuv tuv tuv tuv abc xyz tuv ... View more

%macro try(dsn=); proc sql; create table required as select * from &dsn. where condition=x quit; %mend try;   I'm able to get the correct result if I call   %try(dsn=abc)   What if I have few dsn's and concatenate them by using set statement, within the same above macro.   Thak yoiu.   ... View more

INPUT DATA VAR1                VAR2  ABC                     30  BBC                     40  CNE                    20  BRE                    10       OUTPUT DATA INPUT DATA VAR1                VAR2  ABC                     30  BBC                     40  CNE                     20  BRE                     10 VAR2TOTAL       100   Only the VAR2 result has to be displayed with PROC PRINT, ALONG WITH TEXT  'VAR2TOTAL'   Thank you. ... View more

Input: 21 22 21 21 23 22 21 21 22 23 22 Needed ouput: distinct   times 21           5 22           4 23           2 ... View more

Our SAS EG is migrating from 4.3 to 7.12, and our SAS Version is migrating from 9.2 to 9.4 We have license only for the below items, as per our license. Base SAS Software                                                                                   SAS/STAT                                                                                           SAS/GRAPH                                                                                             SAS/ETS                                                                                              SAS Integration Technologies                                                                          SAS/Secure 168-bit                                                                                    SAS/Secure Windows                                                                                   SAS Enterprise Guide                                                                                  SAS/ACCESS Interface to DB2                                                                           SAS/ACCESS Interface to PC Files                                                                     SAS/ACCESS Interface to ODBC                                                                         SAS/ACCESS Interface to OLE DB                                                                       SAS Workspace Server for Local Access                                                               High Performance Suite                                                                              SAS Add-in for Microsoft Excel                                                                        SAS Add-in for Microsoft Outlook                                                                      SAS Add-in for Microsoft PowerPoint SAS Add-in for Microsoft Word As a newbie in Admin, I need to select the capabilities of EG, only as per our license. Which capabilitis can I select for user, in Management Console. Please advise.     ... View more

Need a Base SAS program, that can run for 30 minutes to 60 minutes. We need to run the program, as part of Performance Testing , between SAS9.2 and SAS9.4. The program should have FULLSTIMER option. Your help is greatly appreciated. Thanks. ... View more