About Miracle

Miracle · ‎07-05-2017

follow the steps here http://www.listendata.com/2016/06/avoid-truncation-in-proc-import.html

Miracle · ‎07-04-2017

try dbmax_text= in your proc sql Using SAS® to Manage and Report Long Text Fields in a Clinical DBMS

Miracle · ‎07-03-2017

One of my favourites is http://lexjansen.com/cgi-bin/xsl_transform.php?x=tmac&c=sugi

Miracle · ‎07-01-2017

maybe something like this? Character Functions data have; input string $35.; datalines; LIMCEE TABLET CELINTABLET AMOXYCLAV CAP RECLIMET OD TAB GLYCOMET SR TAB REFRESH TEARS WELL WOMEN CAPSULE RENERVECAPSULE MET XL TABLET MET XL AM TABLET SHELCAL SHELCAL HD SHELCAL HD12 TENCLIMET TABLET ZITAMET PLUS TABLET PREGAB M CAP LOSAR H40 TABLET LOSAR H80 TAB PRAZOPRESS XL 25 TABLET ; run; data TAB_INFO CAP_INFO OTHERS; set have; if substr(upcase(string),length(string)-5)='TABLET' or substr(upcase(string),length(string)-2)='TAB' then output TAB_INFO; else if substr(upcase(string),length(string)-6)='CAPSULE' or substr(upcase(string),length(string)-2)='CAP' then output CAP_INFO; else output OTHERS; run;

Miracle · ‎05-16-2017

or this suggestion here? Proc compare ignore case specificity

Miracle · ‎04-14-2017

How about using ods? i.e ods rtf, ods pdf. If you are very new to ods, have a read of this http://www.lexjansen.com/nesug/nesug03/ps/ps020.pdf

Miracle · ‎04-12-2017

perhaps try this approach as suggested here? https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-SAS-log-to-external-files/td-p/287838

Miracle · ‎04-11-2017

something like this? The statistics you wanting to capture is stored in dataset kstest. ods output kstest=kstest; proc npar1way ...; ... ... ... run; ods output close; data _null_; set kstest; call symputx('ValueAtMaximum',ValueAtMaximum); run; %put ValueAtMaximum=&ValueAtMaximum;

Miracle · ‎04-10-2017

maybe this? data demo; infile datalines; input record x y z a; cards; 1 34 54 65 76 2 34 54 65 76 3 34 54 65 76 4 34 54 65 76 5 98 45 09 56 6 12 43 98 87 7 12 43 98 87 8 76 93 68 34 ; run; proc sort data=demo out=dup_rec nouniquekey uniqueout=unique_rec; by x y z a; run; proc sort data=dup_rec; by record; run; proc print data=dup_rec noobs; run; proc sort data=unique_rec; by record; run; proc print data=unique_rec noobs; run;

Miracle · ‎04-03-2017

By the way, why is this function called coalesce? Just out of curiosity so it will help me to remembering it more easier. Thanks!

Miracle · ‎03-29-2017

Hi, try suggestions on this slides http://www.lexjansen.com/phuse/2015/dh/DH03_ppt.pdf slide 14 onwards. HTH.

Miracle · ‎03-25-2017

if by datastep data first; input Group $ Value @@; datalines; A 10 A 8 A 6 B 7 B 9 B 11 ; run; data second; input Group $ Volume @@; datalines; A 2 B 3 ; run; proc sort data=first; by Group; run; proc sort data=second; by Group; run; data want; merge first second; by Group; run; proc print data=want noobs; run;

Miracle · ‎02-27-2017

Hi, how about this? ods excel file='C:\Users\Desktop\want.xlsx' style=journal; ods excel options(sheet_name='Want' autofit_height='yes' width_fudge='0.58'); proc report data=have nowindows headline headskip; column county year totalstudents vax1 Pct_vax1 vax2 Pct_vax2 vax3 Pct_vax3; define county / group order; define year / group order=internal descending; define totalstudents / analysis; define vax1 / analysis;; define Pct_vax1 / right computed format=percent7.1; compute Pct_vax1; Pct_vax1=vax1.sum/totalstudents.sum; endcompute; define vax2 / analysis;; define Pct_vax2 / right computed format=percent7.1; compute Pct_vax2; Pct_vax2=vax2.sum/totalstudents.sum; endcompute; define vax3 / analysis;; define Pct_vax3 / right computed format=percent7.1; compute Pct_vax3; Pct_vax3=vax3.sum/totalstudents.sum; endcompute; compute after county; line ' '; endcomp; run; ods excel close; run;

Miracle · ‎02-26-2017

Hi, perhaps this post will resolve your problem? https://communities.sas.com/t5/SAS-Procedures/proc-import-won-t-read-all-columns/td-p/15895

Miracle · ‎02-24-2017

Hi, or this? Provided data input already ordered by date. data real; set real; by department notsorted; dif_sale = dif(sale); if first.department then do; dif_sale = .; end; input date $ 1-9 department $ sale ; cards; 30nov2016 west 175 31dec2016 west 134 31jan2017 west 124 30nov2016 east 198 31dec2016 east 182 31jan2017 east 117 30nov2016 south 200 31dec2016 south 203 31jan2017 south 205 30nov2016 north 199 31dec2016 north 194 31jan2017 north 106 ; run;

Online Status	Offline
Date Last Visited	‎02-26-2024 06:33 PM

Re: How to output p value for covariance parameter estimates when usin...

Re: Exposure-adjusted event rate

Re: Assign id

Re: Assign id

Assign id

Re: proc sql: combine data with string dates

Re: Replicate every id by all possible unique group present in data

Re: proc sql: combine data with string dates

Replicate every id by all possible unique group present in data

proc sql: combine data with string dates

Re: Exposure-adjusted event rate

Re: Assign id

Re: proc sql: combine data with string dates

Re: Exposure-adjusted event rate

Re: Conditionally run proc mixed within macro

Re: proc sort and dupout: how to get the pairs of duplicates

Re: Replicate every id by all possible unique group present in data

Re: Line thickness in legend

Re: How SAS output the special charater in string (from Oracle server)...

Re: Percentage calculation: calculate percentage changes in variable v...

Re: Data truncation while Importing from CSV file.

Re: Truncated Characters when extracting

Re: SAS Macro learning

Re: EXTRACTING characters from back

Re: Comparision of two varibles?

Re: How to save entire proc logistic output

Re: Can I export a log as a step in the project, even if there are err...

Re: PROC NPAR1WAY output KS stats

Re: sas

Re: SAS programming: select a numerical value with the oldest correspo...

Re: Some character data was lost during transcoding in the dataset

Re: SAS_merging two datasets

Re: How do list variable only once when you want to look at it over ti...

Re: max number of variables sas can import from excel

Re: Is there any way to transpose the observation into variable