[sas-users] ODS Help!

[aneesah.n.williams at census.gov]

I'm working on PC SAS.  So, I'm not sure if the x command will work there.
I removed the path and just left the filename in the ods statement.  So, I
am just cutting and pasting from the J: folder.

Thanks,

Aneesah

======================
Aneesah Williams
Statistical Methods Branch
Governments Division
U.S. Census Bureau
301-763-5995



                                                                                                                                       
  From:       matthew.nelson at census.gov                                                                                                
                                                                                                                                       
  To:         sas-users list for SAS Users Group <sas-users at lists.census.gov>                                                          
                                                                                                                                       
  Date:       09/02/2011 09:06 AM                                                                                                      
                                                                                                                                       
  Subject:    Re: [sas-users] ODS Help!                                                                                                
                                                                                                                                       
  Sent by:    sas-users-bounces at lists.census.gov                                                                                       
                                                                                                                                       






My guess is that SAS is interpreting your file reference as a filename, not
a pathname. I'm not certain why this would be happening, but I have a
possible work-around.

First, is "J:\NPEFS\Imputation Research..." your current working directory?
(you can confirm by checking the right pane of the status bar, at the very
bottom of your SAS session).

If so, then double-click on it and change it to M:\50d_Stat Support &
Consulting\GOVS_FIN\2007\Response Rates\. Alternatively, you can submit the
statement:
x cd "M:\50d_Stat Support & Consulting\GOVS_FIN\2007\Response Rates\";

Then, just change your code to say: ods csvall file =
"st_and_localtqrr_resprate&iter..csv";

Hopefully that works, -Matt

                                                                           
 From:           aneesah.n.williams at census.gov                             
                                                                           
 To:             sas-users at lists.census.gov                                
                                                                           
 Date:           09/02/2011 08:36 AM                                       
                                                                           
 Subject:        [sas-users] ODS Help!                                     
                                                                           
 Sent by:        sas-users-bounces at lists.census.gov                        
                                                                           







Can someone please help me understand why this error is occurring.  I don't
know why the J:\NPEFS...folder is even showing up in this log.  I have not
done anything with that folder since booting up today.

697  ods csvall file = "M:\50d_Stat Support & Consulting\GOVS_FIN\2007
\Response
697! Rates\st_and_localtqrr_resprate&iter..csv";
NOTE: Writing CSVALL Body file: M:\50d_Stat Support & Consulting\GOVS_FIN
\2007\Response
     Rates\st_and_localtqrr_resprate_3.csv
ERROR: Physical file does not exist, J:\NPEFS\Imputation Research\Time
Series\Results\M:\50d_Stat
      Support & Consulting\GOVS_FIN\2007\Response Rates
\st_and_localtqrr_resprate_3.csv.
WARNING: No body file. CSVALL output will not be created.
698  title 'State and Local Total Quantity Response Rates By State ';
699  title2 'For Revenue, Expenditures, Debt, Assets';
700  proc print data=nonresp.nonresponsebiases_sl&iter. noobs label;
701      format state $stfmt.  aga001totQuanRR percent8.1 aga002totQuanRR
percent8.1
702             aga004totQuanRR percent8.1 agb012totQuanRR percent8.1;
703      var state aga001totQuanRR aga002totQuanRR aga004totQuanRR
agb012totQuanRR statecode;
704  run;

NOTE: Writing HTML Body file: sashtml10.htm
NOTE: There were 51 observations read from the data set
NONRESP.NONRESPONSEBIASES_SL_3.
NOTE: PROCEDURE PRINT used (Total process time):
     real time           0.20 seconds
     cpu time            0.03 seconds


705  title; title2;
706  ods csvall close;

Thanks,

Aneesah

======================
Aneesah Williams
Statistical Methods Branch
Governments Division
U.S. Census Bureau
301-763-5995

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users