As Cynthia pointed out, have you tried any SAS PROC, such as PROC REPORT, PROC SUMMARY (with PRINT), or PROC MEANS? With a SAS DATE variable, you can look into using INTNX function within a DATA step to create a suitable "week start" or "month start" date and then use a suitable SAS FORMAT statement for displaying the date as you desire. Are you looking to others on the forum to write the code for you? That is why I am inquiring about what, if any, SAS program coding you have attempted, to solve your quest. Scott Barry SBBWorks, Inc. Recommended Google advanced search argument for this topic: create summary report site:sas.com -- one match to consider: SAS DOC: Practical Problem-Solving with PROC SQL http://support.sas.com/documentation/cdl/en/sqlproc/62086/HTML/default/a002536887.htm ... View more

Demonstrate with INPUT data and OUTPUT information, as you would like to see generated by a SAS program. Scott Barry SBBWorks, Inc. ... View more

The SAS support http://support.sas.com/ website has not only SAS-hosted product documentation but also supplemental technical and conference topic-related papers. Using the website SEARCH facility or possibly using the Google advanced search argument below revealed several interesting references to consider reviewing: proc sql merge site:sas.com Scott Barry SBBWorks, Inc. ... View more

Data a; set b; do i = 1 to 100000; output; end; run; ... View more

Can you be more specific about your situation? Where is the flat file stored vs your SAS session? Where do you want to store the imported data? Why do you think you need pass thru? SQL pass thru generally is used for work with data base data, not raw data. /Linus ... View more

You may want to contact SAS support and open a track, however I did find a usage note (link info below) on the SAS support http://support.sas.com/ website, possibly helping diagnose the problem. Scott Barry SBBWorks, Inc. Usage Note 17230: How to log report access information for SAS Web Report Studio http://support.sas.com/kb/17/230.html ... View more

Please open a track with our Technical Support Department in order to get assistance: http://support.sas.com/ctx/supportform/createForm Vince DelGobbo SAS R&D ... View more

I was also wondering about your question and I received the reply as below, PROC SUMMARY and PROC MEANS are the same underneath, but MEANS defaults to print output and SUMMARY does not. ... View more

PROC REPORT also supports cross-tabular table creation with the ACROSS usage in the DEFINE statement. As you can see, both procedures are capable of producing the same cross-tabular report. The fact is that for simple cross-tabs, you could use either procedure. For more complicated cross-tabs -- where there are a LOT of nestings in the row and column dimension, my tendency is to use PROC TABULATE. cynthia [pre] proc sort data=sashelp.shoes out=shoes; by region product; where region in ('Asia', 'Canada', 'Pacific') and product contains 'Dress' or product contains 'Casual'; run; ods listing close; ods html file='c:\temp\report_cross.html' style=sasweb; proc report data=shoes nowd style(summary)=Header; title '1) With Proc Report'; column region product,(sales returns) ('Total' sales=totsales returns=totreturns); define region /group style(column)=Header; define product / across; define sales / sum 'Sales'; define returns / sum 'Returns'; define totsales / sum 'Sales'; define totreturns / sum 'Returns'; rbreak after / summarize; compute after; region = 'Total'; endcomp; run; proc tabulate data=shoes f=dollar14.0; title '2) With Proc Tabulate'; class region product; var sales returns; table region all*{s=Header}, product*(sales returns) all*(sales returns) / style_precedence=row; keylabel sum=' ' all = 'Total'; label sales = 'Sales' returns = 'Returns'; run; ods html close; [/pre] ... View more

I just saw data_null_ beat me to it. Anyway . . . This is an example of how I would do it, but it takes a couple steps. In this example, I create three datasets with different variable formats. After merging these sets, I determine the numeric variables using PROC CONTENTS and PROC SQL and then limit my final dataset to just those variables. [pre]data a (keep=VarA:) b (keep=VarB:) c (keep=VarC:); VarA1 = 8; VarA2 = 'Yes'; output a; VarB1 = 'True'; VarB2 = 256; output b; VarC1 = 'Positive'; VarC2 = 'Nebraska'; VarC3 = 87.9; output c; run; data x; merge a b c; run; proc contents data=x out=contents (keep=name type) noprint; run; proc sql noprint; select name into :varlst separated by ' ' from contents where type = 1; quit; data x; set x; keep &varlst; run; [/pre] Message was edited by: 1162 ... View more

SAS Viewer is unable to open 64 bit data sets, only 32 bit data sets. Search support.sas.com for more information. ... View more

This is most definitely an issue for tech support. ... View more

Hi: This is not the forum for IMPORT Wizard problems -- since the IMPORT Wizard is not generally involved in ODS and Base SAS Reporting (PRINT, REPORT, TABULATE) production of reports. If you are having trouble with PROC IMPORT and/or need a SETINIT, your best and fastest resource is to open a track with Tech Support. To send a question to Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem". cynthia ... View more

SAS support website reference for National Language Support or NLS: http://support.sas.com/documentation/onlinedoc/nls/ Scott Barry SBBWorks, Inc. ... View more

Hi: This is not an ODS or Base Reporting (PRINT, REPORT, TABULATE) procedure question. For more help using SAS and understanding the Statistical procedures, you might consider finding textbooks on the subject or looking for books at SAS Press, such as: SAS System for Elementary Statistical Analysis By Sandra D. Schlotzhauer, Ramon C. Littell ISBN 1580250181 http://books.google.com/books/sas?id=9iS-BzNa0dYC&dq=Schlotzhauer or Step-by-step Basic Statistics Using SAS By Larry Hatcher ISBN 1590471482 http://books.google.com/books/sas?id=wzUtj84oxdMC&dq=Statistics You can search for more books here: http://support.sas.com/publishing/bookstore.html cynthia ... View more