1
vote
2answers
43 views
Getting the path of the executing SAS file in Enterprise Guide
I read
http://www.runsubmit.com/questions/113/finding-out-the-name-and-path-of-the-program-being-run
but none of the suggested solutions are working for me as I'm executing my SA …
3
votes
5answers
132 views
Finding out the name and path of the program being run
How can I determine the name and path of the program I am currently running? (In Windows, sas 9.1.3 - but techniques for other versions / environments would also be good to know.. …
2
votes
4answers
254 views
Finding the # of days between two dates?
I have data like:
patid startdate endday
01S1003 9/30/2008 3/16/2009
How do I find the number of days bewteen startd …
4
votes
2answers
94 views
Tables not Listed under SQL Server LIBNAME
I've been having this problem for some time (it seems since the initial release of SAS v9).
Steps to Reproduce
I assign a libname to SQL Server (or Oracle -- I haven't verifi …
2
votes
3answers
212 views
Unduplicating records within a SAS dataset
I am new to SAS but have background programming in C++, Stata, SPSS, even JMP.
Our datasets contain multiple duplicates and I need to unduplicate the SAS records/rows within the …
2
votes
2answers
14 views
How do I programmatically create New Catalogs?
I suspect I missing something really obvious here, but is there a way to programatically create a new catalog?
I've had a look at PROC CATALOG but can't see anything which would c …
2
votes
1answer
46 views
Placeholder Rows/Values from XML libname
I have some XML data which I'm trying to read into SAS 9.1.3 through the XML libname engine.
Said XML data looks a lot like this (some may recognise that's it's output from PROC ME …
2
votes
1answer
41 views
Building a character string?
Hi, I have the following sample data:
custid
100
200
300
400
500
.
.
etc.
I want to build the following string:
where custid in (100, 200, 300, 400, 500.....)
I hav …
2
votes
2answers
36 views
Help with variable calculation over multiple observations?
type number VISIT date
AMOUNT DISPENSED 0 1
AMOUNT DISPENSED 18 2 2007-08-20
AMOUNT DISPENSED 18 2 2007-08 …
3
votes
2answers
38 views
Coding the value codes and labels along with data type for variables
Is there a good specific resource to show examples of coding to create the following?
The description of the variable/column within the table, example for TERM_TYPE, would be Dis …
4
votes
3answers
20 views
Need help with calculating a column
The data set looks like
Val1 Sum of last 5 (Non Blank)
10 .
. 10
20 10
30 30
. 60
40 60
50 100
30 150
. 170
. 17 …
2
votes
1answer
40 views
Help with Report Generation
Hello:
Our office is attempting to edit SAS code that generates course evaluations for faculty at our college. We currently have code that generates individual course evaluation …
1
vote
1answer
31 views
Building an Array from values in a Variable?
I have normalized assessment data, with items nested within students. I would like to define an array based on the item numbers in the variable ITEM in my data file.
Current val …
