About anming

anming · ‎12-29-2020

For an inner join of two data sets "on" clause is used and two data sets are listed with "inner join" but for 'where' two data sets are separated by a comma.

anming · ‎12-23-2020

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lestmtsref&docsetTarget=n0oaql83drile0n141pdacojq97s.htm&locale=en#p10kxp5ghaqig7n1qcmwle2swfox '@n' is the column point controls. '+m' means to shift m positions to the right.

anming · ‎12-22-2020

it works from without, +0 to +3. but from +4 the last name will be truncated.

anming · ‎12-22-2020

data list_modified; input name $ & +3 lastname & $16. team $; datalines; Joseph Joergensen White Red Mitchel Mc Allister blue Su Ellen Fischer Simon green ; run; what does '+3' mean? without '+' only letter at position 3 is loaded for the name.

anming · ‎12-22-2020

data work.retail; cost = (20000); total = .10 * cost; run; to assign a value to cost, 20000 or (20000) both work. "20000" or '20000' also work but a log note shows that a char is changed to a numeric value.

anming · ‎12-22-2020

I have a txt file test1.txt: 36 95 (with one space between) and try to load to SAS table through the following codes: data test2; infile "/folders/myfolders/test1.txt"; input @1 height 2. @4 weight 2.; run; but if I miss period in the second format @4 weight 2; the test2 will be 36 2. if change to @4 weight 1, test2 will be 36 7. Looks the result is not expected. Anyway, this is a wrong code.

anming · ‎12-20-2020

please share your linkages if you know. the practice makes better!

anming · ‎12-20-2020

any other websites? please share the linkage. The more practice the better!

anming · ‎12-20-2020

anyone knows other websites, please share!

anming · ‎12-20-2020

please try this website for some useful exercises. I just found. examtopics.com

anming · ‎12-20-2020

this is a useful website providing some exercises: examtopics.com

anming · ‎12-20-2020

the similar omissions can be found in the following cases; proc sort data = scoredata_p; by stu_id; run; proc sort data = scoredata; by stu_id; run; data MMA; merge scoredata_p(in = A) scoredata (in = B); by stu_id; if A and B; run; in selected variable merge (stu_id), you can omit A=1 and B=1 in 'if' statement.

anming · ‎12-20-2020

data result.output36; set result.cleandata36; if 40 <= kilograms le 200 then kilograms=kilograms; else if group ='A' then kilograms=79; else if group ="B" then kilograms=89; run; alternatively, you can code like above. 'then' for one action, 'do' for multiple actions and finish with 'end'.

anming · ‎12-20-2020

hyphen and colon can effectively express a range, such as input name $1-6 /*6 positions for a name array score (4) score1-score4; var1=sum(of col2-col11, of col13-col30); sheet="name-class $A2:C6" /*a data range of the excel sheet of class 'A' - 'F'; letters range from A to F 'A-F' a string of three characters. Any other cases?

anming · ‎12-19-2020

colon means "begin with " in the wild card, such as, data ABCD; set EF: ; /* a dataset name stats with EF, like EF11. Drop TEMP: ; to drop any variables starting with TEMP. Total = sum (of var:); all variables with "var" in the name. Arry col(*) col: ; Anything else?

Online Status	Offline
Date Last Visited	‎01-22-2021 01:07 PM

Re: practice questions

Re: Help with pulling data from encounter based on date diference

Re: use input and put functions to convert the type of variables

use input and put functions to convert the type of variables

use dlm and dsd

Re: simple concatenation

simple concatenation

Re: Make a new column with frequency/count

Re: Make a new column with frequency/count

Re: put statement

Re: practice questions

Re: use input and put functions to convert the type of variables

Re: use dlm and dsd

Re: use dlm and dsd

Re: simple concatenation

sample question no.10

Re: Upcase(group) in ('A','B')

free practice questions for SAS base

Re: If and else

Re: My SAS studio stopped working

Re: SAS SQL on/where clauses

Re: modified list input

Re: modified list input

modified list input

assign a value

unexpected formatted input

Re: practice questions-free!!!

Re: free practice question

Re: free practice questions for SAS base

free practice questions for SAS base

free practice question

Re: Upcase(group) in ('A','B')

Re: If and else

range with hyphen and colon

colon wildcard