Re: search SAS data set from SAS code #2Rose,
The answer to your question depends on your operating system. In Windows,
there's the Search tool. In Unix/Linux, you can use grep
Bob Abelson
HGSI
240 314 4400 x1374
bob_abelson@hgsi.com
Rose <myr_rose@YAHOO.COM>
Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
04/19/2005 11:13 AM
Please respond to myr_rose
To: SAS-L@LISTSERV.UGA.EDU
cc:
Subject: search SAS data set from SAS code
Hi All,
Suppose I have a sas permanent data set which was created early, I know
the library path but I couldn't remember in which sas program code I
created it. how can I search from so many sas program files in
different folders and find it.
thanks in advance.
Rose
...
Re: search SAS data set from SAS code #3Most O/S have a search feature, eg. Windows has search/find command off Start button, will look inside files for a string, eg. our libname / directory. Ultraedit has a handy search feature as well. On 'NIX, you'll use grep, mainframe, 3.something.
Consider putting the program name in the data set label ( which shows up in CONTENTS ) at creation time to better keep track of this type of thing.
data libname.mydata ( label = "Created by pgm" );
...
run;
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Rose
Sent: Tuesday, April 19, 2005 11:14 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: search SAS data set from SAS code
Hi All,
Suppose I have a sas permanent data set which was created early, I know
the library path but I couldn't remember in which sas program code I
created it. how can I search from so many sas program files in
different folders and find it.
thanks in advance.
Rose
__________________________________________________________________________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations.
Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized.
If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courrier �lectronique est confidentiel et prot�g�...
Re: search SAS data set from SAS code #5Rose,
You have some good advice on search techniques, but they may beinadequate.
I hope your LIBNAME wasn't something like
libname lib "&dir" ;
Perhaps you should also search for ".member", but that also couldhave the same problem. You might also look for key variablenames or values, or procedures that you know created the data.The date from a PROC CONTENTs might provide useful information,or an old report created by the same program with a footnote,"Source code: ...".
Maybe
data lib.w ( label="created by ..." ) ;
would be a good habit to develop in the future. Then goodorganization also helps.
Sorry, I haven't got a good solution, but it is possible to learnfrom mistakes and wise to do so. Otherwise, they tend to getrepeated.
Ian Whitlock===================
Date: Tue, 19 Apr 2005 08:13:41 -0700
Reply-To: myr_rose@YAHOO.COMSender: "SAS(r) Discussion"
From: Rose <myr_rose@YAHOO.COM>Organization: http://groups.google.com
Subject: search SAS data set from SAS codeComments: To: sas-l
Content-Type: text/plain; charset="iso-8859-1"
Hi All,Suppose I have a sas permanent data set which was created early, I know
the library path but I couldn't remember in which sas program code I
created it. how can I search from so many sas program files in
different folders and find it.
thanks in advance.Rose
...
Re: search SAS data set from SAS code #6Rose
In addition to the search tools that have been mentioned, the following
program will search ONE directory and dump all of the SAS programs to a
single flat file. The boundaries of each program are flagged and the source
identified. This file may then be searched with a text editor and you will
be able to see the associated lines of code. Old big-iron geeks may notice
a resemblance to Proc Source which produces similar output. I have tried
running this with a wild card in place of a folder name but that does not
work.
Nat Wooding
dm 'log;clear;output;clear;pgm;';
** note that the member name is not correct. the scan function is not
recognizing the slashes
** as delimiter. reported as us 6125345
** note that the ./ add card may need a bit of editing on the mainframe
** SearchText
** Nat Wooding
** Dominion Virginia Power
** March, 2003
**
** this code lists the statements of any files in a given path that have
the extension
** SAS. The code is displayed in the sas log and the name of the file is
also shown.
** The output window may be searched for specific strings using the find
option in the
** SAS pull down Find command;
data a;
filename txt 'n:\my sas files\natsas\*.sas';
length file $ 50;
infile txt filename=file lrecl=80 truncover;
informat txt $72.;
input txt $ 1-72;;
if index(file,'7bdat') then delete;* do not include sas data sets;
source=file;
source=scan(source,-2 );
/* now, add a b...
Re: search SAS data set from SAS code #4Look at Google Desktop as well. Very fast.
Thanks,
Alan
Savian
"Bridging SAS and Microsoft Technologies"
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Harry
Droogendyk
Sent: Tuesday, April 19, 2005 8:23 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: search SAS data set from SAS code
Most O/S have a search feature, eg. Windows has search/find command off
Start button, will look inside files for a string, eg. our libname /
directory. Ultraedit has a handy search feature as well. On 'NIX, you'll
use grep, mainframe, 3.something.
Consider putting the program name in the data set label ( which shows up in
CONTENTS ) at creation time to better keep track of this type of thing.
data libname.mydata ( label = "Created by pgm" );
...
run;
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Rose
Sent: Tuesday, April 19, 2005 11:14 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: search SAS data set from SAS code
Hi All,
Suppose I have a sas permanent data set which was created early, I know
the library path but I couldn't remember in which sas program code I
created it. how can I search from so many sas program files in
different folders and find it.
thanks in advance.
Rose
____________________________________________________________________________
______________________________________________________
This e-mail may be privileged and/or confidential, and th...
Re: How to filter sas data sets into separate sas data setsLizette,
a quick question first: what release of SAS are you using?
Seems like an ideal task for a hash solution. Hashes however are only available with SAS version 9.
Robert Bardos
Ansys AG, Zurich, Switzerland
> -----Ursprüngliche Nachricht-----
> Von: SAS(r) Discussion
> [mailto:SAS-L@LISTSERV.UGA.EDU]Im Auftrag von
> Lizette Koehler
> Gesendet: Montag, 2. April 2007 16:53
> An: SAS-L@LISTSERV.UGA.EDU
> Betreff: How to filter sas data sets into separate sas data sets
>
>
> Listers,
>
> This is my failing point in coding SAS. The use of 2
> separate SAS data sets to create a third.
>
> I can do this in a program with nested Do loops. But
> with SAS it is just different enough I seem to be
> unable to see the coding technique.
>
> Problem:
>
> Sas Data set 1 contains 1 variable and 1000 obs.
> Sas Data set 2 contains 15 variables and 500000 obs.
>
> I need to filter off the data in Sas data set 2 based
> on Sas data set 1
>
> Node1, Node2 and Node3 must match VAR1 exactly. I have
> all the code I need to do this except for splitting the
> data into a separate SAS data set (NEWLISTS).
>
>
> Psuedo code:
>
> Sas Data set 1: Var1 Length 7 Char
> Sas Data set 2: Node1 Length 1-8 Char Node2 Length
> 1-8 Char Node3 Length 1-8 Char
>
>
>
> Data Newlist (KEEP=node1 node2 node3 ... var15)
> Otherds (Keep=node1 node2 node3 .... var15) ;
>
...
Re: How to filter sas data sets into separate sas data sets #6First off, you don't need two set statements, I suspect you want a
merge.
(remember to sort datasets before merging)
Data newlist (KEEP=node1 node2 node3 ... var15)
Otherds (Keep=node1 node2 node3 .... var15) ;
Merge sasds1 sasds2;
By ;/*not sure which variable you need, but there has to be something
that is the same between the two*/
What I'd really need to know is what are the field names in DS1 and DS2
(You described them but didn't tell us the names)
You will possibly need a REANME= statement to get a matching name to
merge by.
Either read up more on merges and RENAME or get back to us with the
variable names, and some sample data (maybe a proc print with obs=20).
HTH
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Lizette Koehler
Sent: Monday, April 02, 2007 9:53 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to filter sas data sets into separate sas data sets
Listers,
This is my failing point in coding SAS. The use of 2 separate SAS data
sets to create a third.
I can do this in a program with nested Do loops. But with SAS it is
just different enough I seem to be unable to see the coding technique.
Problem:
Sas Data set 1 contains 1 variable and 1000 obs.
Sas Data set 2 contains 15 variables and 500000 obs.
I need to filter off the data in Sas data set 2 based on Sas data set 1
Node1, Node2 and Node3 must match VAR1 exactly. I have all the code I
need to do this except for splitting the...
Re: How to filter sas data sets into separate sas data sets #4Something like this is the old way. You could use a proc sql if you
have a new enough version. Increase your buffersize and if you have
enough memory you may get it into a hash routine.
DATA WORK.NEW;
MERGE small (IN=A OBS=500) big ;
BY ID_FIELD;
IF A=1;
RUN;
QUIT;
RICH
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@listserv.vt.edu] On Behalf Of
Lizette Koehler
Sent: Monday, April 02, 2007 10:53 AM
To: SAS-L@LISTSERV.VT.EDU
Subject: How to filter sas data sets into separate sas data sets
Listers,
This is my failing point in coding SAS. The use of 2 separate SAS data
sets to create a third.
I can do this in a program with nested Do loops. But with SAS it is
just different enough I seem to be unable to see the coding technique.
Problem:
Sas Data set 1 contains 1 variable and 1000 obs.
Sas Data set 2 contains 15 variables and 500000 obs.
I need to filter off the data in Sas data set 2 based on Sas data set 1
Node1, Node2 and Node3 must match VAR1 exactly. I have all the code I
need to do this except for splitting the data into a separate SAS data
set (NEWLISTS).
Psuedo code:
Sas Data set 1: Var1 Length 7 Char
Sas Data set 2: Node1 Length 1-8 Char Node2 Length 1-8 Char Node3
Length 1-8 Char
Data Newlist (KEEP=node1 node2 node3 ... var15)
Otherds (Keep=node1 node2 node3 .... var15) ;
Set SASDS1 ; *Contains 1 var 1000 obs ;
Set SASDS2 ; *Contains 15 vars and 500,000 obs ;
If Node1 = VAR1 or No...
Re: How to filter sas data sets into separate sas data sets #2you cannot do this as described without a common link
here, your Var1
Note: both data sets must be sorted by Var1
Data Newlist (KEEP=node1 node2 node3 ... var15)
Otherds (Keep=node1 node2 node3 .... var15) ;
do until(EndoFile);
Set SASDS1
SASDS2 end = EndoFile;
by Var1;
*consider: if Var1 in (Node1 Node2 Node3);
If Node1 = VAR1
or Node2 = VAR1
or Node3 = Var1
then Output Newlist ;
Else Output Otherds ;
end;
stop;
Undoubtedly the HashHeads will propose a lookup table
but the above is what you are trying to do.
Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
> From: starsoul@mindspring.com
> Listers,
>
> This is my failing point in coding SAS. The use of 2
> separate SAS data sets to create a third.
>
> I can do this in a program with nested Do loops. But with
> SAS it is just different enough I seem to be unable to see
> the coding technique.
>
> Problem:
>
> Sas Data set 1 contains 1 variable and 1000 obs.
> Sas Data set 2 contains 15 variables and 500000 obs.
>
> I need to filter off the data in Sas data set 2 based on Sas
> data set 1
>
> Node1, Node2 and Node3 must match VAR1 exactly. I have all
> the code I need to do this except for splitting the data into
> a separate SAS data set (NEWLISTS).
>
>
> Psuedo code:
>
> Sas Data set 1: Var1 Length 7 Char
> Sas Data set 2: Node1 Length 1-8 Char Node2 Length 1-8
> Char Node3 Length 1...
Re: How to filter sas data sets into separate sas data sets #8On Mon, 2 Apr 2007 23:37:16 +0000, Ian Whitlock <iw1junk@COMCAST.NET> wrote:
>Summary: You need a loop and the POINT option or SQL
>#iw-value=1
>
>Lizette,
>
>I think a lot of respondents have misunderstood the problem. This probably
>could have been avoided with a simplified example. Here is my
>interpretation. Here is code to generate data.
>
> data control ;
> do var1 = 1 to 4 ; output ; end ;
> run ;
>
> data tosplit ;
> input node1 node2 node3 other ;
> cards ;
> 1 2 3 4
> 1 2 3 5
> 7 7 7 7
> ;
Here are test data generators which conform to the actual scale of the problem.
data control;
do _n_ = 1 to 1000;
var1 = floor(ranuni(135)* 100000);
output;
end;
run;
data tosplit;
do other = 1 to 500000;
node1 = floor(ranuni(246)* 100000);
node2 = floor(ranuni(246)* 100000);
node3 = floor(ranuni(246)* 100000);
output;
end;
run;
>
>Here is a way to split using the DATA step.
>
> data newlist other ;
> drop flag var1 ;
> set tosplit ;
> do pt = 1 to nobs ;
> set control point = pt nobs = nobs ;
> if var1 = node1 or var1 = node2 or var1 = node3 then
> flag = 1 ;
> end ;
> if flag then output newlist ;
> else
> output other ;
> run ;
At full scale the loop runs one half billion times. That took about 9
minutes on my PC....
Re: How to filter sas data sets into separate sas data sets #7Summary: You need a loop and the POINT option or SQL
#iw-value=1
Lizette,
I think a lot of respondents have misunderstood the problem. This probably
could have been avoided with a simplified example. Here is my
interpretation. Here is code to generate data.
data control ;
do var1 = 1 to 4 ; output ; end ;
run ;
data tosplit ;
input node1 node2 node3 other ;
cards ;
1 2 3 4
1 2 3 5
7 7 7 7
;
Here is a way to split using the DATA step.
data newlist other ;
drop flag var1 ;
set tosplit ;
do pt = 1 to nobs ;
set control point = pt nobs = nobs ;
if var1 = node1 or var1 = node2 or var1 = node3 then
flag = 1 ;
end ;
if flag then output newlist ;
else
output other ;
run ;
And here is a way to split using SQL.
proc sql ;
create table newlist as
select * from tosplit
where node1 in (select var1 from control)
or node2 in (select var1 from control)
or node2 in (select var1 from control)
;
create table other as
select * from tosplit
where not(node1 in (select var1 from control)
or node2 in (select var1 from control)
or node2 in (select var1 from control))
;
quit ;
Ian Whitlock
================
Date: Mon, 2 Apr 2007 10:53:08 -0400
Reply-To: starsoul@mindspring.com
Sender: "SAS(r) Discussion"
From: Lizette Koehler <starsoul@MINDSPRING.COM>...
Re: How to filter sas data sets into separate sas data sets #3Lizette,
Instead of trying to merge the two data sets, I would probably try to create
a SAS format from the values of VAR1 in data set 1. Then, NODE1, NODE2 and
NODE3 could be compared against the format for a match.
The example below is a simplified version of what you could do and shows a
printout of how it works. It has 5 observations in data set 1 and only 3
variables in data set 2, but I think the logic should hold for the example
you gave. After the example is code that could be used to actually split
the data as you had requested. Hope this helps.
* create sas data set 1 ;
data sasds1;
input var1 $;
cards;
AAA
BBB
DDD
FFF
AAA
HHH
;
run;
* sort data set 1 to eliminate any duplicate values ;
proc sort nodupkey data = sasds1 out = sasds1_dd (rename=(var1=start));
by var1;
run;
* create data set that will be used to build SAS format ;
data sasds1_dd;
set sasds1_dd end=last;
fmtname = '$NODES';
label = 'Y';
output;
if last then do;
hlo='O';
label='N';
output;
end;
run;
* build format (the optional fmtlib option will print the format for you to
review) ;
proc format cntlin = sasds1_dd fmtlib;
run;
* create sas dataset 2 ;
data sasds2;
input node1 $ node2 $ node3 $;
cards;
ZZZ YYY XXX
AAA YYY XXX
ZZZ FFF XXX
ZZZ YYY DDD
AA YYY XXX
ZZZ AAAA XXX
;
run;
* apply format to node1-node3 to determine if there is a match ;
data testing;
set sasds2;
if put(node1,$nodes.) = 'Y' or
put(node2,$nodes.) = '...
Re: How to filter sas data sets into separate sas data sets #5Lizette:
Can you show
(1) your nested do loops that work for you, and
(2) some sample data and the data sets that you desire to get?
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Lizette Koehler
Sent: Monday, April 02, 2007 9:53 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to filter sas data sets into separate sas data sets
Listers,
This is my failing point in coding SAS. The use of 2 separate SAS data
sets to create a third.
I can do this in a program with nested Do loops. But with SAS it is
just different enough I seem to be unable to see the coding technique.
Problem:
Sas Data set 1 contains 1 variable and 1000 obs.
Sas Data set 2 contains 15 variables and 500000 obs.
I need to filter off the data in Sas data set 2 based on Sas data set 1
Node1, Node2 and Node3 must match VAR1 exactly. I have all the code I
need to do this except for splitting the data into a separate SAS data
set (NEWLISTS).
Psuedo code:
Sas Data set 1: Var1 Length 7 Char
Sas Data set 2: Node1 Length 1-8 Char Node2 Length 1-8 Char Node3
Length 1-8 Char
Data Newlist (KEEP=node1 node2 node3 ... var15)
Otherds (Keep=node1 node2 node3 .... var15) ;
Set SASDS1 ; *Contains 1 var 1000 obs ;
Set SASDS2 ; *Contains 15 vars and 500,000 obs ;
If Node1 = VAR1 or Node2 = VAR1 or Node3 = Var1 then Output Newlist ;
Else Output Otherds ;
I have tried putting in two SET statements, but I seem to reduce the
information dramatically. ...
Re: How to filter sas data sets into separate sas data s etsI think that both Ron's (as he mentioned) and Richard solutions require that
VAR1 is in both datasets.
But from the original post, it seemed to me that VAR1 is only in data set 1,
and it must be matched to 1 of 3 variables in data set 2 (NODE1, NODE2 or
NODE3) to be output to the NEWLIST data set. For this reason, I think a
format is one possible approach.
Maybe the original poster can clarify this point. Thanks.
Jack Clark
Research Analyst
Center for Health Program Development and Management
University of Maryland, Baltimore County
-----Original Message-----
From: SAS(r) Discussio...
Re: What r the data types in SAS? in Base SAS , and SAS SQL> From: Amar Mundankar
> Sent: Tuesday, July 21, 2009 8:10 AM
> To: sas-l@uga.edu
> Subject: What r the data types in SAS? in Base SAS , and SAS SQL
>
> Hi all,
> What are the different data types in Base SAS and SAS SQL??
character, lengths from 1 to 32,000+
numeric: lengths from 2 to 8
dates are a subtype of numeric
and are identified by their date, datetime, or time formats
the new proc TSPL (Table Server Processing Language)
supports ANSI data types: bigint, tinyint, etc.
http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003
065339.htm
http://s...
Re: Reading SAS data sets on UNIX by non-SAS appsJohn:
Dataflux is now marketing DBMSCOPY or Unix. See
http://www.dataflux.com/Product-Services/Products/dbms.asp
Sig
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John
Bentley
Sent: Monday, October 18, 2004 10:10 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Reading SAS data sets on UNIX by non-SAS apps
I have SAS data sets on AIX that we need to read with Unica's Affinium
campaign management software, also on a UNIX box. (Let's not get into why
we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC
driver for the UNIX environment, and the Affinium implementors don't want to
use the SAS SQL Library for C and or deal with APIs. Other that dumping the
SAS data sets as flat files, can anyone suggest a solution?
Thanks in advance for the help.
...
Re: Reading & Writing SAS data sets without SAS #3Chang,
You're correct in that a number of companies have done it. I believe SPSS
can do it, WPS, Stat Transfer, dbmscopy, and perhaps others have also done
it. But what I think is unique about this is that Alan is talking about
offering plug-ins so you can roll-your-own so to speak. How cool would it be
to have some type of driver/plugin for R?
Phil
Philip Rack
MineQuest, LLC
SAS & WPS Consulting and WPS Reseller
Tel: (614) 457-3714
Web: www.MineQuest.com
Blog: www.MineQuest.com/WordPress
-----Original Message-----
From: Chang Chung [mailto:chang_y_chung@HOTMAIL.COM]
Sent: Monday...
Re: Reading SAS data sets on UNIX by non-SAS apps #2John:
Following on Richard's thoughtful suggestions, the Affinium system would
likely capture data from csv files. SAS PROC EXPORT produces them quickly,
and loading them into external systems works faster for relatively basic
data structures and data formats, in my experience, than xml parsing.
Sig
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John
Bentley
Sent: Monday, October 18, 2004 10:10 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Reading SAS data sets on UNIX by non-SAS apps
I have SAS data sets on AIX that we need to read with Unica's Affinium
campaign management software, also on a UNIX box. (Let's not get into why
we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC
driver for the UNIX environment, and the Affinium implementors don't want to
use the SAS SQL Library for C and or deal with APIs. Other that dumping the
SAS data sets as flat files, can anyone suggest a solution?
Thanks in advance for the help.
...
Re: Exporting a SAS data set to Text file on SAS unix #3hi ... actually, what I posted earlier was too much code (sorry)
this is enough (a bit more succinct)
* variable names into a macro variable (tab separated);
proc sql noprint;
select name into :vars separated by '09'x
from dictionary.columns
where libname eq 'SASHELP' and memname eq 'CLASS'
order varnum;
quit;
data _null_;
file 'z:\class.txt' dsd dlm='09'x ;
if _n_ eq 1 then put "&vars";
set sashelp.class;
put (_all_) (:);
run;
--
Mike Zdeb
U@Albany School of Public Health
One University Place
Rensselaer, New York 12144-3456
P/518-402...
Re: How to get the location of SAS code in the same SAS code thru #4I use a macro from Frank DiIorio, CodeCrafters, Inc. that rely on SAS
Dictionary Tables:
%macro source_code/store;
%global source_code;
proc sql noprint;
select XPath
into :Source_Code separated by ' '
from dictionary.extfiles
where fileref like "#LN00006"
;
quit;
%mend;
The store is optional since I like to store compiled macros in a single
location and call in with a mstored and sasmstore= options.
I just add the following to my code to get a footnote indicating the full
path and name of code submitted:
%source_code;
footnote1 "SOURCE CODE: &source_code";
>On Wed, 11 Apr 2007 07:43:50 -0700, Alok <alok.rustagi@GMAIL.COM> wrote:
>
>>Hi all,
>>
>>I am facing a problem in which I need to get the location/path of a
>>SAS code in a macro variable. I need to use the macro variable in the
>>same SAS code. Is there any SAS option available which can do this for
>>me? Or is there a code snippet which can achieve the same purpose?
>>
>>Can you please help me out as soon as possible since I need to deliver
>>this tomorrow. Any help will be greatly appreciated.
>>
>>
>>Thanks,
>>Alok
...
Re: Include SAS code w/o including SAS codeI want the statements only, not the processing.
Alan
Alan Churchill
Savian
www.savian.net
-----Original Message-----
From: ./ ADD NAME=Data _null_, [mailto:iebupdte@gmail.com]
Sent: Tuesday, August 12, 2008 6:20 AM
To: Alan Churchill
Cc: SAS-L@listserv.uga.edu
Subject: Re: Include SAS code w/o including SAS code
You need to provide more details. It is unclear to me if you want the
statements generated by the macro MPRINT/MFILE written to the file or
the MACRO definition FILE/PUT.
Syntax
MFILE | NOMFILE
MFILE
routes output produced by the MPRINT option to an external file. This
is useful for debugging.
On 8/12/08, Alan Churchill <savian001@gmail.com> wrote:
> All,
>
>
>
> Ok, I think this might be doable but I am drawing a blank.
>
>
>
> Suppose I have this code:
>
>
>
> %macro xyz;
>
> data temp.temp4;
>
> .do some sas stuff.
>
> run;
>
> %mend;
>
>
>
> Is there a way to write the macro statements out to a file? I can run them
> but I would also like to save them outside of SAS.
>
>
>
> Thanks,
>
> Alan
>
>
>
> Alan Churchill
> Savian
> <http://www.savian.net/> www.savian.net
>
...
Re: How to set up autoexec.sas in SAS/Intrnet?You might want to specify your autoexec.sas program on the REQUEST INIT= parm of PROC APPSRV.
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of SQLi
Sent: Friday, February 18, 2005 1:25 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to set up autoexec.sas in SAS/Intrnet?
Hi SAS-Lers: I have trouble setting up autoexec.sas in SAS/intrnet.
autoexec.sas is not processed. I heard that this is a 'function' of
SAS. Then, how to activate the items within an autoexec.sas? Thanks.
Stan
------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courrier �lectronique est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m'en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen.
============================================================
Harry is correct that you ...
Re: Diffrence between SAS coding and SAS implementationSai,
It might be fancy term that HR guys coined or It might be installing SAS on
cross platform operating systems. It may be of great important with BI
installation is pretty complicated managers in this list might know what it
is ??????? Sorry could not help you much
thanks
On 1/10/07, saikumarkorrapati@gmail.com <saikumarkorrapati@gmail.com> wrote:
>
> Hi Group,
>
> i just wanted to clarify my doubt
>
> I am working with SAS in financial domain from past 2 years.
>
> Usually i do codoing for conversion of all input files ( whatever the
> type like excel ,. flat files etc) and generate the reports and
> maintaing data bases and performence tuning etc ...
>
>
> But recently i come across the words from some of the business managers
> - SAS implementation.
>
> What is mean by SAS implementation ?
>
> implematation is like automation of all the tasks?
>
> or still it mean SAS in all phases of the project ?
>
>
>
> Thanks in advance.
>
> Sai kumar
>
...
Re: Deleting SAS Data from a SAS DATASETOne thing you might do is to add an index on the snap_dt to the dataset; =
if that's there then you should be able to delete the records in place:
proc sql;
delete from prod.master_date;
where snap_dt =3D "&end_dt"d;
quit;
run;
In both the ways you are trying now you are creating new data sets =
rather than deleting records from the current data set; it would seem to =
me that a SQL delete statement would be faster than creating new =
datasets even if there isn't an index on the date.=20
-Mary
----- Original Message -----=20
From: SUBSCRIBE SAS-L Chandra Gadde=20
To: SAS-L@LISTSERV.UGA.EDU=20
Sent: Friday, August 15, 2008 12:14 PM
Subject: Deleting SAS Data from a SAS DATASET
Hi All
I have several SAS datasets that are very very big. (50GB of size). =
Every
month, the data is being appended to these datasets. I need to deleted =
the
data which is greater than 24 months. What is the best method to do =
this?
Please help me.
I tried PROC SQS and DATA STEP. But these two are taking very long =
time.
Data prod.Master_data;
set prod.master_date;
if snap_dt =3D "&end_dt"d then delete;
run;
proc sql;
crete table prod.master_date from prod.master_date
where snap_dt ne "&end_dt"d;
quit;
Hi
You've got good ideas how to delete the old observations. My modify
proposal was wrong. Sorry about that!
I still think that changing the data model would be a good idea.
Regards
Patrick
...