About Nikos

Nikos · ‎05-11-2012

Hi all, I have a data set with ID_NO , TRANSACTION_DATE , PRODUCT, NAME and STATE the By GROUP variables are ID_NO & TRANS_DATE Although I would expect NAME and STATE to be the same across each BY GROUP, this is not the case. ID_NO TRANS_DATE PRODUCTS NAME STATE 255 3/2/2012 BED JOHN NY 255 3/2/2012 PILLOW JOHN NY 255 3/2/2012 MATTRES JOHN NY 468 9/12/2012 BED MIKE California 468 9/12/2012 PILLOW MIKE MARYLAND 468 9/12/2012 MATTRES MIKE California 137 6/25/2012 BED JIM Michigan 137 6/25/2012 PILLOW JIM MARYLAND 137 6/25/2012 MATTRES TOM Michigan 137 6/25/2012 MATTRES JIM Michigan I would like to run a PROC SQL that would identify these BY GROUP that deviate and at the same time to provide percentages of how many of these BY GROUP are diffferent a) in NAME b) in STATE Any suggestions would be much appreciated. Kind regBY GROUP rards Nikos

Nikos · ‎04-18-2012

Hi, I have a macro that calls several data sets at certain step i use a proc transpose that creates a new variable as follows CNT_&STATE with &STATE (macro variable)and taking values like AON, KAT etc. depending on the input of the initial data set used. Subsequently the output data set of the proc transpose is further developed but at this stage I would like to: a) check whether var CNT_&STATE is a character or numeric var b) if it is character var then to change it to numeric Any suggestions more than welcome Thank you in advance Best regards Nikos

Nikos · ‎03-21-2012

Hi all, I have a SAS dataset that I would like to delete when all the values of one of its variables are all missing. Any suggestions would be more than welcomed. Thank you in advance Kind regards Nikos

Nikos · ‎03-21-2012

Hi, I would like to thank you Nikos

Nikos · ‎03-15-2012

Hi, I am trying to transpose a data set from "Wide to Long". The numeric variables (to be transposed based on a BY variable group) in the initial WIDE dataset have names F2,F3,F4,.....F20 After the transposition, in the new _NAME_ variable I would like to have the above names RENAMED as follows 12 24 36 ... ... 228 (i.e. starting F2=12 F3=24 ...F20= 228 - incrementing by 12) Any suggestions would be more than welcomed. Thank you Nikos

Nikos · ‎03-12-2012

Hi all, Unfortunately SCAN with "M" modifier works under SAS 9.2. Since I still work with SAS 9.1.3 I would appreciate any workaround. Thank you in advance Kind regards Nikos

Nikos · ‎03-12-2012

You are right. That was a mistatement of mine.

Nikos · ‎03-12-2012

Art, You were right. The particular value sould read DEF_K__HIGH meaning that the third "word" is missing and HIGH should be placed under V4. The rule is that each "word" is positioned under a new variable based only on its place in the initial variable The word before the first "_" goes to VAR1, the "word" between the first "_" and the second "_" goes to the second variable V2, etc. If there are two "_" in a row then missing goes to the respective New Variable. Thank you in advance Kind regards Nikos

Nikos · ‎03-12-2012

I would like to thank you all. Kind regards Nikos

Nikos · ‎03-12-2012

Hi, I have a variable with character values as: VAR0 ABC_F_P_LOW DEF_K_HIGH ZPQ_M_X_MEDIUM GKL_J_B ..................... I would like to create four new variables as: V1 V2 V3 V4 ABC F P LOW DEF K HIGH ZPQ M X MEDIUM GKL J B ................................. I have tried certain Character Functions but they do not position correctly the "words" in the right new created variable (i.e. HIGH goes to V3 while it should go to V4). I would appreciate any suggestions. Thank you in advance Kind regards Nikos

Nikos · ‎03-08-2012

Hi, I have a data set with BRANCH, OPEN_DATE (start date for the Branches operation), products SHOES & CLOTHES and Payments & Expenses (PMTS , EXPNS) Time is measured in QTR i.e. 200503 the 3rd QTR of 2005. I would like to choose a BRANCH say at a past OPEN_DATE and based on the following checks "looking forward in the future TRANDATE QTR up to 201104" : 1.- both PRODUCTS show both PMTS & EXPNS at each "future QTR" 2.- Transaction are occuring at EACH and E VERY subsequent TRANDATE QTR up to 201104 to output in a different dataset. In the following dataset only BRANCH - GTR satisfies all checks OPEN_DATE BRANCH TRANDATE SHOES CLOTHES PMTS EXPNS 200503 LON 200503 S C 1000 200 200503 LON 200602 S C 900 100 200503 LON 200603 S C 1600 230 200503 LON 200604 S C 3100 290 200503 LON 200701 S C 880 170 200503 LON 200702 S C 1000 200 200503 LON 200904 S C 1000 200 200503 LON 201002 S C 1000 200 200503 LON 201103 S C 1000 200 200604 FTH 200604 S C 1000 200 200604 FTH 200703 C 1000 200 200604 FTH 200704 S C 1000 200604 FTH 200803 S 1000 200 200604 FTH 200901 S C 200 200604 FTH 200902 S C 1000 200 200604 FTH 200903 S 1000 200 200604 FTH 201004 C 200 200604 FTH 201102 S C 1000 200 200701 GTR 200701 S C 1000 200 200701 GTR 200702 S C 900 100 200701 GTR 200703 S C 1600 230 200701 GTR 200704 S C 3100 290 200701 GTR 200801 S C 880 170 200701 GTR 200802 S C 1000 200 200701 GTR 200803 S C 1000 200 200701 GTR 200804 S C 1000 200 200701 GTR 200701 S C 1000 200 200701 GTR 200702 S C 900 100 200701 GTR 200703 S C 1600 230 200701 GTR 200704 S C 3100 290 200701 GTR 200801 S C 880 170 200701 GTR 200802 S C 1000 200 200701 GTR 200803 S C 1000 200 200701 GTR 200804 S C 1000 200 200701 GTR 200701 S C 1000 200 200701 GTR 200702 S C 900 100 200701 GTR 200703 S C 1600 230 200701 GTR 200704 S C 3100 290 200701 GTR 200801 S C 880 170 200701 GTR 200802 S C 1000 200 200701 GTR 200803 S C 1000 200 200701 GTR 200804 S C 1000 200 200701 GTR 200901 S C 1000 200 200701 GTR 200902 S C 900 100 200701 GTR 200903 S C 1600 230 200701 GTR 200904 S C 3100 290 200701 GTR 201001 S C 880 170 200701 GTR 201002 S C 1000 200 200701 GTR 201003 S C 1000 200 200701 GTR 201004 S C 1000 200 200701 GTR 201101 S C 1000 200 200701 GTR 201102 S C 900 100 200701 GTR 201103 S C 1600 230 200701 GTR 201104 S C 3100 290 Any suggestuions would be more than welcomed. I would like to thank you in advance Kind regards Nikos .......................................................................

