About vishalrajpoot3

vishalrajpoot3 · ‎09-13-2018

Thanks When you assigning 1 for missing value, why this is not showing in output data set. below is the code I came with as solution- proc means data=sashelp.yr1001 noprint; output out=abc (drop= _ : ) sum= add_1 - add_504; run; data ab1 (drop=add:); set sashelp.yr1001; if _n_ = 1 then set abc; array z(*) S:; do i = 1 to dim(z); if z(i)=. then z(i)=1; end; array x(*) p1 - p504; array y(*) add_:; do i = 1 to dim(x); if x(i)=. then x(i)=(z(i)/y(i))*100; end; run;

vishalrajpoot3 · ‎09-07-2018

Ohhh yes, that was the only issue. Thanks

vishalrajpoot3 · ‎09-07-2018

there is 505 column and only first column is 'T' and rest 504 starts with 'S0'.

vishalrajpoot3 · ‎09-07-2018

I am using SAS Studio and SAS University Edition, in libraries ,in both the option this YR1001 is there.

vishalrajpoot3 · ‎09-07-2018

if i change the array size from 504 to 503 code is working fine. But when i go through the properties of Yr1001 there are 505 variables in it. Is something i am missing. Name: YR1001 Description: M-competition 1001 Series, Annual Type: Table Location: SASHELP.YR1001 Rows: 126 Columns: 505 Date created: Aug 10, 2017, 7:35:46 AM Date modified: Aug 10, 2017, 7:35:46 AM

vishalrajpoot3 · ‎09-07-2018

no, there are 505 variable in YR1001 out of which 504 start with 'S00'.

vishalrajpoot3 · ‎09-07-2018

Please help me to understand how can i get a new column added to set sashelp.yr1001. The new column should be the percentage of total of the column of YR1001. Below is my code, I am getting the below error and everything is written in log window. ERROR: Array subscript out of range at line 81 column 43. Code - proc means data=sashelp.yr1001 noprint; output out=abc (drop= _ : ) sum= sum_1 - sum_504; run; data ab1; set sashelp.yr1001; if _n_ = 1 then set abc; array z(*) s0:; do i = 1 to dim(z); if z(i)=. then z(i)=1; end; array x(*) p1 - p504; array y(*) sum:; do i = 1 to dim(x); if x(i)=. then x(i)=(y(i)/z(i))/100; end; run;

vishalrajpoot3 · ‎08-01-2018

What is the meaning of +2 in below code ? What will be the impact on output ? data abc; input Type $ 1-5 + 2 Color $; datalines; daisyyellow ; run;

vishalrajpoot3 · ‎07-25-2018

so what would you like to suggest doing in this case?

vishalrajpoot3 · ‎07-25-2018

@PaigeMiller please see the below desired output. dept area D1 a, b, c d2 s, d, f d3 y d4 r, f, t

vishalrajpoot3 · ‎07-25-2018

Hello Team, How can I concatenate the below data on the basis of unique dept with all the area in output? data abc; input dept $ area $; datalines; D1 a d1 b d1 c d2 s d2 d d2 f d3 y d4 r d4 f d4 t ; run;

vishalrajpoot3 · ‎07-19-2018

yes Tom, you are right, it shows only difference. I am at bragging stage of learning SAS, so I just tried to give a part of solution.

vishalrajpoot3 · ‎07-19-2018

I want age in numeric, yes only for this scenario age is only two digit long.

vishalrajpoot3 · ‎07-19-2018

This is how sum function works- Sum (1, 2, ., 3) = 6, ==> means when we use ' , ' in sum function it ignores the missing value and sum the other values. Sum (1 + 2 + . +3) = . (missing), ==> means when we use '+' in sum function it considers 'missing + Value = missing' .

vishalrajpoot3 · ‎07-18-2018

Will someone provide me the solution for subjected problem with the below data, I want to extract age from the below data using 'Length' and 'Substr' function. Data test; input nameage $10.; datalines; Ram24 Albertaa26 Bob85 AB23 ; run;

Online Status	Offline
Date Last Visited	‎01-17-2025 04:39 PM

Facing error while concatenating the columns

Need to calculate the mode through SQL query.

Re: How to pass macro variable in Proc SQL functions

How to pass macro variable in Proc SQL functions

Re: Proc Freq Procedure.

Re: Proc Freq Procedure.

Re: Proc Freq Procedure.

Re: Proc Freq Procedure.

Re: Proc Freq Procedure.

Proc Freq Procedure.

Re: Base SAS

Re: Base SAS

Re: Base SAS

Re: Base SAS

Re: Base SAS

Re: Base SAS

Re: Base SAS

Re: Base SAS

Adding a new column to YR1001 data

What is the +2 in the below code ?

Re: How can I concatenate the data for each dept?

Re: How can I concatenate the data for each dept?

How can I concatenate the data for each dept?

Re: Difference between sum(x+y) and sum(x,y)

Re: Using Length and Substr function only how can i extract age from t...

Re: Difference between sum(x+y) and sum(x,y)

Using Length and Substr function only how can i extract age from the d...