About sijansap

sijansap · ‎09-25-2017

Hi BallardW, Thank you for your quick reply and suggestion. Your suggestion will help me for X1, and whenever X1 through X5 ( in this case) have same rule to missout. With this at least I have more than half way simplified since some variables have the same rule, and some have different. When there is different rule, I will use your technique and give different names to the variables that have different rule. Thanks again, Sijansap

sijansap · ‎09-25-2017

Have data like (but over 20 variables): Input X1-X5; Cards; 20 10 31 23 42 41 32 44 02 11 22 08 34 82 05 10 45 22 09 10 ....; /*over 30,000 rows*/ Want certain values to be empty so that the output will look like: 20 31 23 42 41 32 44 11 22 08 82 26 21 45 22 09 ... I tried if X1 in ('09', '10', '11') then X1=' '; It works but I have to type 'if then' for all variables. Would there be any short way to solve the problem? Thanks in advance. Sijansap

sijansap · ‎09-22-2017

Dear BallardW, Thank you so much for your help. This format statement is much faster and easier for me to convert the data I have. I appreciate very much for your kindness and help. Sijansap

sijansap · ‎09-22-2017

Dear Experts, Got the following situation: Data Have; input D1-D10 $; Cards; 80 81 32 45 22 75 10 12 65 82 45 20 82 15 80 32 21 45 50 32 19 23 75 83 22 19 25 32 10 12 75 34; .... (about 30,000 rows) I would like to convert the above data as - anywhere if there is 80 or 81 or 83 then it is h1, similarly where ever there is 23, 32, or 34 then it is f4 etc. At the end it would all be one letter and one number like: h1 h1 f4 c2 f1 b2 a1 a1 c5 h1 c2 f2 h1 etc. I tried like: if D1 in ('80', '81', '83') then D1='h1'. Since D2 or D3 or D4 etc. will also have a value either 80 or 81 or 83 then typing for D2 (and D3 and D4 etc.) like 'if D2 in ('80', '81, '83' ) then D2='h1' and son on and so forth is very cumbersome. I am sure there are experts in the community who have better ideas to help me out by eliminating 'if ... then' statementes for each variables and all its values. Thank you. Sijansap

sijansap · ‎08-17-2017

Thanks again PGStats. I switched X1 and X2 in the inequality to preseve zeroes, and worked perfectly. I truly appreciate your help. Sijansap

sijansap · ‎08-17-2017

Thank you very much PGStats. The only problem could be - even though they are digits but they are considered as characters since some of them start like 001, 020 etc. Anyway, I like your idea of sorted CATT and the comparing the values between X1 and X2. I certainly appreciate your suggestion and will try it out. Thanks again.

sijansap · ‎08-16-2017

Dear expert, I got an uneasy task. I have two columns of data say X1 and X2 each in 3 digits but assigned as characters. Each column has over 6000 rows. I need to physically combine X1 and X2 and make them six digits. First X1 with X2 and then X2 with X1. I could do that by CATT function, and the product is like X12 and X21. This is how it becomes: X1 X2 X12 X21 361 362 361362 362361 845 846 845846 846845 846 845 846845 845846 845 846 845846 846845 ...... Now the problem is, I need to count X12 or X21 in such a way that 845846 and 846845 are considerd exactly same. So in the above example, the entry 845846 should count 3 not 2 or 1. PROC FREQ for X12 or X21 would count only 2 or 1 respectively. I tried defining like: if X12=845846 and X21=846845 then X21=X12; it works with PROC FREQ of X21, but to write for each of the 6000 entries is almost impossible, if not impossible. I would be very grateful if any kind soul can help me out with an better easier solution. Thank you, Sijansap

sijansap · ‎05-03-2017

Thank you for your time BallardW. I used the codes suggested by Darycut and it worked for me. ThanKs anyway.

sijansap · ‎05-03-2017

Thank you so much dear Draycut. I used & missing(X2) & missing(X3) & .... I worked perfectly. Thanks again and I appreciate your help very much.

sijansap · ‎05-03-2017

