2
votes
2answers
6 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
3answers
67 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 …
3
votes
3answers
43 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.. …
3
votes
2answers
28 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
1answer
35 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
1answer
11 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
2answers
33 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 …
2
votes
3answers
47 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 …
3
votes
2answers
32 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
11 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
32 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
19 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 …
