About anming

anming · ‎01-13-2021

does the book also provide the answers/solutions?

anming · ‎01-11-2021

is this what you want? data dave; set have; daydiff=intck('day',dx_date,enc_date); if abs(daydiff) le 15 then enc_want=1; else if abs(daydiff) gt 15 and abs(daydiff) le 30 then enc_want=1; run; or does this one address what you need? proc sql; create table close1 as select * from dave where abs(daydiff) le 15; create table close2 as select * from dave where abs(daydiff) gt 15 and abs(daydiff) le 30; quit;

anming · ‎01-06-2021

char3=input(char1, $4.); num4=input(char2, dollar10.2); char5=put(age, 4.); the question is how to define 'informat' and 'format'' in these converts. According to the definition of 'informat' (tells SAS how to read the variables) all of these formats '$4., dollar 10.2 and 4.' are informats. Then how to understand 'format' in your words: A FORMAT translates values to text. To convert from numbers to text you must use a FORMAT. To convert from text to text you can use either. what are details/principles of 'input'/'put' in terms of 'format/informat'?

anming · ‎01-06-2021

'input' can return a character variable if both the input variable and format are characters. But a 'put' always returns a character. See codes below: data two; age=40; char1='10'; char2='$1,000.00'; char3=input(char1, $4.); num4=input(char2, dollar10.2); char5=put(age, 4.); run;

anming · ‎01-04-2021

For an external file employee.txt like: susan*12/29/1970*10 micheal**6 data employee; infile "/special path/employee.txt" dlm='*' dsd; input employee $ bdate: mmddyy10. years; run; both dlm and dsd are needed for proper input. However, there is no comma in the input data but only two stars for a missed value. Why is a dsd required? I read a few documents and posters. It seems it is still confused.

anming · ‎01-02-2021

Note that you type 'jobacategory' instead of 'jobcategory'. If jobcategory it is strange that the code still outputs only 'FA'. data staff; length jobcategory $3 joblevel $1 ; jobcategory='FA'; joblevel='4'; jobcategory=jobcategory||joblevel; run;

anming · ‎01-01-2021

data staff; jobcategory='FA'; joblevel='4'; jobacategory=jobcategory||joblevel; run; for the code to concatenate two strings jobcategory only outputs 'FA'. if change the code to jobcategory1=jobcategory||joblevel, jobcategory1 will be assigned to 'FA4'. Why can not assign a new value to the variable of jobcategory through the code above?

anming · ‎12-31-2020

yes. I am trying to provide an alternative solution.

anming · ‎12-31-2020

data have; input Date date9. Event $; format date date9.; cards; 01JAN2020 event1 01JAN2020 event1 01JAN2020 event1 01JAN2020 event1 02JAN2020 . 02JAN2020 . ; run; proc freq data=have ; tables date/out=test1; /* output _counts_; */ run; data want1; set test1 (drop=percent); run; data want2; set have; set want1; run; try this.

anming · ‎12-30-2020

This is a pretty old practical question. The question is "what is written to the output raw data file?". The suggested answer is the results 'put' statement generated in the log file. This confuses me. After checking all discussions I do not think this question is well designed. Now I have a better understanding!

anming · ‎12-30-2020

I see. These are the output in the log, which are not written to the output dataset.

anming · ‎12-30-2020

there is nothing strange in the log file. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 data student; 74 set perm_student; 75 put name $15. @5 age 2.; 76 run; afre14 alic13 barb13a caro14 NOTE: There were 4 observations read from the data set WORK.PERM_STUDENT. NOTE: The data set WORK.STUDENT has 4 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 77 78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 91

anming · ‎12-30-2020

I do not challenge it will work. But I need to figure out what is wrong with my code.

anming · ‎12-30-2020

indeed the overwriting will display that 'put' works. currently, it does not overwrite the name. I also try to input ina formatted column input. data perm_student; input @1 name $7. @9 age 2. ; cards; afred 14 alice 13 barbara 13 carol 14 ; run;

anming · ‎12-30-2020

data perm_student; input name$ age 2.; cards; afred 14 alice 13 barbara 13 carol 14 ; run; data student; set perm_student; put name $15. @5 age 2.; run; it looks that 'put' does not work. The student dataset is only a simple copy of perm_student. could you help what is wrong?

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: 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: put statement

Re: put statement

Re: put statement

Re: put statement

put statement