About Danglytics

Danglytics · ‎02-08-2013

Hi, I have a number of variables i'd like to recode into different variables by range, my data looks like: id Rate1 Rate2 Rate3 Rate4 1 0 10 23 54 2 18 39 23 84 3 4 87 92 8 ... I'd like to create new variables that group them into category indicators for each Rate 0-25, 25-50, 50-75, 75-max I'd like the data to come out: id Rate1 Rate2 Rate3 Rate4 R1_0_25 R1_25_50 R1_50_75 R1_75_M R2_0_25 R2_25_50 R2_50_75 R2_75_M R3_0_25 R3_25_50 R3_50_75 R3_75_M R4_0_25 R4_25_50 R4_50_75 R4_75_M 1 0 10 23 54 1 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 2 18 39 23 84 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 3 4 87 92 8 1 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 ... I started with array's but i didnt think through it very clearly yet so that didnt work, any help is very much appreciated! ARRAY RATELIST {*} RATE1 RATE2 RATE3 RATE4 ; ARRAY NEWCAT {*} R1_75_M R2_0_25 R2_25_50 R2_50_75 R2_75_M R3_0_25 R3_25_50 R3_50_75 R3_75_M R4_0_25 R4_25_50 R4_50_75 R4_75_M ; Do i=1 to dim(NEWCAT) ; if 0 LE RATELIST{i} LE 25 then NEWCAT{i}= 1; else NEWCAT{i}=0 ; if 25 LE RATELIST{i} LE 50 then NEWCAT{i}= 1; else NEWCAT{i}=0 ; if 50 LE RATELIST{i} LE 75 then NEWCAT{i}= 1; else NEWCAT{i}=0 ; if RATELIST{i} GE 75 then NEWCAT{i}= 1; else NEWCAT{i}=0 ; end; Thank you.

Danglytics · ‎11-08-2012

Hi, I'm looking for help in figuring out the logic to parse a text string. The variable contains a string with purchase type, dollar value, and conversions, for example: ID PurchaseType 1 CPA ($2.50 x 20) 2 CPAA ($13.00 x 10) 3 CPC ($0.10 x 100) etc. I'm looking to prse the string by purchase type and value, for example ID Type Value 1 CPA 2.50 2 CPAA 13.00 3 CPC 0.10 etc. Thanks for your help. KD

Danglytics · ‎07-26-2012

Thank you all for the help!

Danglytics · ‎07-25-2012

Hi, I have a dataset that looks like: id q1f_concept q1f_1 q1f_2 q1f_3 q1s_concept q1s_1 q1s_2 q1s_3 1 1 5 4 3 2 3 4 5 2 2 4 4 4 1 3 3 3 etc. I'd like to stack my q1f and q1s together so it would look like: id q1_concept q1_1 q1_2 q1_3 1 1 5 4 3 1 2 3 4 5 2 2 4 4 4 2 1 3 3 3 etc. I'm not sure what the best/simplest way to do it is, but I believe a single data step using arrays would do the trick. Thanks for your help!

Danglytics · ‎05-17-2012

Hi, I have a variable set with variables q1_0_on, q1_0_ab, q1_1_on, q1_1_ab ... etc. all the way to q1_12_on, q1_12_ab. Essentially what i'd like to do is to recode it into a different variable with a scale (1,0,-1) with an array. q1_0 = 0; if q1_0_on=1 and q1_0_ab=0 then q1_0=1; if q1_0_on=0 and q1_0_ab=1 then q1_0=-1 ; i could duplicate the code above 12 times but i was hoping there's an easy way with an array. Thanks for your help!

Danglytics · ‎04-13-2012

Hi, I have a transactional dataset that is keyed on an ID that is a 7 character string, I would like to recode this ID to a numeric ID. Input dataset would look like PID status abcdefg A abcdefg B bcdefgh A cdefghi A etc.. I would like my ouput dataset to look like PID status NID abcdefg A 1 abcdefg B 1 bcdefgh A 2 cdefghi A 3 etc.. The logic I thought about is using PROC FREQ to get all the unique PID and use the _N_ as the new recoded NID and match back to the original dataset, but i'm not sure how to create the recode dataset on the ouput of PROC FREQ. I know the following doesnt work but i'm not sure how to get what I want.. PROC FREQ DATA=WORK.INPUT NOPRINT ; TABLE PID ; OUTPUT OUT=WORK.RECODE _N_ ; RUN ; Thanks for your help.

Danglytics · ‎03-20-2012

