About hhchenfx

hhchenfx · ‎03-01-2014

oh I got it. data one; input old $20. ; datalines; change1 && && face change2 && && askljklj change3 dfa xlx & ) run; data two; set one; new = prxchange('s/&& &&/&&/', 1, old); new2 = prxchange('s/& \)/kkk/', 1, old); run;

hhchenfx · ‎03-01-2014

Hello Everyone, I am using prxchange to replace text. I can replace the string '&& &&' but can not do with '&& )'. Can you show me how to fix it? Many thank and have a nice weekend. HHC data have; input old $20. ; datalines; change1 && && face change2 && && askljklj change3 dfa xlx && ) nochange && ) ; run; data want; set have; new = prxchange('s/&& &&/&&/', 1, old); new2 = prxchange('s/& )/)/', 1, old); run;

hhchenfx · ‎02-01-2014

Thanks, Tom, for clear explanation. HHC

hhchenfx · ‎01-31-2014

Thank you, Cynthia. Actually, I tried Method 1 before but instead, I put the Length after Input and it does not work. That's weird. Everything is good now. Thank you again. HHC

hhchenfx · ‎01-31-2014

Hello Everyone, I have problem reading the following character variables with varies length. data cond1; input name $ value; datalines; december_12_2013 -1 medium_length -1 short 3 ;;run; I try to use format name $30. but it read the value as part of the character. Please help me with that one. Thank you and have a nice weekend. HHC

hhchenfx · ‎01-29-2014

Hi Data_null, Is there any quick change to your code if I want to change from "AND" to "OR" in my argument below? Thank you, HHC If a1=1 how many observations have target=0 and how many have target=1. If a1=1 OR a2=9, how many observations .... If a1=1 OR a2=9 OR a3=1 how many observations .... ... If a1=1 OR a2=9 OR a3=1 OR a4=0 OR a5=8 OR a6=1 .... If a1=2 how many observations ...

hhchenfx · ‎01-29-2014

Yes, it is, Data_null. My intention is like that: Get a subset of data by using the IF section, then work on that subset, export the result and go back to IF and work on another condition. So your code is enable me to (1) got the Frequency and (2) got the list of all combination so that I can do the iteration for deeper analysis with each subsample. Thank you. HHC

hhchenfx · ‎01-28-2014

Hi Everyone, I have a dataset with a variable name target (taking value 0 or 1) and n independent variables. I want to create a summary file that reports number of target=0 and number of target =1 for each combination of independent value. data have; input target a1 a2 a3 a4 a5 a6; datalines; 0 1 9 1 0 8 1 1 1 0 1 1 5 0 1 1 9 2 3 1 1 1 2 3 0 2 0 6 0 2 9 1 7 0 0 0 3 3 0 9 0 3 1 2 1 1 2 1 2 0 1 2 0 3 0 4 ;run; Basically the summary will include All possible combination (from 1 factor to 6 factor from the 6 independent variables) such as: If a1=1 how many observations have target=0 and how many have target=1. If a1=1 and a2=9, how many observations .... If a1=1 and a2=9 and a3=1 how many observations .... ... If a1=1 and a2=9 and a3=1 and a4=0 and a5=8 and a6=1 .... If a1=2 how many observations ... ... ... I don't know how to do it so any help is very much appreciated. I am thinking about creating a condition file that summary distinct values for each independent variable and then run some kind of Do Loop to create the file I want. The code for distinct value is as below just in case you might need. Thank you for your help as always. HHC proc summary data=have missing chartype; class a:; ways 1; output out=distinct(drop=_type_ _freq_) / levels; run; proc print; run; proc sort data=distinct; by _level_; run; data condition; update distinct(obs=0) distinct; by _level_; run;

hhchenfx · ‎01-28-2014

Thank you, Peter and Data_null_. Lesson learned. HHC

hhchenfx · ‎01-28-2014

Thank you so much, Data_null !!! One quick question since you are here. If the name of variables shares nothing in common, say a1, f4, var1, date... I cannot use the "class a: ;" . What should we put after "class" so that SAS conduct the proc summary for all variables on the file? Thank you again, HHC

hhchenfx · ‎01-28-2014

Hi Everyone, I have a dataset with n variables. I want to create a summary file of distinct/unique values for each variables. data have; input a0 a1 a2 a3 a4 a5 a6; datalines; 0 5 9 1 0 8 1 1 4 0 1 0 5 0 1 8 0 1 0 1 1 ; as you see, a0 only take value 0 or 1; a1 values are 5 4 8; a2 values are 9 and 0; a3 take only value 1... The output file should be: a0 a1 a2 a3 a4 ... 1 5 9 1 0... 0 4 0 8 I wonder if there is any simple way to get it done. Right now I can only do it through sort nondupkey one by one and merge, which is not efficient. Thank you so much for your help. HHC

