About rudfaden

rudfaden · ‎08-08-2018

proc format; picture million (round fuzz=0) 0 -high = '009.999.999' (prefix='' mult=1000); run; proc report data=tbl nowd; column Team y ; define Team / group; define y / analysis sum; format y million.; rbreak after / summarize; run;

rudfaden · ‎08-08-2018

Try using a picture format Data tbl; input ID Team $ y; cards; 1 a 1000 2 a 2000 3 a 3000 4 b 4000 5 b 5000 ; run; proc format; picture million (round fuzz=0) 0 -high = '9.999.999' (prefix='' mult=1000); run; proc report data=tbl nowd; column Team y ; define Team / group; define y / analysis sum; format y million.; rbreak after / summarize; run;

rudfaden · ‎08-08-2018

The problem is that Variable is empty, but you are telling Substr to extract on character, so it throws an error. You should include a check for Variable being empty.

rudfaden · ‎08-07-2018

If you right click on the files and choose properties, you can see the file location

rudfaden · ‎08-07-2018

Why does it not work with House Dog Cat Cars This: %let StringA = House Dog Cat Cars; %let StringB = Cars House Model Fish; %macro findWords; %let remove=&stringA; %do i=1 %to %sysfunc(countw(&stringA)); %let word=%scan(&stringB,&i); %let remove=%sysfunc(tranwrd(&remove, &word,)); %end; %let StringA=%sysfunc(tranwrd(&StringA, &remove,)); %put remove=&remove; %put stringA=&StringA; %put stringB=&stringB; %mend; %findWords; returns remove=Dog Cat stringA=House Cars stringB=Cars House Model Fish

rudfaden · ‎08-07-2018

Ahh. Okay. I misunderstood your problem. Try this: data have; variable="[2011-12-12--2014-04-04] Moudy El Khodr;[2016-10-01--] Laurent van Tuyckom;[2014-04-04--2016-10-01] Ignace de Coene;[2014-04-04--2016-01-01] Alexander Roose;[2016-10-01--] Alexander Roose;[2014-04-04--2015-03-01] Koen Bosquet;"; run; data want; set have; num=1; start=1; do while (1); num=findc(variable,';',start); if num = 0 then leave; variable2=substr(variable,start,num-start+1); output; start=num+1; end; run;

rudfaden · ‎08-07-2018

You might want to try using regex. data have; variable="[2011-12-12--2014-04-04] Moudy El Khodr;"; output; variable="[2016-10-01--] Laurent van Tuyckom;"; output; variable="[2014-04-04--2016-10-01] Ignace de Coene;"; output; variable="[2014-04-04--2016-01-01] Alexander Roose;"; output; variable="[2016-10-01--] Alexander Roose;"; output; variable="[2014-04-04--2015-03-01] Koen Bosquet;"; output; run; data want; set have; newString=prxchange('s/\[(.*);/$1/', -1, variable); run;

rudfaden · ‎08-07-2018

This might work %let StringA = Cars Dog Cat; %let StringB = Cars House Model Fish; %macro findWords; %let remove=&stringA; %do i=1 %to %sysfunc(countw(&stringA)); %let word=%scan(&stringB,&i); %let remove=%sysfunc(tranwrd(&remove, &word,)); %end; %let StringA=%sysfunc(tranwrd(&StringA, &remove,)); %put remove=&remove; %put stringA=&StringA; %put stringB=&stringB; %mend; %findWords;

rudfaden · ‎07-02-2018

What exactly is your question?

rudfaden · ‎05-28-2018

I found the problem. I sued the non formatted values in the attribute map. I should use the formatted values.

rudfaden · ‎05-24-2018

When I run it, the attribute map has no effect. But as it works with you, I migth try agian

rudfaden · ‎05-24-2018

