Hi   I am trying to export my regression results to an excel file after running all the regressions. I need all the results to be on a single sheet but the ODS statement that I have sends each table to a seperate sheet:   data a; set ev.final2; if amval4wp ne 0 and amval4wp ne . then ratio=tmval4wp/amval4wp; lnTEq=log(EqValAn); lnTEn=log(EnValAn); lnTMV=log(TMVal4wp); lnAMV=log(amval4wp); lnSIZE=log(HOSTATASS); year = year(Andate); Industry= TMaCode; run; ODS TAGSETS.EXCELXP file='C:\Users\esy\Desktop\niloofar\DePaul Research\M&AJAPAN\Majority\Results\regression.xls' STYLE=minimal OPTIONS ( Orientation = 'landscape' FitToPage = 'yes' Pages_FitWidth = '1' Pages_FitHeight = '100' ); proc glm data=a; class ConsiStr type year Industry; model Acar1 = year / noint; QUIT; run; proc glm data=a; class ConsiStr type year Industry; model Acar1 = ratio / noint; QUIT; run; proc glm data=a; class ConsiStr type year Industry; model Acar1 = TobinQ/ noint; QUIT; run; ...(more proc glm statements) proc glm data=a; class ConsiStr type year Industry; model Acar1 = ADebtratio ratio / noint; QUIT; run; I need the exported excel to look like this: Thanks, Niloo ... View more

Hi, I am trying to learn SAS using the videos on YouTube:How to Use SAS - Lesson 3 - Importing External Data - YouTube. When I run the statement to import a text file I see the following warnings in the log: 114  data infile_main; 115  infile "C:\eventus\main.txt" LRECL=100 DLM=' ' firstobs=2; 116  input 117  x y z; 118  run; NOTE: The infile "C:\eventus\main.txt" is:       Filename=C:\eventus\main.txt,       RECFM=V,LRECL=100,File Size (bytes)=21,       Last Modified=13Aug2015:19:25:41,       Create Time=13Aug2015:19:25:38 NOTE: Invalid data for x in line 2 1-5. NOTE: Invalid data for y in line 3 1-5. NOTE: LOST CARD. NOTE: Invalid data errors for file '"C:\eventus\main.txt"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. x=. y=. z=. _ERROR_=1 _N_=1 NOTE: 2 records were read from the infile "C:\eventus\main.txt".       The minimum record length was 5.       The maximum record length was 5. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.INFILE_MAIN has 0 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time          0.02 seconds       cpu time            0.01 seconds Here are my statements: data infile_main; infile "C:\eventus\main.txt" LRECL=100 DLM=' ' firstobs=2; input x y z; run; This is not the only time I have problem importing the data using data statements. I do not have any trouble importing the data using proc import or File>Import Data. Could you please tell me what is my mistake here? Thanks, Niloo ... View more

Hi, I am trying to import a csv file into sas using an example: /* Create the market index returns data set. This  */ /* example uses a SAS data step to read a CSV file,*/ /* but you can use any SAS method to create the    */ /* data set. The code below also checks the dates  */ /* to see whether they fall between a particular   */ /* date and today; if not, they must not have been */ /* read correctly. Check the PC SAS Log for a mess-*/ /* age generated by the data step. It is also best */ /* to view the SAS data set manually.              */ data MarketIndex; /* Change C:\Folder below as needed */ infile 'C:\Folder\NonCRSPStudy-Index.csv' end=_lastobs_            dlm=',' truncover firstobs=2; input CalDt:mmddyy10. VWRetD; format CalDt yymmddn8.; if not ('01JAN1925'D<CalDt<today()) then do;   put 'ERROR: Check dates! Example: ' _n_= CalDt=yymmddn8.;   stop; end; else if _lastobs_ then put 'Dates appear plausible.'; run; I modified the statements( in green) to use them on my own data: my file is located in evantus folder in my drive C my index is equally weighted hence: ewretd my dates start from 12/10/1999 data MarketIndex; infile 'C:\evantus\MSCI.csv' end=_lastobs_            dlm=',' truncover firstobs=2; input CalDt:mmddyy10. ewretd; format CalDt yymmddn8.; if not ('10Dec1999'D<CalDt<today()) then do;   put 'ERROR: Check dates! Example: ' _n_= CalDt=yymmddn8.;   stop; end; else if _lastobs_ then put 'Dates appear plausible.'; run; The log says: 6886  data MarketIndex; 6887   infile 'C:\evantus\MSCI.csv' end=_lastobs_ 6888             dlm=',' truncover firstobs=2; 6889   input CalDt:mmddyy10. ewretd; 6890   format CalDt yymmddn8.; 6891   if not ('10Dec1999'D<CalDt<today()) then do; 6892    put 'ERROR: Check dates! Example: ' _n_= CalDt=yymmddn8.; 6893    stop; 6894   end; 6895   else if _lastobs_ then put 'Dates appear plausible.'; 6896  run; NOTE: The infile 'C:\evantus\MSCI.csv' is:       Filename=C:\evantus\MSCI.csv,       RECFM=V,LRECL=32767,File Size (bytes)=87520,       Last Modified=03Aug2015:09:19:06,       Create Time=03Aug2015:09:19:18 NOTE: 0 records were read from the infile 'C:\evantus\MSCI.csv'. NOTE: The data set WORK.MARKETINDEX has 0 observations and 2 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds NOTE: This SAS session is using a registry in WORK.  All changes will be lost at the end of       this session. And the created MarketIndex file has 0 observations. Why can't my sas read the observations? Thanks, Niloo ... View more