Nikos · ‎03-06-2012

Hi all, I try to import in SAS multiple EXCEL files. Specifically I import "Named ranges" that reside in various spreadsheets (from various EXCEL files). Each "named range" has a name like BLUE_GREEN_WHITE_N_P_1999 BLUE_GREEN_WHITE_N_P_2000 ........................ ........................ BLUE_RED_WHITE_N_P_1999 BLUE_RED_WHITE_N_P_2000 ........................ ........................ etc. Is it possible to "parse" the above names i.e. BLUE, GREEN, WHITE, N, P, 1999 to create: 1.- variables with these names that will be added to the right of the imported "named range" area 2.- populate these variables with their names New created variables Named range BLUE GREEN WHITE N P 1999 VAR1 VAR2 ..........................VAR20 BLUE GREEN WHITE N P 1999 4555 555 566 BLUE GREEN WHITE N P 1999 4555 555 566 BLUE GREEN WHITE N P 1999 4555 555 566 ......................................................................................................................... I would like to thank you in advance Best regards Nikos

Nikos · ‎02-16-2012

Hi Ksharp, Thank you for your solution it is the answer to my problem as I initially stated. Unfortunately I mistated my problem, my question is as follows: data a; input var1 $ var2 $; cards; A . B . C . D . Z . Z ZA Z ZB Z ZC Z ZD Z ZE ; run; data b; input (l_var1 l_var2 valvar_1 valvar_2) ($); cards; A . TOT_RED RED B . TOT_GREEN GREEN C . TOT_BROWN BROWN D . TOT_YELLOW YELLOW Z ZA TOT_WHITE VIOLET Z ZB TOT_WHITE PURPLE ; run; In Data a I have single Z's while in Data b I do not. data WANT; input (var1 var2 valvar_1 valvar_2) ($); cards; A . TOT_RED RED B . TOT_GREEN GREEN C . TOT_BROWN BROWN D . TOT_YELLOW YELLOW Z . TOT_WHITE Z ZA TOT_WHITE VIOLET Z ZB TOT_WHITE PURPLE Z ZC TOT_WHITE Z ZD TOT_WHITE Z ZE TOT_WHITE ; run; Any suggestions would be more than welcomed Thank you in advance Kind regards Nikos

Nikos · ‎02-16-2012

Hi all, I have the following two datasets DATA Set 1 DATA Set 2 VAR1 VAR2 L_VAR1 L_VAR2 VALVAR A A RED B B GREEN C C BROWN D D YELLOW Z Z WHITE Z ZA Z ZA GREEN Z ZB Z ZB PURPLE Z ZC Z ZD Z ZE I want the following OUTPUT OUTPUT DATA Set 3 VAR1 VAR2 VALVAR A RED B GREEN C BROWN D YELLOW Z WHITE Z ZA GREEN Z ZB PURPLE Z ZC WHITE Z ZD WHITE Z ZE WHITE I would like to use Proc Sql with a Left Join but I had not been succesful. I would very much appreciate any suggestions Thank you Kind regards Nikos

Nikos · ‎02-09-2012

There Regions like AT that have Multiple Subregions SAT_1, SAT_2 & SAT_3 while other Regions like OM have only one Subregion SOM Thank you

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

PROC SQL different values within a BY GROUP and Calculate percentages ...

unknown variable name and conversion to numeric

How to Delete a SAS dataset based on the values of one of the same dat...

Rename an array of var names after a "Wide to Long" transpose

Rename an array of var names after a "Wide to Long" transpose

Character variables with varying number of "words" and how to parse th...

Character variables with varying number of "words" and how to parse th...

Character variables with varying number of "words" and how to parse th...

Checking condition by "looking forward in future observations"

Character variables with varying number of "words" and how to parse th...

Checking condition by "looking forward in future observations"

Parse file name and create variables out of parsing

Proc Sql Left Join - joining vars special condition

Proc Sql Left Join - joining vars special condition

Proc Sql calculating counts & percentages for groups and subgroups