About rajeshalwayswel

rajeshalwayswel · ‎11-13-2017

data al; input a; cards; 11 12 13 14 15 16 17 18 19 20 21 22 23 run; data _null_; set al; call symputx("n"||put(_N_,1.),a); run; 1) can someone try it by above code to resolve macro variable and errors? 2) I think it error becoz of in function length. 3) Please try it only in using above code and got it using SQL... ERROR: Symbolic variable name N* must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('n*',20) at line 310 column 6 is invalid. a=20 _ERROR_=1 _N_=10 ERROR: Symbolic variable name N* must contain only letters, digits, and underscores. NOTE: Argument 1 to function SYMPUTX('n*',21) at line 310 column 6 is invalid. a=21 _ERROR_=1 _N_=11

rajeshalwayswel · ‎11-10-2017

According my knowledge : Implicit array : we cannot control it always increment by 1 (do over). Explicit array : we can control it by iteration..

rajeshalwayswel · ‎11-10-2017

Thanks Everyone for your support...

rajeshalwayswel · ‎11-09-2017

data have; input col1 col2 col3 col4 col5 col99; cards; 1 2 3 4 5 21 4 1 5 3 1 20 1 5 3 2 4 22 1 4 2 3 1 15 run; data have; set have; if ~missing(col1) and ~missing(col99) then col11=put(col1,3.)||' ('||put((col1/col99)*100,5.1)||')'; if ~missing(col2) and ~missing(col99) then col21=put(col2,3.)||' ('||put((col2/col99)*100,5.1)||')'; if ~missing(col3) and ~missing(col99) then col31=put(col3,3.)||' ('||put((col3/col99)*100,5.1)||')'; if ~missing(col4) and ~missing(col99) then col41=put(col4,3.)||' ('||put((col4/col99)*100,5.1)||')'; if ~missing(col5) and ~missing(col99) then col51=put(col5,3.)||' ('||put((col5/col99)*100,5.1)||')'; run; Can someone try it arrays Please I'm written in data steps

rajeshalwayswel · ‎11-07-2017

Thank you..

rajeshalwayswel · ‎11-07-2017

yes clinical trials

rajeshalwayswel · ‎11-07-2017

Can someone say what is protocol deviation?

rajeshalwayswel · ‎11-05-2017

While using the you mentioned format prefix with "0" it starting how to remove it...I'm using prefix=' ' also it not working still it getting prefix '0'...

rajeshalwayswel · ‎11-05-2017

proc format ; picture intfm(round) 0<-9 = '9 ' (prefix=' ') 10-99 = '99 ' (prefix=' ') 100-999= '999 ' (prefix=' ') /*., 0= '9 ' (prefix=' ')*/ ; run; data have; input a; format a intfm.; cards; 1 33 556 1 run; When I'm applying intfm format in have data set it correctly not formatting can someone look into it. Please Share if you have any more details on it...Thank you everyone for your response of my questions... My desired output; 1 33 556 1

rajeshalwayswel · ‎11-05-2017

When I exceute the code we have missing values in the dataset..array primes{50} 1; when we using 1 in this place I'm getting error...Is any thing need to change in it..

rajeshalwayswel · ‎11-05-2017

How to pick prime,even and odd numbers using datasteps and do loops? Atleast 0 to 50?

rajeshalwayswel · ‎11-05-2017

It's tricky too...but new to learn from it...Thank you...

rajeshalwayswel · ‎11-04-2017

Is another like ":" way if '<>' end's at last..

rajeshalwayswel · ‎11-04-2017

I understand it.....Thank you.... 🙂

rajeshalwayswel · ‎11-04-2017

Online Status	Offline
Date Last Visited	‎03-30-2021 03:15 AM

Re: I have data as below how can I retain it?

Re: I have data as below how can I retain it?

I have data as below how can I retain it?

How to convert below dates to as required format?

How to import excel file with extention xlsx?

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

How to get minimum value for the below data?

Re: How to handle the decimals in the following the data? COuld you pl...

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: A sas print procedure output of the work.level data set is listed ...

Re: row wise count

I have data as below how can I retain it?

Re: How to get minimum value for the below data?

Re: Use data step to get the second highest salary

Difference between proc means and summary?

How to resolve a macro using call symputx?

What is the difference between explicit and implicit array?

Re: Can someone try it arrays?

Can someone try it arrays?

Re: Can someone say what is protocol deviation?

Re: Can someone say what is protocol deviation?

Can someone say what is protocol deviation?

Re: Picture Formats

Picture Formats

Re: How to pick prime,even and odd numbers using datasteps and do loop...

How to pick prime,even and odd numbers using datasteps and do loops?

Re: If '>' symbol we need to add +0.01, if '<' we need to substract -...

Re: If '>' symbol we need to add +0.01, if '<' we need to substract -...

Re: If '>' symbol we need to add +0.01, if '<' we need to substract -...

Re: If '>' symbol we need to add +0.01, if '<' we need to substract -...

CoDe SAS German