Can someone tell me how to extract the last character from a text field. Below is an example of a text fieldA and I would like to extract the last character which in this case is '5'. Fi…
I have a set of data (attached) which shows the volume of web traffic by Country, trended weekly. I'm trying to learn/find a statistical method that help me analyze the data in the following way:
If you had to pick a place for your SSL encryption to go, what would be the best place to place it and why? At the IIS level.....or at the application level?
We use IIS in conjunction with SAS to …
I'm working on a SAS project and we are currently working on setting up the folder directories. Does anyone know how to change the default SAS temporary work directory?
Can you recommend a Cloud Storage provider that is economical if I want to store up to 1 TB ? My files are primarily MP4 type files. I want to share the files with a select group of friends.
I am able to query a DB2 table from SAS EG using a connection to DB2.
I can assign a library using:
LIBNAME TST DB2 USER=&USR. PASSWORD=&PWD. DATASRC=&SRC.;
The problem is the lib is…
I have a macro that takes multiple rows and puts them into one comma delimited column:
I have a table that has multiple variables that were created in a Proc SQL statement. I would like to transpose these variables so I have a vertical list instead of a horizontal list.
I ran process monitor from Microsoft Sysinternals tool for only a few minutes I got 54,000 Name not found. 18,000 Reparse. 5,000 File blocked with only readers.
With so many errors where would be t…
If I have a macro that looks like this.
Create table_&lit as
Select * from Tablea
How to calculate the value or what is the formula in the relative frequency column? Thanks
I have some problem having calculating CAGR of my investment ...for example i had invested 10000 Each month for last 15 Years (180 Months) which comes to total investment of 1800000. e…
New 2012 R2 Server just in for a client. It's purpose is to act as HyperV host for a 2012 R2 Server VM that will run SAS Analytical software (very demanding on resources - IOPS, RAM, drive space, etc.…
what is the expression to run to get the sas date out of 30/06/2016.
like for 31/03/2015 the result is 20178.
I am trying to call SAS from vb.net and i getting message
on line (CODE)
i have imported
System.Runtime.InteropServices.COMException was caugh…
do you know if possible in SAS to join 2 xls spreadsheets in one as an output.
for example, I have the first outputs in Book1 and Book2 and would need to merge them as in the Boo…
Hello, I am trying to create labels for a few variables and then create frequency list style reports (not tables).
In the below SAS code I am attempting to use var6* and var10 variable and apply l…
Hello, in the below SAS code I am trying to match 3 datasets (data1, data2, data3) by 5 key variables (var1, var2, var3, var4, var5) and output everything into one dataset (outdata) based on the condi…
I have imported a file from Excel into SAS Enterprise Guide 4.3 and have performed some calculations on the data. I need to replace the dots or nulls with zero. I'm hoping to be able to do this …
I am trying to create frequencies of var1 including missing values from data1 SAS dataset. Is there a different way of doing this or a better/more efficient way?
Please see my code below:
what is the syntax in SAS programing to get from
"Financial Reporting - Individual IFRS" to "IND_IFRS"
Prioritization matrices can be used to:
I. Rationally narrow down the focus of the team before detailed implementation planning can happen
II. Enable selection of priority items by applying a set…
I have a table has data in scattered columns (Dx1 - Dx12). Can someone tell me how to move the data from all respective columns to ensure that columns 1 -4 are populated when they are blan…
I am working on a research project which involves a simulation study in which MATLAB calls SAS using the DOS command, passing a script to run, as in:
"c:\sas\SAS 9.1\sas.exe" "C:\Documents and Settin…
Here is my data set by name "file1.sas7b.dat"
Patient ID DOB
1. 2SRE3456 01/12/2014
2. S456HRW 1/2/2014