Can anybody please give me a hint to why my attribute map is not working? data sygefravaer; input org1 $ aar frvpct; datalines; BIH 2008 0.054808 BIH 2009 0.055320 BIH 2010 0.052181 BIH 2011 0.048537 BIH 2012 0.044407 BIH 2013 0.045194 BIH 2014 0.044820 BIH 2015 0.047625 BIH 2016 0.043911 BIH 2017 0.041832 BOH 2008 0.047234 BOH 2009 0.048923 BOH 2010 0.045335 BOH 2011 0.041233 BOH 2012 0.037196 BOH 2013 0.048197 BOH 2014 0.041970 BOH 2015 0.040119 BOH 2016 0.037073 BOH 2017 0.043347 HAN 2008 0.067321 HAN 2009 0.067417 HAN 2010 0.064484 HAN 2011 0.061578 HAN 2012 0.063485 HAN 2013 0.056805 HAN 2014 0.058914 HAN 2015 0.063266 HAN 2016 0.064831 HAN 2017 0.062269 HEH 2008 0.051338 HEH 2009 0.052693 HEH 2010 0.051506 HEH 2011 0.046498 HEH 2012 0.044183 HEH 2013 0.043885 HEH 2014 0.045182 HEH 2015 0.045543 HEH 2016 0.042784 HEH 2017 0.043929 HVH 2008 0.053729 HVH 2009 0.050651 HVH 2010 0.050757 HVH 2011 0.046209 HVH 2012 0.043999 HVH 2013 0.042450 HVH 2014 0.043704 HVH 2015 0.046561 HVH 2016 0.045978 HVH 2017 0.045988 NOH 2008 0.058046 NOH 2009 0.056435 NOH 2010 0.054261 NOH 2011 0.051954 NOH 2012 0.051563 NOH 2013 0.053010 NOH 2014 0.050787 NOH 2015 0.052280 NOH 2016 0.052086 NOH 2017 0.049857 RIH 2008 0.046773 RIH 2009 0.047331 RIH 2010 0.043580 RIH 2011 0.042840 RIH 2012 0.040495 RIH 2013 0.041050 RIH 2014 0.042356 RIH 2015 0.043788 RIH 2016 0.043234 RIH 2017 0.044060 ÅÅÅ 2008 0.054585 ÅÅÅ 2009 0.053936 ÅÅÅ 2010 0.051457 ÅÅÅ 2011 0.048624 ÅÅÅ 2012 0.046065 ÅÅÅ 2013 0.045541 ÅÅÅ 2014 0.045435 ÅÅÅ 2015 0.047224 ÅÅÅ 2016 0.045546 ÅÅÅ 2017 0.045474 ; run; proc sql; /* dataattrbute map */ create table attrmap (ID char(4), value char(3),linethickness num(1), linecolor char(9), linepattern char(30)); insert into attrmap values('org' 'NOH' 4 'green' 'solid') values('org' "ÅÅÅ" 2 'orange' 'MediumDashShortDash') values('org' "HVH" 2 'blue' 'solid') values('org' "BIH" 2 'red' 'solid') values('org' "HEH" 2 'orange' 'solid') values('org' "RIH" 2 'pink' 'solid') ; quit; proc sgplot data=sygefravaer dattrmap=attrmap; where org1 in ('ÅÅÅ', 'HVH', 'BIH','HEH', 'NOH','RIH'); series x=aar y=frvpct /group=org1 nomissinggroup markers attrid=org; xaxis type=discrete grid label=' '; yaxis label="Sygefravær (%)" grid; refline 0.045 / transparency = 0.3 label = ('Målsætning'); format org1 $org1fmt. frvpct percent10.1; keylegend /title='' noborder; run;

rudfaden · ‎04-03-2018

Syntax seems to be fine. What error do you get?

rudfaden · ‎02-09-2018

I am trying to use a Google premium account for google maps, as I need to use Google maps beyond with is available free

rudfaden · ‎02-08-2018

I am not talking about converting the whole charset to from utf-8 to wlatin. Only those that are in wlatin

Online Status	Offline
Date Last Visited	9 hours ago

Re: How do I add a table, date of birth, and calculate age. Error 22-3...

Re: Add a value to a Macro-Variable

Re: Conversation termination; status=1.

Re: Create volatile table in Tera via SAS and view the table in SAS

Re: .SAS file with text and pwencode

Re: calculated row

Re: I want to export all the dataset name and corresponding variable n...

Re: %let macro variable using in proc sql

Re: %let macro variable using in proc sql

Re: Having Trouble with Macro Variables in SAS When Including If Then ...

Re: .SAS file with text and pwencode

SAS Packages Framework, version 20231210

SAS Packages Framework, version 20231111

Re: How to write utf-8 data to SQL server?

Community ranks now have level indicators

Re: .SAS file with text and pwencode

Re: Trying to connect with database using libname statement.

Re: proc report-Display values in millions instead of thousands

Re: Matching cases to controls without replacement

Re: calculate age from date in character format

Re: proc report-Display values in millions instead of thousands

Re: proc report-Display values in millions instead of thousands

Re: How to parse characters between two different delimiters?

Re: infile statement in sas

Re: Compare two strings and delte if

Re: How to parse characters between two different delimiters?

Re: How to parse characters between two different delimiters?

Re: Compare two strings and delte if

Re: Longitudinal data: Higher-order change change trajectories

Re: SAS attribute map in series plot

Re: SAS attribute map in series plot

SAS attribute map in series plot

Re: delete statement in Proc SQL

Re: Making a api call to google maps using HMAC-SHA1 signed key

Re: Encoding when reading data from api

SAS Community Nordic

SAS Innovate 2024

SAS Analytics Explorers