About skjhzzang

skjhzzang · ‎05-27-2020

skjhzzang · ‎11-26-2019

@PaigeMiller What if you don't know how many variables are in the data? I mean in the datalines, there are random number of amount variables. (You don't know the maximum number of Amount Variable) Datalines above is just an example in a whole datalines

skjhzzang · ‎11-26-2019

For example below Peter 2 14 16 James 3 17 19 18 Max 1 7 Logan 5 19 15 11 9 18 … … First variable is Name, Second variable is number of visit and others are amounts. Peter visited twice so there are 2 amount variables and James visited three times so there are 3 amount variables. Is it possible to just ignore reading Amount variables and just calculate sum of amount variables for each person and running total of the total amount variables for each person in a single data step? Result should be like this. Name TotalAmt Runtotal Peter 30 30 James 54 84 Max 7 91 Logan 72 163 ... ...

skjhzzang · ‎11-25-2019

For example below Peter 2 14 16 James 3 17 19 18 Max 1 7 Logan 5 19 15 11 9 18 … … First variable is Name, Second variable is number of visit and others are amounts. Peter visited twice so there are 2 amount variables and James visited three times so there are 3 amount variables. I want to create a single data step that can read different number of variables according to a condition (# of visits). And also sum of amount variables for each person. Is it possible to just ignore reading Amount variables and just calculate sum of amount variables for each person and running total of the total amount variables for each person in a single data step? Ex.) Name TotalAmt Runtotal Peter 30 30 James 54 84 Max 7 91 Logan 72 163 ... ...

skjhzzang · ‎11-24-2019

Basically, to use Standard deviation function (STD), I know that I can use it as STD = STD(Var1, Var2, Var3); but how about if I have 100 numerical variables? In input statement, I know that it is possible to use like this, input Var1 - Var100; Then, for STD function, do I have to write all 100 variables into parenthesis?

skjhzzang · ‎11-24-2019

I created a code to read the datalines below, data STD; input Name : $5. Var1 Var2 Var3; Mean = Mean(Var1, Var2, Var3); STD1 = STD (Var1, Var2, Var3); STD = round(STD1,0.01); drop STD1; datalines; MATT 145 349 48 Susan 194 578 300 Tom 394 84 291 Jayce 394 58 279 ; run; How can I create another data set that only contains one data step to show only observations that has STD less than or equal to 150?

skjhzzang · ‎11-24-2019

@mkeintz Thanks, this seems working

skjhzzang · ‎11-24-2019

@ed_sas_member Is it possible to use only one data set to make it?

skjhzzang · ‎11-24-2019

@mkeintz yes, one header followed by 4 detailed records

skjhzzang · ‎11-24-2019

@KachiM Yes, that's what I want to see but, is it possible to use only one data set to make that?

skjhzzang · ‎11-23-2019

From datalines ABCDE 34436 23,566 2019Q1 100 2019Q3 299 2018Q1 188 2018Q3 299 MSLIFK 25250 405,405 2017Q1 102 2017Q3 244 2016Q1 135 2018Q3 243 WEFEF 23456 506,340 2016Q2 293 2017Q3 293 2017Q3 265 2018Q1 128 I only want to read the 3 Alphabet header lines, and first and third lines of detailed lines. How should I program to read those certain detailed lines? I somehow worked like this data data1; input A $1. ; if A = 'A' or A='M' or A='W' then do; if _n_^=1 then output; input Name $5. Amount Amount2 Comma6.; end; else if A='2' then do; input Year 1-4 @8 Spent; After this I have no idea how to make it work How to use only first and third row of detailed lines? Ex) For ABCDE line, 2019Q1 100 line and 2018Q1 188 line Thank you

Online Status	Offline
Date Last Visited	‎05-29-2020 06:16 AM

N-Queens Problem

Re: Calculating the Total Amount with random number of variables

Calculating the Total Amount with random number of variables

Reading certain number of variables according to a condition

Using numerous variables in STD function

Observation satisfies a condition

Re: Selecting certain row observation

Re: Selecting certain row observation

Re: Selecting certain row observation

Re: Selecting certain row observation

N-Queens Problem

Re: Calculating the Total Amount with random number of variables

Calculating the Total Amount with random number of variables

Reading certain number of variables according to a condition

Using numerous variables in STD function

Observation satisfies a condition

Re: Selecting certain row observation

Re: Selecting certain row observation

Re: Selecting certain row observation

Re: Selecting certain row observation

Selecting certain row observation