I suppose you run SAS Viya, therefore take a look at the specific action.   copied from the sas documentation:   proc cas; loadactionset "sampling"; action stratified result=r/table={name="hmeq",groupby={"bad"}} samppct=10 samppct2=20 partind="TRUE" seed=10 output={casout={name="out",replace="TRUE"}, copyvars={"job","reason","loan","value","delinq","derog"}}; run; print r.STRAFreq; run; quit;     ... View more

@ChrisHemedinger The article title looks like a question is being asked, which might be answered or not in the page. Since it is an article, it makes sense to reason that a solution is given. However, to remove any confusion, it might make sense to title a solution using a non-interrogative construct. Maybe simply by adding a colon: " How to: Import SPSS data files into SAS". This just occurred to me, feel free to ignore my ravings. 🙂 ... View more

@knargis160 wrote: Has anyone coded for Arizona Frequency questionnaire in SAS? You might mention what type of code you are looking for. As a minimum I could see 1) reading data, 2) cleaning data, 3) simple summaries. Other types of analysis would probably exist.   I would suggest contacting the agency involved. I assume this is an Arizona state sponsored activity and may be under the department of health, or if this is for school age children possibly the state education department. ... View more

Proc TRANPOSE does not support the transposition of more than one VAR into a single overall resultant BY row.   Transpose each column separately, so as to maintain original column formatting, and then MERGE.   data have; input id: date: mmddyy8. report:; format date mmddyy10.; datalines; 1 3/12/16 20 1 4/13/16 30 1 5/16/16 40 2 6/15/16 50 ; proc transpose data=have out=want_1 prefix=date_; by id; var date; run; proc transpose data=have out=want_2 prefix=report_; by id; var report; run; data want; merge want_1 want_2; by id; drop _name_; run; ... View more

HI @knargis160    You can do this to recode variables in new variables: data want; set have; array _arr(*) var1 var2 var3 /* Put the variable names */; array _new(3) ; /* Put the number of variables */ do i=1 to dim(_arr); if _arr(i)=0 then _arr(i)=2; end; drop i; run; Best, ... View more

Is it possible you have an old version of SAS.  Find was introduced with version 9.  Try Index   data x; input Ptid Education $char10.; edu_f = FIND(Education,"MD")>0; edu_i = INDEX(Education,"MD")>0; Datalines ; 1. MD,DO 2. MD 3. PHD ; proc print;run; ... View more

@knargis160 wrote:   datalines; ptid elig1 elig2    1.      0     1 2.      1     0 3.      1     1 4.       1     0 so on I want to calculate a new variable elig 3 based on elig1 and elig2  output  ptid elig1 elig2   elig3 1.      0     1        1 2.     1      0         2 3.     1        1      3 4.      1     0        2   2.      1     0        2 3.      1     1        3 4.       1     0        1 5.       1      1      3       Why not just 2*elig1 + elig2 ... View more

Thanks it worked! Do you know if I can categorize in these ID's in array statement ... View more

Thanks it worked. Can you also explain how should change the n(of whoreact[*]) if the participant should be (55-60)     ... View more

My spider sense is tingling.  It seems you might need a lot of help on this.   If you want to compute statistics (mean, std, sum) on a numeric variable. that variable has to exist in your data set.  I'm not sure from your post that it actually exists.  Perhaps your data set has a single observation per post, and you have to count those first.   Does your data set really contain variables named WEEK and GROUP?  If so, what do they represent and how do they affect what you want to count? ... View more

If you use BY statements each group is treated independently it’s just repeated for each BY group. CLASS is similar but doesn’t require the data to be presorted and will also do subgroups at the same time, if you have multiple variables defining your BY groups. Yes, you can also use WHERE to filter your data set to a single group at a time. The results of the test is the same regardless of approach. ... View more