Dear SAS community, I got the following problem on data manipulation. I would appreciate very much for you kind help. Thank you. data HAVE; input X1 X2 X3 X4; DX1-X20=Substr(X1-X20, 1, 3); /*All input values are charecters, and I have over 300k rows with 20 columns, there are no data after certain column in each row*/ cards; 360 361 290 3321 360 400 4021 405 225 112 227 865 342 360 443 361 360 870 360 360 run; I WANT: if 360 is in first column, and there are no other input in any other column in the same row then count is one otherwise zero. So in the above data, for 360 I want count=1 from second row and count=1 each from last two rows rest zeros. Similarly for 225 I should get count=1 only from 4th row, etc. I would appreciate very for your kindly help.

sijansap · ‎05-02-2017

Chris, Sorry to bother you. I got another similar problem which you helped in March. May be this you can help me for this one also. The problom is: data HAVE; length X1-X20 $3; input X1 X2 X3 X4; /*All input values are charecters, and I have over 300k rows with 20 columns, there are no data after certain column in each row*/ cards; 360 361 290 332 360 400 401 405 225 112 227 865 342 360 443 361 360 870 360 360 run; I WANT: if 360 in first column first row, and there are no other input in any other column in the same row then count is one else blank. So in the above data, for 360 I want count=1 from second row and count=1 each from last two rows. Similarly for 225 I should get count=1 only from 4th row, etc. I would appreciate very for your kindly help. Thanks. -Sijan Sapkota

sijansap · ‎03-16-2017

Thank you again ChrisNZ. I did a small modification and it worked perfectly. Following is my modification: data HAVE; length X1-X20 $3; input X1 X2 X3 X4; cards; 360 361 290 332 360 400 401 375 400 401 405 229 225 120 228 360 112 227 865 342 360 345 443 361 360 231 361 870 run; 　 data WANT; set HAVE end=LASTOBS; if X1='360' and whichc('361',of X2-X20) then N=1; else N=0; if LASTOBS then putlog N=; run; Quit;

sijansap · ‎03-16-2017

Thank you so much ChrisNZ. Your suggestion almost works. I think, I did not explain too well. Let me describe just like you did: HAVE (all in digital characters of length 3) X1 X2 X3 X4 360 361 225 390 360 400 332 423 400 401 360 361 360 210 562 361 225 329 250 662 WANT (added C1 as number either 1 or 0) X1 X2 X3 X4 C1 360 361 225 390 1 (because '360' is in 1st column and '361' in second column of the same 1st row) 360 400 332 423 0 (because even '360' is in 1st column there is no '361' in any other column on the 2nd row) 400 401 360 361 0 (because '360' is not in the 1st column, even though they are in 3rd and 4th columns) 360 210 562 361 1 (becasuse '360' is in the 1st column and '361' in the 4th column) 225 329 250 662 0 (because neither '360' is in the 1st column nor '361' in any other columns) In other words, '360' has to be in the first column and '361' can be in any other column in the same row to count 1, otherwise count is 0. When I ran the codes you suggested it counts 1 for every row entry like this: Obs X1 …. X5 …. X20 N 1 360 361 1 2 360 400 1 3 400 401 1 Any suggestions?

sijansap · ‎03-15-2017

I have about 20 columns of data say X1 through X20 and each column has millions of rows. The data in each cell (column and row) are in character codes like '360' meaning certain kind of disease, similarly '361' etc. etc. I want to see if there is say '360' in column X1 in 1st row and '361' in any of the remaining X2 or X3 or upto X20 columns on the same 1st row then count=1 if not the count=0. Similarly say if the same '360' in 2nd row of column X1 and '361' in any of the other remaining 19 columns on the same 2nd row then count=1 if not then count=0 and so on. Finally, I want to sum all the counts that are 1. I would appreciate very much, if any kind soul out there would be able to help me in writing SAS codes to solve my problem. Thank you very much in advance.

sijansap · ‎04-10-2016

Thanks. I will give a try keeping just two columns.

Online Status	Offline
Date Last Visited	‎08-12-2020 01:45 PM

Re: Data manipulation: How do I select row values

Re: Data manipulation: How do I select row values

Data manipulation: How do I select row values

Re: data managing

Re: data managing

data managing

Re: data merging

Re: data merging

data merging

Re: Data Manipulating Sorting

Re: data managing

Re: data merging

Re: data merging

Re: Data Manipulating Sorting

Re: Data Manipulate

Re: data managing

Re: Data Manage

Efficiently recode values to missing

Re: Data Manage

Data Manage

Re: Data manage

Re: Data manage

Data manage

Re: Data managing

Re: Data managing

Data managing

Re: Data management

Re: Data management

Re: Data management

Data management

Re: Data management