hhchenfx · ‎12-05-2013

Thank you for your help, Arthur. The reason I did it is that there are about 100 condition and I dont want to manually count the position to put in DO statement. HHC

hhchenfx · ‎12-05-2013

Thanks, Arthur. I follow your approach and eventually, I make a transpose dataset to record the filter. So I can just do i=1 to N. By the way, I am not clear how SAS read " if _n_ eq 1 then set filter" vs "set filter". Could you tell me why? Many thanks. HHC data originial; input id f1 f2 f3 f4 ; datalines; 1 0 1 2 99 2 0 1 4 6 3 0 8 6 7 4 1 3 6 8 5 9 9 9 9 ; data filter; input f1 f2; datalines; 0 1 ; data ff; set originial; if first.id; run; data ff; set ff filter; drop id;run; proc transpose data=ff out=f3;run; data f3; set f3; drop _name_; proc transpose data=f3 out=f4;run; data f4; set f4;drop _name_;run; *-----------------------------------------------------------; data want; if _n_ eq 1 then set f4; number=0; array fil{4} col1-col4; set originial; array ori{4} f1 f2 f3 f4; test=0; do I=1 to 4; if fil{i} eq (ori{i}) then NUMBER=NUMBER+1; end; run; *-----------------------------------------------------------;

hhchenfx · ‎12-04-2013

Thank you, Arthur for your help. I am still trying to follow your code. For the second record, as f1=0, f2=1 and f4=6 and filter is f1=0, f2=1 and f4=4 , only 2 condition met and number should be 2. I think in IF statement, we still need condition of Name variable = Name variable vname(ori{i})=vname(fil{j} HHC

hhchenfx · ‎12-04-2013

Hello Everyone, I have the following problem and cannot fully solve. Please help me if you could. I have 2 data set: (a) original with f1-f4 variables with many records and (b) filter which show 1 condition/value for f1 f2 f4 I want to create a new column "number" in the original file to count the number of time a given variable in original data has the same value as stated in filter file. For the below example, the first record should has "number"= 3 as f1 f2 f4 match value in filter. second record should has "number"=2 (f1 f2) third record should has "number"=1 (f1). I try to write a code but somehow the output file only has 1 record. Please help me with my code or create a new one. Thank you very much. HHC data originial; input id f1 f2 f3 f4 ; datalines; 1 0 1 2 4 2 0 1 4 6 3 0 8 6 9 4 1 3 6 8 5 8 6 5 3 ; data filter; input f1 f2 f4; datalines; 0 1 4 ; data want; set originial; array ori{4} f1 f2 f3 f4; number=0; set filter ; array fil{3} f1 f2 f4; do i=1 to 4; do j=1 to 3; if vname(ori{i})=vname(fil{j}) and ori{i}=fil{j} then do; number=number+1;end; end; end; run;

Online Status	Offline
Date Last Visited	‎06-11-2025 01:48 PM

Re: Help with Do Loop return incorrect result

Help with Do Loop return incorrect result

Re: Running time issue

Running time issue

Transpose multiple columns Long to Wide

Re: SAS Error Unable to sample external file, no data in first 5 recor...

SAS Error Unable to sample external file, no data in first 5 records

Get the highest value within a window

Issue with WORK.PROFILE will be opened instead

import specific sheet of an xlsx file into SAS

Re: Running time issue

Re: SAS Error Unable to sample external file, no data in first 5 recor...

Re: Get the highest value within a window

Re: Get the highest value within a window

Re: Get the highest value within a window

Where to download SAS 9.4

Go to the end of a Macro loop when condition met

Re: Go to the end of a Macro loop when condition met

Re: Run code when minutes is 0,5,10...

Re: Running code when time between certain window

Re: Help with replace text

Help with replace text

Re: Help with inputting character variables with different lengths

Re: Help with inputting character variables with different lengths

Help with inputting character variables with different lengths

Re: Summary of statistics for ALL Combination from a set of variables

Re: Summary of statistics for ALL Combination from a set of variables

Summary of statistics for ALL Combination from a set of variables

Re: Help with create a summary of distinct value for each variable

Re: Help with create a summary of distinct value for each variable

Help with create a summary of distinct value for each variable

Re: Counting number of condition met

Re: Counting number of condition met

Re: Counting number of condition met

Counting number of condition met