About Nikos

Nikos · ‎09-28-2014

just a typo in the last by group: where 'O' should be replaced with 'V' Thank you

Nikos · ‎09-28-2014

Dear all, In a by group I have missing values in variable STATUS for various Trade_Quarters. I would like to replace the STATUS missing values based on the following: If STATUS = 'C' (=cancelled) then if any SUBSEQUENT TRADE_QUARTERS take STATUS ='C' If STATUS = 'C' (=cancelled) then if any PRIOR TRADE_QUARTERS take STATUS = 'V' (=Valid) If there is no STATUS = 'C' then ALL values of STATUS become = 'V' Pls. see data HAVE and WANT in the attached file. Thanking you in advance for any hint. Kind regards Nikos

Nikos · ‎06-23-2014

Dear all, I would very much appreciate your help. I have a variable that should contain letters and numbers in a predefined combination i.e. XYZ1234 (3letters - any letters and 4 numbers - any numbers) The problem is that some values they have: 1.- 2 letters (false) and 3 numbers (false) 2. 3 letters (correct) and 3 numbers (false) 3.- sometimes within the 3 letters there is one or more numbers while they shouldn't have been 4. the same applies to letters section ( there are letters instead of numbers 5.-- No letters only numbers --more than 4 etc.. I would like to create a variable that will flag each and every discrepancy from the required as above (3 letters+ 4 numbers) Thanking you in advance. Best Nikos

Nikos · ‎05-06-2014

Dear all, I join two datasets A and B on two common variables VARA and VARB. Those two datasets have a number of common variables that after the join should have equal values across all joined records Var1_A = Var1_B, ,Var2_A = Var2_B ...etc. Unfortunately that is not happening and I would like to summarize all these unequal pairs of values. VARA VARB ( Var1_A Var1_B ) (Var2_A Var2_B) 100 100 50 . 50 20 20 200 200 32 . 45 45 300 300 67 67 . 53 400 400 . 72 23 23 ............................................................................... In addition to the above the number of common variables that have unequal pairs of values is significant (>100) which makes very cumbersome to search one by one. Any hints most welcome. Thank you in aFladvance. Nikos

Nikos · ‎05-03-2014

Dear all, I have a huge dataset with the following info ID_A ID_B EXP_A EXP_B CREATION_DATE RAT_X 1 4797 6667 KMH1 24OCT2011:13:52:22 4 1 4797 6667 06AUG2012:22:44:30 17 55 11236 6667 ADN1 03JUN2012:08:05:29 3 1 4797 6667 MR01 27MAR2012:08:56:08 17 1 4797 6667 JHM1 24OCT2011:13:51:46 4 1 4797 6667 JHM2 24OCT2011:13:51:43 4 55 11236 6667 ADN1 03JUN2013:10:54:19 3 I need to flag or save in a different dataset all the observations that for variable EXP_A have different EXP_B and RAT_X Please note that generally the EXP_A is grouped under ID_A & ID_B, although it seems that the same EXP_A can be found under two or more different groupings by ID_A & ID_B values (I do not know whether this is an error or not ) Thank you in advance. Best regards Nikos

Nikos · ‎05-03-2014

Dear PG, Unfortunately I do not have proc selectsurvey. Thank you Nikos

Nikos · ‎05-02-2014

Dear all, I have a table that can by grouped by two variables (i.e. VARA and VARB). How can I randomly select groups of observations by VARA and VARB rather than single random observations. Thank you in advance Best regards Nikos

Nikos · ‎04-30-2014

Dear all, I have a Library with unknown number of data sets and variables. I would be grateful if you could provide me with, say a MACRO that loops through the LIBRARY and create summary tables with the following info. 1.--- Number of Datasets that reside in the Liibrary, their Names and the number of observations for each one of them 2.-- Number of variables, names and labels , type (char or numeric), length for EACH Variable within the various Datasets 3.-- For Character variables the different levels/categories (i.e. SEX -- Male, Female) including Missing and their respective Frequencies 4.-- For Numeric Values info similar to that generated by a PROC UNIVARIATE (i.e. Mean, Median, Std, Outliers etc.) Thank you in advance. Best regards Nikos

Nikos · ‎07-06-2012

Thank you all for your solutions Kind regards Nikos

Nikos · ‎07-02-2012

