About znhnm

znhnm · ‎02-09-2023

Hi, I thank you. I provided a sample dataset on the under the other comment. I don't know how to provide an example desired output.

znhnm · ‎02-09-2023

Hi, thanks for the reply. A similar dataset looks like this: data example; do bin = 1 to 3; number_of_items = round(rand('uniform')*100); output; end; I want a 3rd column to calculate the percentages. run;

znhnm · ‎02-09-2023

Hi, I have a column in my dataset called number_of_items. I want to calculated the percentages of the items. e.g. 100 * (first record of number_of_items) / sum of number_of_items. How do I do this calculation? Thank you!

znhnm · ‎02-09-2023

I have a column called "score" in my SAS dataset. Each "score" has two records with for c_flag=1 and c_flag=0. When c_flag=1 the "event" column has a value but "nonevent" column is missing. When c_flag=0 the "nonevent" column has a value but "event" column is missing. I want to create another dataset that will list the uniq values of "score" and write the nonmissing event and nonevent values. How do I write this code?

znhnm · ‎02-03-2023

Hi, I am using a visual logistic regression model in VA. When the model is built, I have "Observations: 1215 of 10675" statement. When I apply a filter in the dataset, the statement changes to be "Observations: 1215 of 5475". Then, I update the filter and now I have "Observations: 924 of 2767". My questions are: What does this "Observations: XXX of YYY" mean? Why there is a drop in the number of observations when I apply a filter?

znhnm · ‎01-19-2023

Can we download the results of the attribution analysis as a dateset?

znhnm · ‎12-30-2022

Hi, sure! This should create a similar structure data I have. I edited my question so that the column names in the question and in the code are consistent. data dataset; do i = 1 to 10; reference_month = int(12*ranuni(123)); Jul21 = int(100*ranuni(123)); Aug21 = int(100*ranuni(123)); Sep21 = int(100*ranuni(123)); Oct21 = int(100*ranuni(123)); Nov21 = int(100*ranuni(123)); Dec21 = int(100*ranuni(123)); Jan22 = int(100*ranuni(123)); Feb22 = int(100*ranuni(123)); Mar22 = int(100*ranuni(123)); May22 = int(100*ranuni(123)); Apr22 = int(100*ranuni(123)); Jun22 = int(100*ranuni(123)); Jul22 = int(100*ranuni(123)); Aug22 = int(100*ranuni(123)); Sep22 = int(100*ranuni(123)); Oct22 = int(100*ranuni(123)); Nov22 = int(100*ranuni(123)); Dec22 = int(100*ranuni(123)); output; end; run;

znhnm · ‎12-30-2022

Hi, they are the actual column names. For example, column "01-22" referring to the first month of 2022...

znhnm · ‎12-30-2022

I have a SAS datasets. I have 18 month columns: Jul21 Aug21 Sep21 Oct21 Nov21 Dec21 Jan22 Feb22 Mar22 May22 Apr22 Jun22 Jul22 Aug22 Sep22 Oct22 Nov22 Dec22 Each of them has values between 1-100 for each record. I also have a reference_month column which has month values in numbers between 1 to 12. I want to create 7 new columns score0 to score6. For example score0, score1, etc... They will get their values between the column's values starting from Jan22 to Dec22, depending on the reference_month. For example, If reference_month is 1, score0 column will take the value of Jan22 column. If reference_month is 2, score0 column will take the value of Feb22 column. If reference_month is 3, score0 column will take the value of Mar22 column. ... If reference_month is 12, score0 column will take the value of Dec22 column. Then the other 6 score columns (score1, score2, ..., score6) will take he value of the previous month's. For example, If reference_month is 1, score1 column will take the value of Dec21 column score2 column will take the value of Nov21 column score3 column will take the value of Oct21 column score4 column will take the value of Sep21 column score5 column will take the value of Aug21 column score6 column will take the value of Jul21 column How can I do this? Thank you!

znhnm · ‎12-30-2022

Thanks lot for this! I was trying to find a solution to have it on both number on 3-letter format. I have it both with your way which is amazing.

znhnm · ‎12-30-2022

It helped a lot, thank you!

znhnm · ‎12-30-2022

Hi, thank you. It's Num 8 type DATETTIME. format.

znhnm · ‎12-29-2022

I have a time type columnç One example record is: 03JUN22:00:00:00. How can I get the month part of it, JUN? Thank you!

znhnm · ‎12-28-2022

Hi, I uploaded a CSV file to SAS Studio, but this file has a column name with blank between two words. It causes problems when writing code referring to this variable. Is there a way to rename the variable to remove the blank so that I can refer to this column in my code? Thnak you!

znhnm · ‎12-28-2022

Hi, thank you so much for the suggestion. I tries it both and I have zero observations in the output dataset. I think it means I don't have characters in my data that I can't see or a leading character, right? Please let me know if you'd have any other suggestions.

Online Status	Online
Date Last Visited	7 hours ago

Modelling in VA vs Model Studio

VA Text Topics: No data items in the active data can be set as unique ...

Re: Train Test Split in VA Models

Train Test Split in VA Models

the analytic requires a categorical response variable with at least tw...

Oversamling in Models in VA Interface

Re: -1 cluster node

-1 cluster node

change the name of a button of stacking container in VA

Automated Explanation - Action Taken

Re: -1 cluster node

Re: Page Controls - Action Diagram

Re: Categorical (DateTime) Format to Date Format

Juletip #14 - Export the score code from your VA model and use it in S...

Re: Generating a Unique Identifier from VA

Re: percetanges od a column

Re: percetanges od a column

percetanges od a column

two records to a single record

Number of Observations in Logistic Regression in VA

attribution analysis results

Re: the values of the previous column

Re: the values of the previous column

the values of the previous column

Re: month of time

Re: month of time

Re: month of time

month of time

Blanks in column name

Re: sorting char id