About Bal23

Bal23 · ‎07-18-2016

you are right, i found this problem and fixed it thanks

Reeza · ‎07-13-2016

Are your variables character or numeric? Are they all the same type? Post an example of what your data looks like and what you want as an output. I think you want an array, assign the variables to the array and then loop through and create variables that flag if they're missing. Also, what isyour end goal with flagging these as missing? There may be another way to get it.

ballardw · ‎07-13-2016

You don't say if you want to remove 0 if there is only one leading zero. If that is the case then one way is if index(v1,'0')=1 then v2= substr(v1,2); if ony replace the first zero when you have 2 leading zeroes or more then if index(v1,'00')=1 then v2= substr(v1,2);

Reeza · ‎07-11-2016

Rick Wicklins blog http://blogs.sas.com/content/iml/2016/02/22/create-dummy-variables-in-sas.html SAS UCLA http://www.ats.ucla.edu/stat/sas/faq/dumvars.htm My post - on here ... https://communities.sas.com/t5/SAS-Statistical-Procedures/How-to-create-dummy-variables-Categorical-Variables/m-p/258702 Last, but not least, several proc support the CLASS statement where SAS will deal with creating the dummy variables. Some Procs allow you to specify the reference level and parameterization type, but others don't so make sure to read the docs for the proc you're using.

Reeza · ‎07-08-2016

You realize that's a 20+ year old webpage? 1995? I can't find a single SAS reference to it anywhere, including Lexjansen.com which goes back a long way. Regardless, you can get what you want out of proc REG. If if you want help with proc stepwise contact support@sas.com. I'd be interested in their response.

Bal23 · ‎07-07-2016

proc transpose data=toprint out=transp; by unique _obs_; id _type_; run; proc print data=transp(where=(base^=compare)); run; i saw the similar one online. actually i only it lists obs with their ids should i modify as id id?

Reeza · ‎07-06-2016

I'm going to suggest a different but approach, build a library of ALL ICD9 and ICD10 codes, preferably each as a format. Then check each value against that list and see if it's present in either, both, or neither and classify accordingly. Lists of each set of codes are available online.

Bal23 · ‎07-06-2016

thanks

Bal23 · ‎07-06-2016

Thanks. Would you please provide a sample code for this?

Bal23 · ‎07-05-2016

thanks

Bal23 · ‎07-05-2016

Thanks. Can you suggest an option with sql, since they are very large datasets?

Bal23 · ‎07-05-2016

Thank you very much. This is very helpful. But I do not quite understand. Would you please explain it to me for each part of your code? Thank you again

Bal23 · ‎07-01-2016

thank you

ChrisNZ · ‎06-29-2016

"What's the position of the date in the record?" means: how many characters do you have to count on your text input record before the date is found?

Astounding · ‎06-27-2016

It would also help to see the full INPUT statement. The one you posted doesn't match the results you are describing.

Online Status	Offline
Date Last Visited	‎05-01-2023 12:04 PM

2023 Customer Awards: Parexel - Curious Thinker

build models

Re: Atlantic hurricanes - (United) States at risk

Re: Atlantic hurricanes - (United) States at risk

Re: Atlantic hurricanes - (United) States at risk

Re: What are criteria to reject a variable?

What are criteria to reject a variable?

Re: how can i replace all missing values of all char variables in a da...

how can i replace all missing values of all char variables in a data s...

Re: how to replace into with "symptux"

Re: how to replace those numbers with macro or do loop

Re: Can "let id2=1233 " be replaced with "let id2 in ("1233","1234&quo

Re: Can "let id2=1233 " be replaced with "let id2 in ("1233","1234&amp

Re: how do I replace numbers with do loop macro

Re: how do I replace numbers with do loop macro

2023 Customer Awards: Parexel - Curious Thinker

Re: how to replace those numbers with macro or do loop

Re: how to count the frequency of variables that I have generated

Re: how can I find these values are numeric from a char variable

Re: how to create a variable, modify a variable, where it contains lot...

Re: remove the first leading zero from charc variable

Re: create dummy variables, using one as reference

Re: linear regression model, force independent variable in then do bot...

Re: how to generate a new dataset after proc compare

Re: to read the dataset with a variable contains alpha, or number

Re: proc freq how to change the order of yes no

Re: how to use macro to sort multiple datasets then to merge

Re: how to convert date $8. to sas date

Re: use proc sql to merge multiple dataset

Re: Output Multiple Datasets in Datastep with indirect name references

Re: how to read a dataset that contains both icd-9 and icd 10 code

Re: lrecl option

Re: double trailing option