Hi Hai Kuo, Thank you for your code. I might have not been very clear but I want each and every ID group to "expand" up and including the Maximum TRNS_MONTH of the dataset, in which case is 201112. Thank you again. Nick

Nikos · ‎07-02-2012

Hi all, I want to "expand" a dataset (without using PROC EXPAND) by adding missing observations based on TRNS_MONTH and TRNS_QTR by each ID group. In the new added rows Colour and Weight needs to copy down their values while the AMTS (AMT_1 to AMT_4 needs to be set equal to zero. Expansion needs to be carried up to the MAX TRNS_MONTH & TRNS_QTR as they are determined by ID 704 green ow 201112 2011Q4 Thank you very much in advance Nik DATA HAVE ID Colour Weight TRNS_MONTH TRNS_QTR AMT_1 AMT_2 AMT_3 AMT_4 811 blue ow 201108 2011Q3 4900 0 0 0 811 blue ow 201109 2011Q3 0 4580 230 700 704 green ow 201003 2010Q1 33400 0 450 0 704 green ow 201008 2010Q3 11 48000 0 0 704 green ow 201012 2010Q4 345 5000 0 -8900 704 green ow 201112 2011Q4 23300 0 0 2145 38 red ow 201012 2010Q4 3300 0 0 0 38 red ow 201101 2011Q1 0 1300 0 560 DATA WANT ID Colour Weight TRNS_MONTH TRNS_QTR AMT_1 AMT_2 AMT_3 AMT_4 811 blue ow 201108 2011Q3 4900 0 0 0 811 blue ow 201109 2011Q3 0 4580 230 700 811 blue ow 201110 2011Q4 0 0 0 0 811 blue ow 201111 2011Q4 0 0 0 0 811 blue ow 201112 2011Q4 0 0 0 0 704 green ow 201003 2010Q1 33400 0 450 0 704 green ow 201004 2010Q2 0 0 0 0 704 green ow 201005 2010Q2 0 0 0 0 704 green ow 201006 2010Q2 0 0 0 0 704 green ow 201007 2010Q3 0 0 0 0 704 green ow 201008 2010Q3 11 48000 0 0 704 green ow 201009 2010Q3 0 0 0 0 704 green ow 201010 2010Q4 0 0 0 0 704 green ow 201011 2010Q4 0 0 0 0 704 green ow 201012 2010Q4 345 5000 0 -8900 704 green ow 201101 2011Q1 0 0 0 0 704 green ow 201102 2011Q1 0 0 0 0 704 green ow 201103 2011Q1 0 0 0 0 704 green ow 201104 2011Q2 0 0 0 0 704 green ow 201105 2011Q2 0 0 0 0 704 green ow 201106 2011Q2 0 0 0 0 704 green ow 201107 2011Q3 0 0 0 0 704 green ow 201108 2011Q3 0 0 0 0 704 green ow 201109 2011Q3 0 0 0 0 704 green ow 201110 2011Q4 0 0 0 0 704 green ow 201111 2011Q4 0 0 0 0 704 green ow 201112 2011Q4 23300 0 0 2145 38 red ow 201012 2010Q4 3300 0 0 0 38 red ow 201101 2011Q1 0 1300 0 560 38 red ow 201102 2011Q1 0 0 0 0 38 red ow 201103 2011Q1 0 0 0 0 38 red ow 201104 2011Q2 0 0 0 0 38 red ow 201105 2011Q2 0 0 0 0 38 red ow 201106 2011Q2 0 0 0 0 38 red ow 201107 2011Q3 0 0 0 0 38 red ow 201108 2011Q3 0 0 0 0 38 red ow 201109 2011Q3 0 0 0 0 38 red ow 201110 2011Q4 0 0 0 0 38 red ow 201111 2011Q4 0 0 0 0 38 red ow 201112 2011Q4 0 0 0 0

Nikos · ‎06-28-2012

QST takes the value 2 under more than one assumption Thank you

Nikos · ‎06-28-2012

Hi all, I have the attached data file that shows monthly transactions grouped by the variable KEY_V. Variables POS , NEG and QST are not included in my original dataset. I want to create them based on the following assumptions: 1.- When AMT_1 = 0 across ALL records of the BY Group Vat KEY_V then var QST = 1 (by groups 1,2 & 3) 2.- When AMT_1 = 0 and ANY of the other AMT_2, AMT_3, AMT_4 has a value different from zero then var QST = 2 (by groups 4,7,8,9) 3.- a) When AMT_1 not equal to zero at the first record of the By Group then POS=1 and NEG=0 (and QST=0). The same pattern is followed until it hits the first record with AMT_1 = 0 then POS=0 and NEG=1 (and QST=0) b) Extending a) If right after we have more subsequent records with AMT_1 =0 then POS=0 and NEG=0 and QST =2 if ANY of the other AMT_2, AMT_3, AMT_4 has a value different from zero or QST =3 if ALL of the other AMT_2, AMT_3, AMT_4 equal 0 (by groups 7,9) Finally I would like to to summarize the counts for POS, NEG and QST both simple counts and CUMULATIVE By ORG_YEAR (as a column ) and TRNS_QTR (as a row). Any suggestions or hints will be more than welcome. Thank you in advance Nik

