sas • View topic • proc printto print="filename" not working in interactive sas

proc printto print="filename" not working in interactive sas

2 posts • Page 1 of 1

Jump to:

Next

1. hash table note message
Hi, I am looking at hash tables and trying to understand their use. So far I have the following test code that does a look up on the school dataset from the sashelp.class dataset. This seems to produce the dataset that I want (at least in this simple example) but I get a log note that the variable school is not initialised. Does this mean that I am not using the hash table correctly. I would like to try to use hash tables for large datasets (obs> 4 million), but am still not sure that I fully understand their use. The ht.defineKey("sex"); line apperars to be like a sort of 'by' varable in a merge, and the ht.defineData("school"); line appears to indicate the variable (s) to add if there is a match. Is this correct? If I comment out the line beginning with sex='F' the program only returns the values where there is a match (due to if ht.find()=0;) Any help appreciated. proc delete data=work._all_; run; data new; set sashelp.class; run; data school; sex='M'; school='Auguston';output; sex='F'; school='Christie';output; run; data hash; length school $8; if _n_ =1 then do; declare hash ht(dataset: "work.school"); ht.defineKey("sex"); ht.defineData("school"); ht.defineDone(); end; set new; if ht.find()=0; run; proc print; run;
2. It Works!!!
A US based home business that really works!!! Redefining the global need of online computer technical support and computer educational training programs, it has gain acceptance and captured market shares in 96 countries worldwide since it was founded in 2002. It presents a well structured compensation package you can earn substantially at your own pace. It caters to your choice of marketing the products. Do whatever that fits you, direct selling, retailing, or online advertising, there are multiple options you can be effective with. Just spare a little time to learn, Great earnings may just be a right click away. Email me on this link: XXXX@XXXXX.COM To subscribe, please include the following: Subject : more info First Name: __________________ Last Name: __________________ Country : __________________ To unsubscribe, reply with "Remove Me" as subject. Thank you very much, Alden Cadag Cebu, Philippines, 6000
3. how to upcase entire dataset..
How do you convert all data in a dataset to uppercase? i know how to do individual variables..but would like to do it to all data.. (assume all data are character vars).Thanks for your help, Nevin
4. Superscript 4?
Hi SAS-Lers, I found the following code on the SAS website: data _null_; x = 'B9'x; /* superscript 1 */ y = 'B2'x; /* superscript 2 */ z = 'B3'x; /* superscript 3 */ call symput('macv1',x); call symput('macv2',y); call symput('macv3',z); run; Is there a way to extend this code so that I can get superscripts higher than 3, e.g., superscript 4, 5, etc? Thanks in advance. Carey G. Smoak
5. Friday afternoon question
People, I sent the majority of my output to my users in excel spreadsheet form. Can I get a few thoughts on how to include say the rundate, the program that created the report, the name of the programmer? Just kind of wondering what other do ? Thanks Dave

proc printto print="filename" not working in interactive sas

by rolandberry » Fri, 07 May 2004 16:23:40 GMT

I use sas in batch exclusively but I have to make sure interactive
users can use my macros. One of these macros redirects print output
using "proc printto print='filename'". This works in batch but when I
run it interactively, instead of sending the print output to the file
I specified, it still uses the output window. How do I get this to
work correctly in interactive sas?

Re: proc printto print="filename" not working in interactive sas

by rolandberry » Sat, 08 May 2004 00:02:39 GMT



Spotted it. I need to use the "nowd" option with "proc report" and then it is fine.

Similar Threads:

1."proc printto print=log" does not work.

"proc printto print=log" does not work for me. It does not complain -
it's just that the print output does not go to the log. I was sure
that this has worked in the past. Wassup?

2.Proc printto print statement not working in Enterprise Guide

3.SAS - Filenames for concatenated datastets - JFCB not working

I am looking to get the names of all the concatenated dataset for an
INFILE for further processing. The following is how I have coded so
far ....


JCL has:

//INREQTS   DD DISP=SHR,DSN=OLVT.XFTP.ARPCDROM.RQSTFILE.G0056
//          DD DISP=SHR,DSN=OLVT.XFTP.ARPCDROM.RQSTFILE.G0058
//          DD DISP=SHR,DSN=OLVT.XFTP.ARPCDROM.RQSTFILE.G0059


SAS Data step:


DATA MASTER RQSTFILE(KEEP=REQFGOVO ACCTNUM);
     INFILE INREQTS END=LAST RECFM=V JFCB=JFCB LENGTH=LEN
     EOV=FIRST_RECORD;

     LENGTH REQFGOVO   $44;
     RETAIN I 0 ;

     RECORD = _N_;

     I = 1;

     INPUT @;

    IF _N_ =1 or FIRST_RECORD
       THEN DO;
                   REQFGOVO = SUBSTR(JFCB,
1,44);
                  OUTPUT RQSTFILE;
                END;
...
....
....
      OUTPUT MASTER;

RUN;

 PROC PRINT DATA=RQSTFILE;
      VAR REQFGOVO ;


SASLIST Shows:

Obs             REQFGOVO

 1  OLVT.XFTP.ARPCDROM.RQSTFILE.G0056
 2  OLVT.XFTP.ARPCDROM.RQSTFILE.G0059
 3  OLVT.XFTP.ARPCDROM.RQSTFILE.G0059


There one record in each of the files,  I am getting all the 3 records
for further processing but not sure why G0058 is not showing ...

Your assistance in this matter will be greatly appreciated.

Thanks

4.Clearing work.GSEG window when working with GPLOT interactive

Dear SAS-L,

Does anyone know how to clear the work.GSEG window of plots from consecutive
plots (work.gseg.glpot[1..n]) when working with
SAS and running glpot interactively.

Thanks, any help is appreciated.

Jake

5.Print Preview not working

Using 9.1. (Badly)

When I try to use Print Preview from the Output window I've started
getting the message;
"The current printer settings do not allow Print Preview."

This has probably started as a result of my futile attempts to get my
program to produce its two reports in Portrait & Landscape format
respectively. I went tinkering with things that I don't know alot/
anything about but now can't manage to get Print Preview back working.

Can anyone help me with this?


cheers
Phil

6. Mainframe Interactive SAS expanded WORK library

7. How not to create proc print and proc gchart output on different page

8. proc report sas to excel: break not working

2 posts • Page 1 of 1

Who is online

Users browsing this forum: No registered users and 63 guest