I have some PROC REPORT code that generates a report with 2 levels of grouping, but the RBREAK always just summarizes for everything. I get something like this for example: Row1: Type A Before 100 200 300 Row2: After 400 500 600 Row3: Type B Before 100 200 300 Row4: After 400 500 600 ...
There are gov't data files: http://www.cdc.gov/EpiInfo/ Available in this weird SAS format. How can I convert them into XML/CSV, something much simpler that can be read by scripts/etc.??? ...
Help! I have 2 variables from different datasets. Each variable has a different name in each dataset. However, the variables are delivering the same type of information for a single resspondent. Ex. Variables 1 & 2 for respondent #1 DR1IFDCD 11111000 32104950 51101010 81103080 11111000 DR1IFDCD 92410310 92101000 12210250 31105000 2...
Can someone explain where the highest precision numbers in variables d4 to d7 came from? The SAS program: data foo; format d1-d7 datetime30.6; timestring = "23:59:59.997000000"; time = input(timestring,time18.); d1 = dhms(0,0,0,time); d2 = dhms('08DEC1981'd,0,0,time); d3 = dhms('31DEC2503'd,0,0,tim...
After working with different data sets in SAS for a month or two, it seems to me that the more variables a data set has, the more time it takes to run PROCs and other operations on the data set. Yet if I have for example 5 variables, but 1 million observations, performance is not impacted too much. While I'm interested in if observatio...
Hi all (First, I am a SAS newbie, though an experienced programmer. I have googled a little for this, I promise...) I would like to automate some data analysis processes in population estimation, which would take a bunch of csv data files and some shapefiles as the beginning, do stuff to them (including some geographic intersections t...
I may be missing something obvious, but how do you calculate 'powers' in SAS? Eg X squared, or Y cubed? what I need is to have variable1 ^ variable2, but cannot find the syntax... (I am using SAS 9.1.3) ...
Is it possible to create customised dropdown menus in EG? ie I would like to present a user with a list of dropdowns, and the ability to click a 'submit' button that would use the values of those dropdowns to run a SAS macro... Also, is this possible without setting up a stored process? ...
How do I view the file below in Enterprise Guide (v 4.1 ) ?? %let libWORK=%sysfunc(pathname(WORK)); * work lib is on UNIX ; data _null_; file "&libWORK./MYFILE.htm"; put '<html>' / ' <head>'/ ' <title> A Title </title>'/ '</head> <body> some content </body> </html>'; run; ...
I have been taking a few graduate classes with a professor I like alot and she raves about SAS all of the time. I "grew up" learning stats using SPSS, and with their recent decisions to integrate their stats engine with R and Python, I find it difficult to muster up the desire to learn anything else. I am not that strong in Python, but...
I have a program which creates a stored compiled macro in a library using the syntax: options mstored sasmstore=MyLib; %macro MyMac() /store source des='My Macro'; %let x=1; %mend; However I cannot seem to re-assign my library (MyLib) afterwards - I get the following message (sas 9.1.3): ERROR: Unable to clear or re-assign the li...
Hi all, Is there a way to do spatial analysis (NOT just graphics) in SAS? What I really want is the ability to geographic queries like one can do in PostGIS or SpatialLite in PROC SQL. I asked this on the SAS-L list and got nothing. Thanks! ...
I need SAS to read many large log files, which are set up to have the most recent activities at the bottom. All I need is the most recent time a particular activity occurred, and I was wondering if it's possible for SAS to skip parsing the (long) beginning parts of the file. I looked online and found how to read a dataset backwards, but...
Is there an open source and/or free statistics package or library for Delphi? I'm looking for something that can compile directly into the executable, so no DLL's. It needs to be compatible with Delphi 2009 and later (the Unicode versions). Hopefully there is something comprehensive available out there. By comparison, I am used to the a...
I've been developing a lot of Java, PHP and Python. All of which offer great logging packages (Log4J, Log or logging respectively). This is a great help when debugging applications. Especially if the app runs headless. Now, I have a SAS script that is supposed to run as a stored process. But for some reason, the execution seems to run v...
If I have, say, grades (A,B,C,D,E,F), and want to display the percentage and N of kids who got an A or B out of all kids, and ONLY that info, is it possible with PROC TABULATE? I tried using multi-label formats, but with those I have to include all the other values in the format or they just show up in the PROC TABULATE results. I'm lo...
Hello stackoverflowers, we are designing a major webapplication for the www. It a social community site. and i would like to know witch direction i need to take. What works faster, flex and php or java and flex? i've read that flex and php with amfphp is very fast (with AMFEXT). but i have seen that 90% of the major companies here i...
has anyone successfully interacted with a microsoft exchange server in SAS 9.1.3 or 9.2? i know it can be done with SAS Ent. Guide 4.x, but i'm not interested in that route if regular SAS can do it. ...
Hi, I have a dataset of date(monthly), person and return(monthly). I need to calculate the compounded monthly return of the dataset from April Year t to March Year t+1 for each person. For example, Annual return Person A= April Year 1* May Year 1*......*March Year 2. Can I know how can I do that in SAS? Do I need an array? ...
I am running Windows Xp. Is there a way in Base SAS to obtain the logon id of the current user? ...