Nikos · ‎06-20-2012

Hi all, I have a dataset that looks like this: CV_ID TRNS_MONTH SUM_MONTH Cnt_ID_MONTH 100 200101 1,500 1 100 200102 0 1 100 200103 1,400 1 100 200104 2,300 1 100 200105 1,100 0 200 200306 360 1 200 200307 500 1 200 200308 700 1 200 200309 0 1 200 200310 450 1 200 200311 0 0 I want to have: CV_ID TRNS_QTR SUM_QTR Cnt_ID_QTR 100 2001Q1 2,900 1 100 2001Q2 3,400 0 200 2003Q2 360 1 200 2003Q3 1,200 1 200 2003Q4 450 0 I believe that Proc sql would be helpful. Any hints / suggestions would be very much apprecuiated Best regards Nikosly -

Nikos · ‎05-28-2012

Hi all, I need to create a single SAS data set by importing several TXT files by the names, residing in a specified folder: Q_RED_2001Q1.txt, Q_RED_2001Q2.txt, Q_RED_2001Q3.txt, Q_RED_2001Q4.txt, Q_GREEN_2001Q1.txt, Q_GREEN_2001Q2.txt, Q_GREEN_2001Q3.txt, Q_GREEN_2001Q4.txt, Q_RED_2002Q1.txt, Q_RED_2002Q2.txt, Q_RED_2002Q3.txt, Q_RED_2002Q4.txt, Q_GREEN_2002Q1.txt, Q_GREEN_2002Q2.txt, Q_GREEN_2002Q3.txt, Q_GREEN_2002Q4.txt ........................................................................................................................................... I need also, in the new total SAS dataset to create two more identifier variable i.e. TYPE ( RED or GREEN) and TRANSACTION_QTR (2001Q1 or 2001Q2 or 2001Q3 etc.) I would very much appreciate any hints. Thank you ina dvance Nikos

Online Status	Offline
Date Last Visited	‎02-10-2016 04:50 PM

Re: Delete duplicate obs with HASH based on three or more variables an...

Re: Delete duplicate obs with HASH based on three or more variables an...

Delete duplicate obs with HASH based on three or more variables and on...

Multiple lines per graph -- Put many graphs in one sheet too cluttered

Successively multiply values of lower part of a matrix with an array

Re: Array linear interpolation

Re: Array linear interpolation

Re: Array linear interpolation

Re: Array linear interpolation

Array linear interpolation

Proc Sql calculating counts & percentages for groups and subgroups

Re: By Group -- Replace a var's values based on another variables spec...

By Group -- Replace a var's values based on another variables specific...

Check a character variable against a predefined pattern of letters and...

Join two tables - Flag and summarize common variables that have unequa...

Flagging out observations based on multiple by group values

Re: Select random groups of observations rather unique observations

Select random groups of observations rather unique observations

Explore & Summarize info about a Library Members(datasets) and their v...

Re: "Expand" a "timeseries" dataset without using Proc Expand

Re: "Expand" a "timeseries" dataset without using Proc Expand

"Expand" a "timeseries" dataset without using Proc Expand

Re: Create Identifiers (based on certain assumptions) and summarize th...

Create Identifiers (based on certain assumptions) and summarize them -...

From Monthly to Quarter - Summing amounts & transforming counts

Import many txt files and create variables out of the txt dataset Name...