About ChrisHemedinger

ChrisHemedinger · ‎06-21-2013

Yes. Something like: PROC SQL; CREATE TABLE test_table AS SELECT ART_PRO label="%sysfunc(week(%sysfunc(today())))" FROM WORK.COM_VTA_SEM_ANT RUN;

ChrisHemedinger · ‎06-20-2013

There is a Tools->Update Library Metadata task in SAS Enterprise Guide. Tricia has a pretty good guide here: http://www.bi-notes.com/2011/12/sas-enterprise-guide-update-metadata-library/ Chris

mbusa · ‎12-04-2013

Hi, I am having this same problem with SAS itselft. the program seems to execute but SAS hangs up when creating the xml file. Does anyone have any advice as to how to fix this? It is very frustrating!! Best, Michelle

ChrisHemedinger · ‎05-28-2013

An alternative method that might be faster and more reliable: use the Tasks->Data->Download SAS Data Sets task. This will transfer the data as a SAS7BDAT file directly from your SAS Workspace to the local PC. "Export as a Step" works differently: it uses a local SAS Workspace to create a new data set, and creates the file record-by-record. Chris

qkaiwei · ‎05-24-2013

:smileylaugh:

ChrisHemedinger · ‎05-21-2013

This is a "crash" in PROC SQL, and you should follow up with SAS Technical Support with an example of the SQL and the log. Chris

breelloyd · ‎05-12-2013

It looks like the boys are going to build a DB for me, Basically views so I can access all the data, and we'll rename everything. The same goes for Field names right? If I have a table with a field name that is >32 Char, what happens? does it just neglect to import that field or does it cause the whole table import to fail? We have plenty of Table names >32 Char.

ChrisHemedinger · ‎05-03-2013

As said, when comparing stats I usually go for the CLASS statement. As others have pointed out, BY requires the input data to be sorted. However, if your input data is coming from a database library (and not a SAS data set), PROC MEANS is smart enough to ask for the data in "sorted" order before calculating the stats, so a separate PROC SORT step is not necessary. In fact, with SAS 9.2 and later, PROC MEANS will actually get the database to calculate the basic stats if it can: Avg, Sum, Min, Max and so on -- thus saving lots of I/O within your SAS session. Other "database-aware" procs include FREQ, RANK, SUMMARY/MEANS, REPORT, TABULATE. See this SAS Note for more information. Chris

Sheeba · ‎04-24-2013

Thanks a lot Chris. This is really a wonderful Custom task. I will try this. Regards, Sheeba Swaminathan

maradanp · ‎04-22-2013

Thanks a lot Chris. Sure it will help anyway 🙂

Cynthia_sas · ‎05-25-2015

Hi: Macro variable values do NOT resolve when placed in single quotes, as you show here: SELECT DISTINCT ( SUM(table0.CLR_BAL_AMT) where ( table1.ACCT_OPEN_DT ) = '&Report_Date'd ) So, instead, I recommend changing your single quotes to double quotes: SELECT DISTINCT ( SUM(table0.CLR_BAL_AMT) where ( table1.ACCT_OPEN_DT ) = "&Report_Date"d ) cynthia

sas4ml · ‎03-29-2013

Hi, I had responded to a similar issue . It could be a compatibility issue meaning if SAS is 64 bit( can check in HELP) and the Office that you are running is 32 bit. I know in such a situation you normally receive "Class not registered" or Excel engine not found" messages. Try checking the Excel version and if different from SAS version try Installing 64 bit Office 2010 to match your version of SAS . Try the following links in the order given http://www.office.com/office64setup Or The following links involve more steps using PC Server Files with Import Wizard http://support.sas.com/kb/44197 Or Iinstalling a SAS PC File server which provides a bridge between 32 bit Office and 64 bit SAS. http://support.sas.com/kb/43802 Thanks,

saltmarsh · ‎03-26-2013

Thank you all. I was able to make it work based on your advice. One of the issues that I was having was Grouping in the wrong query. Once I figured that out, it works as advertised. Thank you again for your help.

Quentin · ‎04-30-2014

Thanks Chris, Modernization would be lovely. We just finished the jump off of XP, so I may not see the Win2003 server upgraded until it too hits the End-of-life wall. : )

lloraine · ‎03-25-2013

Thank you, I will try this.

Online Status	Offline
Date Last Visited	Friday