About saslove

saslove · ‎10-24-2013

Does that include all the previous datasets until the current one I am comparing with. For some reason, I don't get the numbers I am looking for. For instance, for fileid=9, there were only 20 new vehicles added, but I get 714.

saslove · ‎10-24-2013

Any ideas? I want all of my previous datasets in my merge statement and the new file to be compared to all the older datasets. Inputs please

saslove · ‎10-24-2013

Looks like I was wrong. What I wanted in the merge statement is to merge all the previous datasets. How should that be done? For instance: %macro files (first_file=); data compare%eval(&first_file+2); merge fileid&first_file fileid%eval(&first_file+1); ------- Here instead of first_file, I want everything before 8,.. That is merge all previous fileid 7,6,5,4,3,2,1 by vehid; run; ...... %mend files; %files (first_file=8)

saslove · ‎10-24-2013

That is helpful, but I am having a problem with adding the SQL code to the macro proc sql; select count(*) from (select distinct vehicleid from &first_file+2 except select distinct vehicleid from compare%eval(&first_file+2)); quit; Is the bolded part right? I get this error SAS Log: There were 683 observations read from the data set WORK.FILEID6. NOTE: There were 621 observations read from the data set WORK.FILEID7. NOTE: The data set WORK.COMPARE8 has 843 observations and 15 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Line generated by the macro variable "FIRST_FILE". 1 6 - 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY. ERROR 76-322: Syntax error, statement will be ignored. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

saslove · ‎10-24-2013

I want to build a macro that does the following data steps, but I am not sure how to use the consecutive variable list. For example: data compare7; merge fileid5 fileid 6; by vehid; run; proc sql; select count(*) from (select distinct vehicleid from fileid7 except select distinct vehicleid from compare7 ); quit; data compare8; merge compare7 fileid7; by vehid; run; proc sql; select count(*) from (select distinct vehicleid from fileid8 except select distinct vehicleid from compare8 ); quit; data compare9; merge compare8 fileid8; by vehid; run; proc sql; select count(*) from (select distinct vehicleid from fileid9 except select distinct vehicleid from compare9 ); quit; data compare10; merge compare9 fileid9; by vehid; run; proc sql; select count(*) from (select distinct vehicleid from fileid10 except select distinct vehicleid from compare10 ); quit; At the end of each data step, I do a PROC SQL to compare the distinct variables from the merged files and a new file (fileid8). Please help me with developing a macro for this as I have to compare more than 100 files and it is impractical to do it manually at every step. How do I add the consecutive variables at every step in a macro?

saslove · ‎04-09-2013

I wonder if there is no simple ods output statement

saslove · ‎04-09-2013

And I don't want to use proc logistic!

saslove · ‎04-09-2013

Is there a way for PROC FREQ to output sensitivity and specificity values to an output dataset so I can plot an ROC curve?

saslove · ‎03-06-2013

Anyone done anything similar????

saslove · ‎03-06-2013

I came across this question at work. I would like to have your input. I have never done monte carlo and i am a newbie. So, please excuse my dumbness! I want the standard error from model , error estimate and confidence interval on predicted number of response variable. I want to do simulation (i was told multiply predicted probability by case weight and sum it all up and repeat 1000 times). I need 2.5th and 97.5th % confidence interval and errors on percent predictions. PROC SURVEYLOGISTIC was used for analysis. I then used xbeta and stdxbeta to get the linear predictors and standard error of linear predictor. I back transformed the values. I'm trying to use PROC MCMC here. So, I assume standard error is normally distributed and resample error 1000 times. Also, I need a confidence interval on full prediction and sample error on output. I would like some help here as to use PROC MCMC for getting the desired output. These are just the notes I took from our meeting. This is the surveylogistic code. proc surveylogistic data=outboot; where var1="abc" and var2 in ("abc") and var3 in (11, 13) and var4>15 and var6>1999 and 85>var7>15; format var varfmt..; stratum strat; cluster psu; weight weight; class var var2 /param=ref; model resp (desc)=vara varb varc vard / Rsquare ; output out=outall predprobs=individual xbeta=predval stdxbeta=sepred; run; How do I use PROC MCMC to get confidence intervals and standard errors. I need CI on full prediction and need to sample error on output. Please help.

saslove · ‎05-09-2012

This seems to work , but is there an easy way I could use use all variables in one macro statement instead of calling the macro 167 times?

saslove · ‎05-09-2012

Thanks a lot for your replies. It still doesn't seem to work. I tried all of these options. It gives me the same error ERROR 180-322: Statement is not valid or it is used out of proper order.

saslove · ‎05-08-2012

I have this macro to convert character to numeric variable for more than 100 variables. But it doesn't seem to work and gives me an error: 180-322: Statement is not valid or it is used out of proper order. My code is as below: %macro numeric (var); data recode2005_7; set recode2005_6; &var _c=input(&var ,8.); run; %mend numeric; %numeric (age sex grade am_indi... var 100); The SAS log highlights age and pops the above error. Not sure what it is. Tried putting var= on macro statement and other alternatives, but doesn't work.

saslove · ‎10-05-2011

Hello I tried doing this, but I need a cluster plot with all the 33 variables shown across the plot on three different clusters. I have no idea how I should be plotting this. ? Could someone help? Thanks

saslove · ‎10-04-2011

Hi. I am doing a Cluster analysis. I ended up doing Hierarchial Clustering by Wards method for my binary(dichotomous) variables dataset. I would like to know how I can get a scatter plot showing the three clusters neatly in different symbols and colors. I am struggling with this. Can you please help me. Thanks PNS

Online Status	Offline
Date Last Visited	a week ago

FTP connection was reset by peer

Flyover of a number

PROC SQL max value with corresponding visit

Re: SAS Custom Sort

Re: SAS Custom Sort

Re: SAS Custom Sort

SAS Custom Sort

Re: Strip date stamp from 30 datasets

Re: Strip date stamp from 30 datasets

Re: Strip date stamp from 30 datasets

Re: SAS Custom Sort

Re: Consecutive Variable list Macro

Re: INSERT NEW LINE IN RTF

Re: MERGED TWO FILES BUT THE NEW FILE OMTING MANY OBSERVATIONS

Re: scatter plots

Re: Consecutive Variable list Macro

Re: Consecutive Variable list Macro

Re: Consecutive Variable list Macro

Re: Consecutive Variable list Macro

Consecutive Variable list Macro

Re: Specificity/Sensitivity values to an output dataset - PROC FREQ

Re: Specificity/Sensitivity values to an output dataset - PROC FREQ

Specificity/Sensitivity values to an output dataset - PROC FREQ

Re: PROC MCMC for surveylogistic to resample error and get full CI

PROC MCMC for surveylogistic to resample error and get full CI

Re: Macro to convert character to numeric variable

Re: Macro to convert character to numeric variable

Macro to convert character to numeric variable

cluster analysis

cluster analysis