About sasmaverick

sasmaverick · ‎06-07-2017

Hi, I am associating a user defined format with a variable and generating a freq report. I want to see all values of proc format in the report, even though they may not be in the dataset. Below is an example. proc format; value test .='Missing' low-<0='<0' 1-5='1-5' 6-10='6-10' 11-15='11-15' 16-high='15+' ; run; data test; infile datalines; input a; datalines; . -1 5 7 18 ; run; proc freq data=test; tables a/list missing sparse; format a test.; run; The resulting report does not show the 11-15 range since it is not in the dataset. I want to show missing for 11-15. Help appreciated.

sasmaverick · ‎01-12-2017

Hi Reeza, Below is the code I am using proc standard data=sample mean=0 std=1 out=sample_out; var amount transaction; run; Would this give me the top 15% customer if I put the condition "amount>1" and bottom 15% if I put "amount<-1". This is the score calculated from the above step for amount. I see some conditions are not fulfilled and I get 0 observations. For example if I put transaction<-1 Thanks

sasmaverick · ‎01-11-2017

Hello, I have a 10,000 records data set. Using z-score I need to select and flag the records as follows: 1. Top 15% high $$ customers (z-score of the dollar_amt variable greater than +1) 2. Bottom 15% low $$ customers (z-score of the dollar_amt variable less than -1). I need to know if there is a way to do this in SAS and how. Regards,

sasmaverick · ‎12-26-2016

Thank you, I was able to do it by setting default formats for frequencies by using PROC Template.

sasmaverick · ‎12-25-2016

I see that when I apply proc freq on a variable in a large dataset, the result gets truncated to scientific notation. Eg. for the below on a dataset of 35 Million records Proc freq data=sales; Tables region; Run; Gives me the frequencies like follows US 2.15E8 UK. 1.59E7 EMEA 100000 I want the numbers to appear completely with a comma separator. I tried using formats (best12. and comma12.) in the tables statment but to no avail. Help appreciated! Sasmaverick

sasmaverick · ‎12-06-2016

Hello, I have the following dataset data test; infile datalines; input Est_inc $3.; datalines; 008 015 020 040 051 060 061 070 150 ; run; The values are character but are clean data. I want to specify range as follows, but unsuccesful. Please help. proc format; value $ emp; "008"-"020"="8-20" "040"-"060"="40-60" "061"-"150"="61-150" ; run; Regards,

sasmaverick · ‎08-18-2016

Adding to the above requirment, I may also need to pick last non missing in a BY group. That is, I don't need to assign 80 if X=2.

sasmaverick · ‎08-18-2016

I have the following dataset: X Y 1 70 1 . 1 . 1 . 1 80 1 . 1 . I want to assign the last non missing value to the missing observations. Expected output as follows X Y 1 70 1 70 1 70 1 70 1 80 1 80 1 80 Please help. I tried do end loop but to no use.

sasmaverick · ‎08-10-2016

Yours alongwith Ballardw's suggestion helped me. Thanks

sasmaverick · ‎08-10-2016

Hi Reeza, I had to keep the Excel file open all the time and then run the code, which worked for me! Thanks

sasmaverick · ‎08-10-2016

The question I am asking is I have the following dataset: Month 1 2 3 4 5 6 7 8 9 10 11 12 ...till 48 Expected Output as follows: Month Year 1 2012 2 2012 3 2012 4 2012 5 2012 6 2012 7 2012 8 2012 9 2012 10 2012 11 2012 12 2012 1 2013 2 2013 3 2013 4 2013 5 and so on.....till 12

sasmaverick · ‎08-10-2016

What I am saying is I have only month data in the dataset (1-48). For the first 12 months, I want the date variable as 1-2012, 2-2012 till 12-2012. For the next 12, I need date as 1-2013, 2-2013 and so on.... I dont want the date as 48-2015, Instead I want it as 12-2015

sasmaverick · ‎08-10-2016

Hi Reeza, I tried this, but I am getting 2304 observation when in fact I should only get 48. Regards,

sasmaverick · ‎08-10-2016

I have the following dataset: Month 1 2 3 4 5 6 7 8 9 10 11 12 .... till 48. I want to create a variable which appends 2012 from 1 to 12, then 2013 for 12-24 and 2014 from 24-48 and so on as follows. How to do this? month-year 1-2012 ... 12-2012 1-2013 .... 12-2013

sasmaverick · ‎08-09-2016

Actually I was able to use DDE for the first time. And it does work every now and then but not consistently. What would be the best way to control which row and which cell (specify a range) I write to in excel. Note: I do not have a SAS ACCESS license at my workplace. Regards,

Online Status	Offline
Date Last Visited	‎01-19-2023 12:48 AM

Re: Select Subset of a Group and Return All Rows

Re: Select Subset of a Group and Return All Rows

Select Subset of a Group and Return All Rows

Re: Create Volatile Table in Teradata Using ODBC

Re: Create Volatile Table in Teradata Using ODBC

Re: Create Volatile Table in Teradata Using ODBC

Unable to Transfer Large SAS Dataset to Teradata Using ODBC

Create Volatile Table in Teradata Using ODBC

Re: Restructure Dataset

Re: Restructure Dataset

Re: Select Subset of a Group and Return All Rows

Re: Restructure Dataset

Re: Summarize by Multiple Variables in Data Step

Re: Month-Year Loop

Re: Country Code Format Lookup

Re: Create Volatile Table in Teradata Using ODBC

Show All Ranges of Proc Format in Proc Freq

Re: Calculate Z Score

Calculate Z Score

Re: Formatting Scientific Notation in PROC FREQ

Formatting Scientific Notation in PROC FREQ

Specifying character Values as Ranges

Re: Pick The Last Non Missing Value

Pick The Last Non Missing Value

Re: Month-Year Loop

Re: SAS DDE to Excel 2013 freezes SAS

Re: Month-Year Loop

Re: Month-Year Loop

Re: Month-Year Loop

Month-Year Loop

Re: SAS DDE to Excel 2013 freezes SAS