About Barney1998

Barney1998 · ‎04-17-2024

Thanks for answering! Definitely, this article does not solve my problem. The question was if can procced via PCA as I told above. Burney

Barney1998 · ‎04-17-2024

Good morning everyone, I need to analyze a questionnaire, essentially revisiting a study after some years. My issue is that all variables are on a Likert scale. The categories from which I need to draw conclusions have been predefined. By that, I mean I've been told that certain questions correspond to a person's value, others to their knowledge, etc. The purpose of the research is to examine how subpopulations I have—such as men/women, smokers/non-smokers—differ. Initially, I thought of conducting an explanatory factor analysis to get scores for these categories, but I couldn't get the desired categories the way I wanted. So, I thought of doing the following: Is it correct to conduct PCA separately for both categories to obtain the desired scores and proceed with the analysis? Thank you very much for your time.

Barney1998 · ‎03-24-2024

Good morning everyone! I would like to ask you, I have a sample of 200 people. This sample contains several categorical variables and 3 continuous variables. I would like to see if there is a statistically significant difference in my continuous variables by categorical variable. The problem is that none of my three continuous variables follow the normal distribution. What can I do? P.S Some of my categorical variables have more than 6 levels. Thank you ! Have a nice day!

Barney1998 · ‎10-25-2023

Initially, I have separated each answer into each column (scan). Unfortunately, the method you suggested only works in the case where the candidate answers with up to 2 of the possible choices.

Barney1998 · ‎10-24-2023

I'm trying to explain that a person can provide up to 3 answers they have selected from the possible options. Let's say the list is the one I mentioned earlier: Smoking Drinking water Alcohol no physical exercise Someone can respond: Smoking Someone can respond: Drinking water Someone can respond: Drinking water, Alcohol While someone else may respond: Alcohol, Drinking water The problem is that I can count how many times "Drinking water" (or any other choice) appeared, but I can't analyze the combinations that arise in the responses because "Alcohol, Drinking water" is considered a different answer from "Drinking water, Alcohol." So, I would like to see how I can make the code understand that "Alcohol, Drinking water" is the same as "Drinking water, Alcohol." In other words, based on the example I provided earlier, I want to have response frequencies like this: No Smoking 1 Drinking water 1 Drinking water, Alcohol 2

Barney1998 · ‎10-24-2023

Ι have a data set which contains the options for the question (the possible answers for the question ) for example : Healthy life data: No Smoking Drinking water Alcohol no physical exercise ... And the respondent could have chosen until 3 answers in order to specify the factors that they believe have an impact in healthy lifestyle. But if a respondent answer to this question like this No Smoking Alcohol no physical exercise And the one other like this: no physical exercise Alcohol No Smoking Particularly, they are the same answers but code recognizes them as different. That i want to achieve, that is No Smoking Alcohol no physical exercise to be taken into account as the same answer as no physical exercise Alcohol No Smoking.

Barney1998 · ‎10-23-2023

Hello, I would like you to help me with a question. I have a questionnaire, and I would like to determine the most probable answer to a question. The issue is that this answer consists of up to 3 choices from 3 different columns of another table. Since there is no specific order, when I try to apply "proc freq" as "variable1 * variable2 * variable3," it recognizes different combinations of answers as distinct, such as "mental health, no smoke, drinking water" and "mental health, drinking water, no smoke." Is there a way for the combinations it generates to take into account the similarity of such answers?

Barney1998 · ‎06-06-2023

Hallo to everyone. I have this problem. I have a big data set so this i will try to explain you it was difficult to be implemented by hand. First of all i have one data set which looks like: qq1 qq2 qq3 qq4 1 0 0 2 11 i want to pick up all the variables in one new column like qq 1 0 0 2 11 from the first table if one column value is not missing means that all the other columns are missing in the same row thank you in advance

Barney1998 · ‎06-01-2023

Thank you so much!

Barney1998 · ‎05-31-2023

Hallo to everyone, I have this problem to overcome. I have a data set which their information from some columns are repeated. For example like: DATA Input; INPUT Col1 $ Col2 $ Col3 $ Col4 $ Col5 $ Col6 $ Col7; DATALINES; A X X S F 1 10 A X X S F 2 20 A X X S F 3 30 B Y R S Z 1 20 B Y R S Z 2 40 ; RUN; and i want to hold all the info in one row like DATA Input; INPUT Col1 $ Col2 $ Col3 $ Col4 $ 1 $ 2 $ 3; DATALINES; A X X S F 10 20 30 B Y R S Z 20 30 - RUN; what should i do?

Barney1998 · ‎12-01-2022

Dear all, I wish someone know the answer in this problem. I want to check one report which comes from microstrategy software. (I don't know if you have experience on this) .The problem is SAS and microstrategy have different ways to calculate percentiles . I know how each other make its calculation but I wondering if someone knows if exist more easy way as option in proc summary . thank you, Best wishes!

Barney1998 · ‎09-06-2022

thank you so much!

Barney1998 · ‎09-06-2022

Hi all, I need your help for the below problem. I have 2 data sets.For example data1 and data2.The data1 data set has codes like : data1: code1 code2 code3 code4 code5 and the data 2 data set has combinations of the above codes like: code2code5 code1code5code4 etc. My question is exist some way to create one new column in data2 data set which it contains how many codes from the data1 appear in each row of data2? Thank you in advance, Burney 1998.

Barney1998 · ‎07-20-2022

Hallo to everyone, Could someone help me with this? I have one really big data set ,and from this I wanna to create one new .After the where statement I keep only the observation that are really needed. The problem is ,i want this observations and their exactly next.For example if from the where statement I keep the observations 1 ,100,and 1000 in the new data set i will have the observations 1,2(1+1),100,101(100+1),1000,1001(1000+1). Thanks in advance, Barney

Barney1998 · ‎07-06-2022

Hallo to everyone, I have one problem with below procedure! I have one table A with one column a and one table B with one column b ,the column a from the A is substring from the column b from the B.I wanna to joint that tables .As result i want one table which have only the rows from the B which contain some column from table A as substtring. I have one really big data set and i dont have the ability to check case by case .With other words i looking for one type of order like:the where variable from data statement where A.variable like ''B.variable2''; Thanks in advance, Barney

Online Status	Offline
Date Last Visited	‎04-17-2024 03:59 AM

Re: Questionnaire Analysis with Likert Scale: Using PCA to Assess Diff...

Questionnaire Analysis with Likert Scale: Using PCA to Assess Differen...

Compare means

Re: Proc freq

Re: Proc freq

Re: Proc freq

Proc freq

pick up variables in one column

Re: Transpose

Transpose

Re: compute how many strings of one data set exist in one character va...

Re: compute how many strings of one data set exist in one character va...

Re: Questionnaire Analysis with Likert Scale: Using PCA to Assess Diff...

Questionnaire Analysis with Likert Scale: Using PCA to Assess Differen...

Compare means

Re: Proc freq

Re: Proc freq

Re: Proc freq

Proc freq

pick up variables in one column

Re: Transpose

Transpose

MicroStrategy vs SAS percentiles.

Re: compute how many strings of one data set exist in one character va...

compute how many strings of one data set exist in one character variab...

keep specific obs and its next

Join two tables if the string col from one is substring from the other...