Since white is white, and black is black, there is not any more questions to argue about white and black, since you are not blind obviously. Thanks anyways for your OBVIOUS contribution
... View more
You asked this question already and you have been told you need to convert your variables into a single variable.
select south as new_var from have
union all
select north as new_var from have
Then you can calculate mean, std, var, and other statistics on this new variable.
... View more
dear Ksharp
Thank you for your accurate and very incredible code.
Let me offer my apologize for not let you have the answer at first time, but you deserve all credits, i will use tour code as source to continue this programming..
You understood correctly the answer, and gave the more accurate answer.
thank you and hope to read your coding every time I'm here looking for solutions from experts, that you are.
thank you very much
... View more
Another approach, using Cartesian product, that also gives you the flexibility of using letters, example, in the order variable.
data have;
input Order ID $;
cards;
1 ROBERT
2 CARLOS
3 EDWARD
4 JHON
;
data seq;
input n;
cards;
0.0
0.1
0.2
0.3
;
proc sql;
create table Cart as
select have.*,seq.*
from have, seq;
quit;
data want;
set Cart;
retain status 'ok';
Order=order+n;
drop n;
run;
proc sort;
by Order ID;
run;
proc print;
run;
... View more
Thanks for the answeer dude, this group is really awesome to solve some puzzles. Even i work in SAS 10 years ago, i learned everythin by my self, and continue to learn Thanks one more time
... View more
If this is at all related to this thread https://communities.sas.com/t5/SAS-Programming/Convert-data-set-from-summary-to-full-data/m-p/728565 where you convert summary data into an arbitrary ordered set by categorical variables then the target set is invalid for any sort of analysis. You are creating an artificial association between the values of the question variables.
Really.
If you do not have the individual level data to start with then your entire approach is going to be so flawed I can't describe it.
There are some things that might be possible with something like Proc Mixed and similar procedures but your "created from summary to individual level data" is misrepresenting the information.
... View more
Be aware that you cannot do any meaningful analysis of combinations of the questions such as "males that answered yes to questions 1 and 2" with data from a summary like this..
... View more
If this is something that you may have to do repeatedly then perhaps reading the data with a custom informat would be a better solution than fixing afterwards.
This would assume that you would typically read the data from a text file with a data step.
proc format;
invalue invert
1 = 5
2 = 4
3 = 3
4 = 2
5 = 1
;
run;
data example;
informat x1 x2 x3 invert.;
input x1 x2 x3;
datalines;
1 2 3
4 5 1
2 3 4
5 1 2
;
... View more
Hi @jonatan_velarde By all means @Kurt_Bremser 's solution is indeed clean as it is data driven that gives you the comfort of not having to be concerned about what's in your data. However, should you know beforehand that there exists only 4 distinct lunch items in your data, i.e.
bread
soda
water
crackers
you may consider going lazy declaring an array like-
data have;
input student answers & $20.;
cards4;
1 bread; soda
2 bread; soda; water
3 water; bread
4 soda; crackers
5 crackers
6 crakers; water
;;;;
data want;
set have;
array food(*)$10 bread soda water crackers;
array t(4) $10 _temporary_ ('bread','soda','water','crackers');
do _n_=1 to dim(food);
food(_n_)=ifc(find(answers,strip(t(_n_))),'YES','NO');
end;
drop answers;
run;
... View more
data want;
set have;
call streaminit(54);
do i=1 to n;
x= rand('normal');
output;
end;
run;
proc sort data=want out=want(drop=x);
by x;
run;
Something like above?
Depending on what proc you're using, you may also consider a WEIGHT or FREQ statement.
@jonatan_velarde wrote:
Good day:
i have this data:
data have;
input gender n;
cards;
male 7
female 3;
Gender
n
Male
7
Female
3
What I need is to allocate all 10 individuals shown in the first table into a new one detailed as follows:
ID
Gender
1
Male
2
Female
3
Male
4
Male
5
Female
6
Male
7
Male
8
Female
9
Male
10
Male
The rows can be allocated randomly, it is no need to be in the orther that im presenting it.
Thanks in advance
... View more
please try
data have;
input cat disease:$100.;
cards;
1 a,b,c
2 a,b,d
3 c,d,e,f,g
;
data want;
set have(rename=(disease=_disease));
cnt=countw(_disease,',');
do i = 1 to cnt;
disease=scan(_disease,i,',');
output;
end;
run;
... View more
@andreas_lds wrote:
Please post the log as text using the window opening by clicking on the {i}-button to preserve formatting. Screenshots are best added by using the "Photos"-Icon. Attaching office-files is almost always not helpful at all, because many users won't open those files, due to security restrictions.
And word processors will invariably mangle text up to being unusable (UTF, special symbols like curly quotes etc)
... View more
