About Mic35

Mic35 · ‎01-09-2021

Thank you for your time and explanations. By going through this method I seem to obtain the desired result.... remains more than just doing a last random check on all data. In any case I thank you both for the advices on these SAS functionalities that I almost never use. The ideal will always remain to participate in the design of the data collection in order to limit this kind of things. data demo (keep=id varname wanted); set demo; wanted = scan(varname,-1,","); run; data demo ; set demo; if find(wanted, 'Would like to view message',"i") >0 OR find(wanted, 'Would like to speak',"i") >0 THEN wanted=""; run; proc freq data=demo; table varname wanted; run

Mic35 · ‎01-09-2021

In the database I must analyze it is a mixture of known and unknown data. For the known data Tom's method is perfect (and simple 🙂 )but for the free-text data it's more complicated. In theory this free text is located at the end of the character string but not checked on all the data. for example my cell can be of the form ID varname 1 Would like to get TV, Would like to view message 2 Would like to speak 3 Would like to speak, Would like to get TV, I prefer ... but .... I prefer ... but... = free text added by the participant

Mic35 · ‎01-09-2021

Yes but how to be sure I do not forget the elements written in free text ? and how can I get them in easy way ?

Mic35 · ‎01-08-2021

My aim is to split multiple values from rows to multiple vars (create a new var for each same value) I have read various similar topics but all inclusive. Each rows contain between 1 to X information separate by a comma. For each variable I have to process, I have around 15 items plus the text typed by the users (free fields of a survey). Currently I get information by column but I didn't succeed to group each same value by column (see eg). I also tried to recode variables but, I have a lost of data... As I have several hundred lines and several variables with so much information to process, would someone please advise me? Eg: What I have Id Varname 1 Would like to get TV, Would like to view message 2 Would like to speak 3 Would like to speak, Would like to get TV An idea of what I want Id Varname TV SPEAK MSG 1 Would like to get TV, Would like to view message 1 0 1 2 Would like to speak 0 1 0 3 Would like to speak, Would like to get TV 1 1 0 Best Mic

Mic35 · ‎05-19-2020

I think i didn't give all informations. The polar plot arrive after Bland-Altman step and four-quadrant Process sometimes use in anesthesia - cardiology studies

Mic35 · ‎05-19-2020

@Rick I read them but i don't undernstand how can i use them to plot my situation... (already tested)

Mic35 · ‎05-19-2020

Hello, I am looking to graph a Polar plot for Δ between 2/3 methods. I read a lot of things but I am not sure of the great method to use and fear to do mistakes. My aim is to represent the same polar plot that the pict. I need to : - plot points (mean of Δ for each individue); - plot one line to represents the bias; - other to ±30° lines; - get the angular bias Best

Mic35 · ‎05-04-2020

UPDATE : 2021-JAN proc logistic data= base outest=betas; model Yvar(event="YES")= Xvariables / selection=backward slentry=0.2 slstay=0.05 details lackfit; ods output EffectInModel =effect; ods output fitstatistics=AIC( keep=Criterion InterceptAndCovariates step rename=(InterceptAndCovariates=AIC) where=(Criterion='AIC')); ods output fitstatistics= BIC (keep=Criterion InterceptAndCovariates step rename= (InterceptAndCovariates=BIC) where= (Criterion='SC')); run; *GET NAME VARS; proc freq data=effect noprint; table step*effect / out=sum1;run; data sum1(keep=step effect count ); set sum1; run; proc sort data=sum1; by step;run; #VAR NAME BY STEP; proc summary nway data=sum1 missing; class step; output out=new (drop=_type_ _freq_) idgroup(out[10](effect)=); run; data want(keep= step varl); set new; length varl $1000; varl = catx('- ', of effect:); run; *MERGE; data final(drop=criterion) ; merge aic bic want; by step; run; #REPORT; [...................]

Mic35 · ‎05-04-2020

