About rnmishra

rnmishra · ‎03-07-2013

In the following data set I have three variables bad xx and yy. I want to make histograms of XX and YY such that at each level of a variable say XX, I want to divide the column by proportion or percentage of bad=1 and bad=0. My following attempts does this job but it divides each column by percentage of bad=0 and bad=1 w.r.t to all the values of XX. For variable XX, I want bars of the histogram at 2,4,6,8 and 10, however division of each bar should be done based on the number of bad=1/bad=0 within that level of XX. If this can be done, all the vertical bars will have equal height, but get divided by percentage/proportion of bad values within that level of XX. Using the following code I have this plot As always, I am expecting some help from one of you experts. Thanks again for your time!

rnmishra · ‎12-31-2012

Hi Reeza and Hai Kuo, Can you tell me what ' from dictionary.columns' means? Thanks!

rnmishra · ‎12-31-2012

Thanks!!! Works great!

rnmishra · ‎12-31-2012

The data set 'Have' has hundreds of coumns. The column names neither have common prefix nor a suffix. I want to extract column 1 throgh 20 and 60 through 76. Is there a quicker way to accomplish this, without writing all the variable names in select statement? Thanks.

rnmishra · ‎12-29-2012

Thanks all of you for your help. For any beginner like this one, the following material provides some extra tips. SAS(R) 9.3 SQL Procedure User's Guide

rnmishra · ‎12-28-2012

Thanks.

rnmishra · ‎12-28-2012

The values of a variable -var1 of my data set changes every month. I am interested to create a macro variable for each unique value of the variable -Var1.....This time I have 5 different (unique) values of Var1. The macro variable &NumUni counts the number of unique values of Var1. Here is my attempt! The data set have contains a row for each unique value of Var1. %MACRO LOOP; %DO I=1 %TO %sysevalf(&NumUni); DATA _NULL_; SET Have; IF _N_=&I THEN CALL SYMPUTX('X&I',Var1); RUN; %END; %MEND LOOP; In this case NumUni=5, so I should be creating 5 macro variables X1, X2,X3,X4 and X5. There is some thing wrong with SYMPUTX('X&I',Var1); Any help would be highly appreciated! Thanks!

rnmishra · ‎12-20-2012

If I am not mistaken the formatted values are only displayed in SAS outputs. Suppose I have a data set , one of the variables is STATE (State names) I have created a format to to display the state names in their abbriviated form. Now I want to alter this data set permanently by replacing the state names by their abbr. names. My thoughts ....to save the print out put as a new data set....not sure how I can do this. Any suggestions!! Thanks, Raghu.

rnmishra · ‎12-12-2012

Will be doing something like this for my project coming soon. Looking at my data, I am trying to figure out the candidate codes. This works. But I want to do this in a single step, these are my trails, Thanks.

rnmishra · ‎12-11-2012

A data set is given below. Name Age Jack 10 Joe 31 Tom 22 Roe 33 Rex 44 Tim 24 In a single step I am trying to find the person with maximum age from the individuals named Tom , Row and Joe. Thanks

rnmishra · ‎12-11-2012

Thanks!

rnmishra · ‎12-09-2012

I have a data set of the following type: I want to have a single row per ID in such a way that it picks the maximum value of the status at its first occurrence and the month corresponding to the row that has max value of status. The values of the remaining variables should be picked from row 1. The new data set should look like ID Status Amount Month 125 2 1200 2 127 2 1234 2 130 0 212 5 Thanks!

rnmishra · ‎12-08-2012

Great help....I was doing all sort of inefficient coding to fix this!

rnmishra · ‎12-08-2012

Is there a SAS function that extracts only the numerals from a straing For example if F is a sas function then it should give, F(1bhy688%<2) = 16882, F(>%$123abc77 bad guy 88)= 1237788, F( " 1 5 abc 6 ^* +-? ")=156 and so on ? Thanks.

rnmishra · ‎12-06-2012

I have found that a lot of diagnostic plots for non linear regression models can be obtained using the codes available at the SAS support webiste http://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_nlin_sect039.htm ods graphics on; proc nlin data=contrived bias hougaard NLINMEASURES plots(stats=all)=(diagnostics); parms alpha=2.0 gamma=0.0; model y = alpha*x1 + exp(gamma*x2); run; ods graphics off; In addition I am interested to plot the 3D regression surface with axes Y, X1 and X2. My dependent variable is Y and the predictor variables are X1 and X2. My non linear model is similar to the one given above. Thanks in advance for your help. Raghu.

Online Status	Offline
Date Last Visited	‎04-23-2023 07:57 PM

Exporting XML Documents Using an XMLMap

Re: Create library

Re: Reading a 'messy' text file in sas

Reading a 'messy' text file in sas

Extract the number of Tabs and their Names from spreadsheets

Call a macro program referred by a macro variable.

Re: Range

Re: Creating a macro Variable using %Let statement.

Re: Creating a macro Variable using %Let statement.

Creating a macro Variable using %Let statement.

Re: SAS limitation with IN operator

Re: How to hide date variable used to calculate new column in Proc Rep...

Re: SAS Function

Re: Best AIC?

Re: Creating and using Macro variables in a loop

Proc gchart options

Re: Proc sql: Selecting a range of columns-Column reference ?

Re: Proc sql: Selecting a range of columns-Column reference ?

Proc sql: Selecting a range of columns-Column reference ?

Re: Create a macro variable for each unique value of a variable.

Re: Create a macro variable for each unique value of a variable.

Create a macro variable for each unique value of a variable.

Replacing variables by their formatted values....?

Re: Data step-Max Function

Data step-Max Function

Re: Do Loop for each ID variable/Conditional statements

Do Loop for each ID variable/Conditional statements

Re: SAS Function

SAS Function

Plot 3D non linear regression surface.