Re: combine n SAS datasets in to one SAS dataset.
If you use the dictionary tables try Proc SQL - it will run much more
quickly than a datastep:
proc sql noprint;
select MemName into :MemList
separated by " &lib.."
and MemName eqt upcase("&mem");
DDS Data Extraction
From: SAS(r) Discussion [mailto:SAS-L@L...Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return:
is your table from windows? compressed from another system?
and specially with personnel formats hard coded inside?
msiddu2000 a �crit :
> SAS System Viewer 9.1 was able to open datasets that were created by
> V8 engine (SAS 8.2), but is unable to open datasets that are created
> with V9 engine (SAS 9.1.3).
> Does this need SAS System Viewer to be upgraded ?
> Something else needs to be done ?
INED (Institut National d'Etudes D�mographiques)
133 Boulevard Davout 75980 Paris Cedex 20
m�l : email@example.com t�l : 33 (0) 1 56 06 21 54
...Re: combine n SAS datasets in to one SAS dataset. #4
Filename allfiles ('d:\conv\2008*.asc'); * Filenames can use
At 10:53 AM 1/14/2009, firstname.lastname@example.org wrote:<br>
<blockquote type=cite class=cite cite="">Hi,<br>
I have a similar problem in my SAS macro;<br>
I have many ascii files where name are 2008011.asc to 2008123<br>
year = 2008, month=01 to 12 and dekad = 1 to 3;<br>
To import all my files, I have writed 2 similars macro contain
<x-tab> </x-tab>%Do i= 1
<x-tab> </x-tab>%DO j = 1
%let dataname ="d:\conv\20080&i&j.asc";<br>
and for second<br><br>
<x-tab> </x-tab>%Do i= 10
<x-tab> </x-tab>%DO j = 1
%to &dekad;...Re: SAS
You should be able to find some info in the SPD Engine section of the
Sent: Mon, 3 Jul 2006 09:03:00 -0700
Subject: SAS - 9; Partition of SAS Datasets.
Recently I heared from some of my friends...that SAS - 9
supports PARTITION of SAS datasets. I tried for getting syntax and some
details, but couldn't able to get. Is anyone has any idea about the
partitions of SAS datasets, if so can any one help me out on this?
Thanks in advance.
_____...Re: How to read a SAS log into a SAS dataset.
>Dear SAS-L listers,
>This may be the millionth time somebody is asking this question " how to
>read a SAS log into a SAS dataset?". I looked at previous posts and
>gathered info from various SUGI papers and found a way to get the log and
>read it. But i dont know for some reason its not working. Please help me.
>I used a Proc printto procedure to print the log to a external file
>location and try to read in the log and create a SAS dataset which will
>contain info about Filename, Owner name, Group name, Elapsed time, CPU
>t...Re: How to filter sas data sets into separate sas data sets #4
Something 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.
MERGE small (IN=A OBS=500) big ;
From: SAS(r) Discussion [mailto:SAS-L@listserv.vt.edu] On Behalf Of
Sent: Monday, April 02, 2007 10:53 AM
Subject: How to filter sas data sets into separate sas data sets
This is my failing point in coding SAS. T...Re: How to filter sas data sets into separate sas data sets #3
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 ...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: email@example.com
> 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://s...Re: Deleting SAS Data from a SAS DATASET #15
Summary: Suggestions for maintaining large data set
You are essentially making a copy of a 50GB file every month. Of
course, it takes long. Consequently you either have to copy the data
more efficiently or modify how the data is stored and/or used.
Have you looked at system options to make this as efficient as
possible? Big buffers, many buffers. Different disk handlers for
input and output would also speed up the process since it is mainly IO
bound. (These topics have been discussed on SAS-L, in papers, and
documentation. I have not found the techniques necessary...Re: Deleting SAS Data from a SAS DATASET #4
Summary: PROC DATASETS; AGE statement. + VIEWs
This won't help you delete data from your very big data set, but you
may find this example interesting.
You say you append data monthly to a big data set then when big gets
too big you need to clean out the old. And that takes a very long
However if you don't physically append but use a view to
append/combine you may find it easier to get rid of the unwanted old
Consider this code. it pushes MonthlyUpdate onto the stack of 24 data
sets and the 24th data set is deleted. Then all the data sets get
renamed to produce a new g...Re: Deleting SAS Data from a SAS DATASET #5
I also read that this could be a problem on machines that have multiple =
processors, such as running DB2; if the data is clustered and each =
processor takes care of one cluster, then you could have queries all =
hitting the same processor instead of distributing the load across all =
processors, thus potentially slowing down queries in peak periods where =
you have multiple queries at the same time, if queries tend to be based =
on the month (such as bank statements). Thus I'd proceed with caution =
on the idea of splitting one table into 24 tables with one view without =
making sure th...Re: Deleting SAS Data from a SAS DATASET #6
I have been watching this thread today and I just now recall an example
that Paul Dorfman gave at a RUG several years ago and no, I don't recall
exactly where or when other than it was NESUG or SESUG in the past 5 years.
Anyway, Paul had a client who was storing something like the past 12 months
of transactions as variables andat the start of each month needed to stick
the just ended month on the end and drop the oldest month. Paul used Peek
to read the last 11 months of each obs as a single chunk of data, append
the current's month, and then used Poke to write the whole new obs as a
...Re: Deleting SAS Data from a SAS DATASET #17
When I used this code, I am receiving the following warning. It completely
deleted my prod.master_date SAS Dataset. Do you know what is going on here?
WARNING: This SAS global statement is not supported in PROC SQL. It has
On Fri, 15 Aug 2008 13:17:25 -0500, Mary <mlhoward@AVALON.NET> wrote:
>One 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:
> delete from prod.master_date;
> where snap_dt = "&end_dt"d;
&...Re: SAS -> MySQL without SAS/ACCESS
XML, OleDb driver for SAS (free), ODBC driver from SAS (free).
SAS/Access is only required to get data from a source, not the other way
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, June 13, 2008 1:50 AM
Subject: Q: SAS -> MySQL without SAS/ACCESS
What is the easiest and neatest way to get a sas data set into MySQL
without using SAS/ACCESS? I am hoping there are some useful URLs for
...Re: SAS Macro to delete a SAS dataset 196997
> From: SAS Techies
> Subject: SAS Macro to delete a SAS dataset
> Here's a simple SAS Macro to delete a SAS dataset...It takes the name
> the SAS dataset as the parameter...
> %macro deletedsn(dsname);
> %if %index(&dsname,'.') eq 0 %then %do; %let lib=work; %let
> dsn=&dsname; %end;
> %else %if %index(&dsname,'.') eq 0 %then %do; %let lib=%scan(&dsname,
> 1,'.'); %let dsn=%scan(&dsname,1,'.'); %end;
> proc datasets lib=&lib nolist;
> delete &dsn;
> qui...Re: Deleting SAS Data from a SAS DATASET #14
On Fri, 15 Aug 2008 18:54:08 -0400, Dave Scocca <dave@SCOCCA.ORG> wrote:
>--On 8/15/08 6:03 PM -0400 Chang Chung wrote:
>> good point! but as shown below, you can make a view of multiple datasets
>> having the separate indexes, and where seems to be fine with this.
>> interesting. ran on sas 9.1.3 sp4 on windows.
>> /* make a view of two datasets appended */
>> proc sql feedback;
>> drop view work.oneTwo;
>> create view oneTwo as
>> select * from one union select * from two
>> order by age;
>One thought on this--at least in my general approach to using views--is you
>probably want to avoid the ORDER BY statement--especially if it's the variable
>you're indexing on and you want to use a subset.
>For any amount of data above a trivial one, there's no sense in forcing the
>view to re-order th
>e data if it doesn't have to.
Eliminating ORDER BY is not going to do any good unless the ALL option is
invoked for the UNION operator. Otherwise the view is going to purge
duplicate rows, and will sort the rows to support that process. Ian
mentioned the ALL option but did not emphasize its importance.
...Re: Deleting SAS Data from a SAS DATASET #13
I am not expert with indexes, but I would expect that an index on each
data set would be employed even when the data are accessed through
a view. If that is correct, there would be clear advantage to indexing
data for each month separately. If the data are in one large file,
then when old data are deleted and new data added, the entire index
will need to be recreated on all of the data. That is a big operation.
If, instead, data are maintained in separate files for each month and
each month of data is indexed independently, then indexing needs to
be performed only for the new data. The ind...Re: converting sas transport files into sas datasets
Once you have assigned an xport libname you can read it in like a
libname out xport 'C:\Documents and Settings\kdt\Desktop\class.xpt';
*- Create xport file;
*- Create work file from xport file;
> Hello All,
> Could anyone please give me the code for converting sas transport
> files into sas datasets. thanks in advance.
...Re: Deleting SAS Data from a SAS DATASET #19
On Mon, 18 Aug 2008 10:26:14 -0400, SUBSCRIBE SAS-L Chandra Gadde
>When I used this code, I am receiving the following warning. It completely
>deleted my prod.master_date SAS Dataset. Do you know what is going on here?
>WARNING: This SAS global statement is not supported in PROC SQL. It has
In PROC SQL, WHERE must be a clause within a statement, not a freestanding
statement. Get rid of the semicolon immediately before the word "where".
Incidentally, I think the warning is inaccurate in referring to a WHERE
statement as a global statement.
>On Fri, 15 Aug 2008 13:17:25 -0500, Mary <mlhoward@AVALON.NET> wrote:
>>One 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:
>> delete from prod.master_date;
>> where snap_dt = "&end_dt"d;
>>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.
>> ----- Original Message -----
>> From: SUBSCRIBE SAS-L Chandra Gadde
>> To: SAS-L@LISTSERV.UGA.EDU
>> Sent: Friday, August ...Re: Deleting SAS Data from a SAS DATASET #16
Summary: SAS Scalable Performance Data Server
You now have a number of reasonable suggestions to your problem that
place the burden on the programmer, but I did not see mention of the
SAS Scalable Performance Data Server. This is a SAS product designed
to handle large amounts of data. Considering the size of your data
set suggests that perhaps it is time to spend money on the problem.
Even the SPDE engine included with the base product might help,
particularly if the computer has several CPUs.
Date: Fri, 15 Aug 2008 13:14:22 -0400...Re: Is it possible to read a sas dataset NOT using sas?
You might try the Universal OLE DB driver.
Docs at: http://tinyurl.com/2cmgcf
Driver page at: http://tinyurl.com/2hbc23
I think this should allow you to read a sas data set but not write to it.
Also, the driver does not support much beyond a Select * clause.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Tuesday, March 18, 2008 9:44 AM
Subject: Is it possible to read a sas dataset NOT using sas?
Is it possible to read a sas dataset NOT using sas and have
observations an...Re: search SAS data set from SAS code
> From: Rose
> 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.
a problem familiar to all of us delayed-housekeeping folks.
Libname Libref '<directory-specification>';
use your system utilities to search for the dir-spec
of your libref.
containing text: <dir-spec>
once you have found the libname...Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively
systematic way of assessing my knowledge of SAS in a short time span.
For that purpose, it was worth it.
Since I learn SAS by doing new tasks, or re-doing old tasks in a new
way, I assume my knowledge of SAS is uneven, even though I am regarded
as productive, and frequently creative in using SAS to solve our group's
I passed the test, with lower subscores on the components that I
expected to be weakest on. I thought many of the questions made me
think about some fundamental, sometimes subtle, features of the
lan...Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS.
On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM>
>Is it possible to read a sas dataset NOT using sas and have
>observations and variables etc. rather than having meaningless chunks
...Re: SAS Macro to delete a SAS dataset #2 313487
I too like(d) PROC DELETE.
When I used it I was forced to remove it and use PROC DATASETS because
PROC DELETE is not documented.
Also, but I have not tested it. How does it work with indexed data
sets, audit trails, generation data groups, views, etc.?
I don't worry much about deleting, "all" of my programs run in batch
and are obsolete as soon as they are written.
On 12/3/09, Fehd, Ronald J. (CDC/CCHIS/NCPHI) <firstname.lastname@example.org> wrote:
> > From: SAS Techies
> > Subject: SAS Macro to delete a SAS dataset
> > Here's a simple SAS...