Hello, I try to get a table with AIC and AICc in Proc logistic. I rode various articles and I decided to try the Qinley Huang method with %ic_logistic macro (https://www.pharmasug.org/proceedings/2014/SP/PharmaSUG-2014-SP04.pdf) but I meet a problem i think due to my junior experience (to create the combiantion and model specification sheets output). The aim is to get this type of table : Would you have quick tips? Thanks

Mic35 · ‎05-01-2020

The solution was effectively in the autoexec... one of my macros is a the origin of the error. I want to investigating what and why i had this message of error in this only step... Thanks a lot to remind myself cheking this basic step... 🙂

Mic35 · ‎04-30-2020

It's not a problem with my code, the only that I used. Just a proc format.... And at the begining I didn't have problem.. Why I get this error message NOW ? Maybe uninstalling the virtual machine and SAS is not enough. Is there a way to make sure that everything is really deleted?

Mic35 · ‎04-30-2020

Hi, Currently I train myself to do a great reporting (on SAS university) and after a few tries I having a problem. I have uninstalled and re-installed Virtual box and sas several times, the problem persists. Has anyone ever been confronted at this situation before? Do you have any problem-solving ideas? Thank you very much. I coded: proc format cntlout=titles; value $title "T_01_TITLE01 "= "^{style [just=C fontweight=bold] Title}" "T_01_FNOTE01 "='Class table ' "T_01_ORDER " ='1' "T_01_ORIENT " ='L' "T_01_BMARK " ='T_01' ; run; I get :

Mic35 · ‎04-25-2019

Thank you for your answer. It was enough to replace a word in the program... Why try to make it complicated when you can make it simple...

Mic35 · ‎04-24-2019

Hello, After doing a lot of research, and reading a lot of things on the forum, I wish a little help please... I am looking to optimize my data set for reporting. The table is obtained after a lot of proc transposes and merges with different tables (which can vary according to the configuration of the macro: uni/bivariate analysis, OR, test,...). Currently I have made a lot of progress on a lot of small things but there is still the problem of the p-value of var cat which is located at the last level of the modality. I tried to act at the data stage before the merge in order to link the p-value to the 1st modality... Then I tried to implement several techniques directly on the final dataset (reverse lag, try to assign to each modality the p-value initially given to one then apply an ARRAY /lag method to keep the 1st p-value appearing for each variable...). I think I missed something. The photo illustrates what I am getting now and what I want to get (p-value on the same line than the 1st modality, in automated version) If anyone has an idea, I'm a subscriber. I will be very grateful for yours answers Mic

Mic35 · ‎04-24-2019

A big thank you to you PG. Your code is very good. With variables that appear in some cases and not in others (i.e. OR or RR), I added the code below to complete. Now everything is perfect. Thank you again. ODS OUTPUT nLevels =work.nlevels; PROC FREQ DATA= &out. NLEVELS ; TABLE _ALL_ / NOPRINT ; RUN ; PROC SQL NOPRINT ; SELECT STRIP(tableVar) INTO : listeDrop SEPARATED BY "," FROM work.nlevesl WHERE NnonMissLevels = 0 ; ALTER TABLE &out. DROP &listeDrop ; QUIT ;

Online Status	Offline
Date Last Visited	‎10-13-2021 11:33 PM

Re: splitting string variable to new var

Re: splitting string variable to new var

Re: splitting string variable to new var

splitting string variable to new var

Re: polar plot with bias

Re: polar plot with bias

polar plot with bias

Re: Table with AIC and AICc in Proc logistic

Table with AIC and AICc in Proc logistic

Re: strange error with a simple proc format

Re: splitting string variable to new var

Re: splitting string variable to new var

Re: optimisation of the sas table before reporting

Re: Table with AIC and AICc in Proc logistic

Re: dataset optimization before reporting (get the pvalue on the 1st m...

Re: splitting string variable to new var

Re: splitting string variable to new var

Re: splitting string variable to new var

splitting string variable to new var

Re: polar plot with bias

Re: polar plot with bias

polar plot with bias

Re: Table with AIC and AICc in Proc logistic

Table with AIC and AICc in Proc logistic

Re: strange error with a simple proc format

Re: strange error with a simple proc format

strange error with a simple proc format

Re: dataset optimization before reporting (get the pvalue on the 1st m...

dataset optimization before reporting (get the pvalue on the 1st modal...

Re: optimisation of the sas table before reporting