Hi, What i'm trying to do is to stack 3 different datasets with the exact same structure using macros to identify the files by a timestamp for each of the datasets. I'm unsure why i'm getting an error with the code below: %LET CUR_MONTH=2012FEB29; %LET PREV_MONTH=2012JAN31 ; %LET PREV_MONTH2=2011DEC31 DATA RATED.RATEDEVENT_L3MTH_STACK_&CUR_MONTH ; SET RATED.RATED_EVENT_&CUR_MONTH RATED.RATED_EVENT_&PREV_MONTH RATED.RATED_EVENT_&PREV_MONTH2; RUN ; ERROR: File WORK.GOPTIONS.DATA does not exist. ERROR: File WORK.NOACCESSIBLE.DATA does not exist. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set RATED.RATEDEVENT_L3MTH_STACK_2012FEB29 may be incomplete. When this step was stopped there were 0 observations and 10 variables. WARNING: Data set RATED.RATEDEVENT_L3MTH_STACK_2012FEB29 was not replaced because this step was stopped. Thanks for your help.

Danglytics · ‎03-19-2012

Hi, I can't seem to figure out this logic with my data. I have 2 files, Charges and Adjustments. Charges looks like: id date product amount 1 01jan2012 box 20 1 03jan2012 ball 5 1 04jan2012 chair 10 2 02feb2012 camera 100 2 03feb2012 cup 4 ... Adjustment looks like: id date product amount 1 03jan2012 refund -5 2 03feb2012 refund -4 .. I'd like to create a table that removes all adjustments from the charges table WANT: id date product amount 1 01jan2012 box 20 1 04jan2012 chair 10 2 02feb2012 camera 100 the Product variable in the Adjustment table will always be 'refund' and can not match back to Charges. To figure out which rows are to remove Date and Amount variables from Adjustment will have to be used to identify the row to remove from the Charges table. Thank you for your help.

Danglytics · ‎03-15-2012

Perfect, thank you both.

Danglytics · ‎03-15-2012

Thanks PG for your response. in the ParameterEstimates statment, my variable names are being truncated, is it possible to set the variable field length to $32, and select based on ProbChiSq = <.0001 ?

Danglytics · ‎03-15-2012

Hi, I am using the following code: PROC LOGISTIC DATA=A.DATA_VARCLUS_CORR DESCENDING; MODEL TARGET=&VARLIST2 /SELECTION=STEPWISE SLS=0.01 SLE=0.01; RUN; As a result of the code above, I get an output that includes, among other things, the following: Analysis of MaximumLikelihood Estimates Standard Wald Parameter DF Estimate Error Chi-Square Pr > ChiSq This output is outputted into a window. I would like to have the output into a separate file, in particular fields that I havehighlighted in red. I tried to use OUTMODEL= option, but that doesnt seem to output what I need. Thanks for your help.

Danglytics · ‎03-13-2012

thank you for your replies. proc sql; *get columns in your dataset; create table vnames as select name from dictionary.columns where libname=your_libname and memname=yourdataset; do i have to select the variable names in this statement?

Danglytics · ‎03-13-2012

Hi, I hope someone could help me with this problem: I have a data file a.data with accounts and their attributes across ~100 variables I have a list of variables – as a separate file – a.vars,which contains a subset of 100 variables (let’s say 20 of the 100) I need to code a process that would drop from a.data all variables that are not in a.vars file. It has to be SAS process (not manualwork through EXCEL), that just does it in a completely automated manner. a.data: id var1 var2 var3 var4 var5 1 0 1 1 0 1 0 .. a.vars: var1 var2 var3 var6 var7 new.data id var1 var2 var3 1 0 1 1 Thanks for your help.

Danglytics · ‎03-07-2012

Thank you very much.

Danglytics · ‎03-07-2012

Great thank you that worked. Is there a way to get FILE_PERIOD into a character format with the following format structure? for example the code above will give me 31Jan2012, but i'd like FILE_PERIOD to be 2012Jan31 so that it is consistent with my other formats.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

array and loops? recoding into different variables

Text Parsing

Re: Stacking data

Stacking data

Help with Arrays

Proc Freq Output

what is wrong with this code?

data step logic

Output Proc Logisitic into a dataset

Output Proc Logisitic into a dataset

Renaming unconventional Variable names

Re: Data check program: logic

array and loops? recoding into different variables

Text Parsing

Re: Stacking data

Stacking data

Help with Arrays

Proc Freq Output

what is wrong with this code?

data step logic

Output Proc Logisitic into a dataset

Output Proc Logisitic into a dataset

Output Proc Logisitic into a dataset

Process to remove variables from another dataset

Process to remove variables from another dataset

Re: end of month date

Re: end of month date