I have a table containing 2 fields(columns) only. Column1 is UserID and Column2 is Value. Here is an example of the table.
UserID Value
user1 A1-34
user1 B2-99
...
How to list teradata views and/or tables on a new temporary table (can be a volatile table) in one column
I need the sql to do so.
So, i need a new temporary table with one column lists all...
Hi, I'm a new SAS user.
I need to create a report where I see, for all tables of an oracle database, their count(*).
I've begun to do it manually, here a sample of the program I created:...
Hi experts!
I downloaded a file that the extension is .sas7bdat . it is a dataset. I would like to get the data from that file but I cannot open it with either MSexcell or any other program...
How does one compute Geometric Mean of a column in a SAS dataset? Also Harmonic mean?
It seems possible to compute GM of a row in SAS, but that would require using PROC TRANSPOSE. I couldn't ...
I have a SAS table and need to run a logistic regression. Two variables divide my population into 20 different categories. It happens that two of these categories are way larger than the other...
I am looking for a way to loop through 10 macro variables to create 10 separate datasets (first part ) and then within each dataset to loop for &MXCNT(created earlier) number of variables to c...
Hi,
I need to convert a Julian date in Excel that orginated in SAS, but am getting the wrong result by about 50 years. Example:
SAS Julian date: 12432
Represents: 14-Jan-1994
In exce...
How do I programatically zip a file in SAS?
I inherited a SAS application from a previous employee and know nothing of SAS.
Could someone explain what the following code is doing?
PROC TRANSPOSE DATA = TmpCrt.adj_cmb_date_L10_SRT ...
OK, I was able to transpose all distinct values of a column into separate columns, thanks to KendallTech and Wolfen351, now all I want to do is the complete opposite.
I have a character str...
I am using a web-based application that creates 2 data export files for pulling data into SAS:
DATA_EXPORT_2008-04-29.CSV
DATA_EXPORT_2008-04-29.SAS
Both of these files are saved togeth...
Hi,
Can anyone recommend good online documentation for SAS? I find the official version, excuse my french, really really cr*p to navigate or search.
Thanks!
I am working with VB.NET 2005 project that needs to access SAS files. I am trying to find an OleDb provider, but I haven't found one that specifically talks about working with .NET.
TIA,
Bob
For example, the VAL function in MSAccess will do that:
Returns the numbers contained in a string as a numeric value of appropriate type.
Syntax: Val(string)
The required string argument...
Hi could anybody here please refer me to a SAS compiler that I can use on Windows with a X86 processor??
Best Regards
Fred
Please help to create a regular expression in SAS using command RXPARSE to search the following syntax:
P. O. Box
P.O. Box
PO BOX
P O BOX
PO. Box
Post Office Box
Post Box
Post Offi...
Hello,
I'm trying to figure out how to add a DB2 environment/database to my SAS Enterprise Guide library. I have done this successfully with Teradata but for some reason cannot figure out h...
How do I do a LEFT JOIN where there is only ever one value joined from the secondary table, even if multiple values exist for the join criteria? In other words, no additional rows are created...
I'm trying to run a SAS program that was provided with software we purchased for work. I've used SAS ages ago, but really don't know it. I do know programming in general, just not in SAS. I...
I'm currently working on creating a weekly report. in SAS, the default first day of the week is Sunday, however, I want it to be Monday through Sunday, and then group the report weekly. How ...
How would you in sas select only those numbers who 2nd digit after the decimal is 2 or 3.
Table
Number
1234.1132
1234.1264
1234.1353
1234.1425
1234.1523
1234.1652
1234.1756 ...
Is there a statement you can place in a SAS program that will stop execution? I want to be able to examine the status of data sets partway through the program. The tedious way I know to do t...
Hi,
I'm reading and comparing 2 numeric fields from 2 different files. They should match, but i think because they have different informats it's giving a mismatch.
The 2 informats are PD...
We are trying to use SAS v9.1.3 to insert records into a table that resides on a MS SQL 2005 database. The problem is we can't figure out how to retreive the new record's id. SAS apparently d...
