Ok, but this means changing my server settings as I don't have SAS installed locally. What's the impact to change the encoding? ... View more

Did you found a solution? I'm trying to import an xml file encode in utf 8 but it tells me it's going wrong. The line he doesn't like : <WHOLENAME>Οργάνωση</WHOLENAME> ... View more

I suppose you've found a solution but if it's a character field containing numbers you can create a new field in your information map and put your expression. input(column_name,$8.) ... View more

point 1 is just counting the number of act='M956' and agencyspellbegin ge "7 months ago" and agencyspellbegin le today() how do you calculate 7 months ago? with the magic intnx function. intnx('month',mdy(month(today()),1,year(today()),-7) let's explain, intnx increments the given date with the interval given and the number of intervals. interval = month and number = -7. point 2 is calculating the age. So you ask sas the number of months between date of birth and today devided by 12.           c=intck('month',dob,today())/12;           c gives you the age in years but with a detail after the comma. with this calculated column you can then identify the age. if you want to count, same story as point 1. the hidden question about knowing if the shild is returned is using the first and last pointer in a datastep. added detail ... View more

I confirm the formats can be transferred from different operating systems. Two options exists, you hav the possiblity to rsubmit on the unix (source) from the windows server (target). In the rsubmit do a proc download. Other option, you're on the unix server and do a proc cport. Transfer the file to windows and there do a proc cimport. ... View more

hmmm, removing my prompts from my SP and then adding them back? this is really the worst case ... View more

data test; set original; retain gender; format gender $6.;/* used if new column*/ gender="male"; if var1='F' then gender="female"; run; in this example gender is always "male" but with condition of var1='F' gender is "female" ... View more

Hi metalray, The prompts are coming from a SP. But wrs retains your last selection and when you reconnect the prompts are filled by the last selected values. can we change the option in wrs or jboss and tell him not to retain previous selected values? ... View more

this is a nice example art297. To people like me who didn't know the "lag" function, it tells you the value from the record before. This is a nice feature to avoid the "retain" function. ... View more

there are multiple solutions to have the same result. I think your method is the best one even if the call execute will be executed at the end of your datastep. so first reading the whole dataset and then execute your macro calls. the other method is like a nice "brainfuck" but can be really useful. but if you want to use this option then you have to put all your variables in an array and then use the %do_over ... View more

You have two possibilities. first you can use the rsubmit and link this to your libname on the sas session. other solution is to work with a share and create your libname fith the share name. have a nice day. ... View more