About thanikondharish

thanikondharish · ‎03-04-2021

I updated raw data.

thanikondharish · ‎03-04-2021

data have; input id type $ date mark $ stagen class $; informat date yymmdd10.; format date yymmdd10.; cards; 1001 aaa 2020-11-01 . 1 class1 1001 aaa 2020-11-01 . 2 class1 1001 aaa 2020-11-01 . 3 class1 1001 aaa 2020-11-01 first 4 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 last 8 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 . 1 class2 1001 aaa 2020-11-01 . 2 class2 1001 aaa 2020-11-01 . 3 class2 1001 aaa 2020-11-01 first 4 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 last 8 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 ; I have one dataset like above how to get output with count column like below dataset? Your ref: id type date mark stagen class count 1001 aaa 2020-11-01 . 1 class1 1001 aaa 2020-11-01 . 2 class1 1001 aaa 2020-11-01 . 3 class1 1001 aaa 2020-11-01 first 4 class1 1001 aaa 2020-11-01 . 9 class1 2 1001 aaa 2020-11-01 . 9 class1 2 1001 aaa 2020-11-01 last 8 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 . 1 class2 1001 aaa 2020-11-01 . 2 class2 1001 aaa 2020-11-01 . 3 class2 1001 aaa 2020-11-01 first 4 class2 1001 aaa 2020-11-01 . 9 class2 3 1001 aaa 2020-11-01 . 9 class2 3 1001 aaa 2020-11-01 . 9 class2 3 1001 aaa 2020-11-01 last 8 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 Note: between mark='first' and mark='last' there are stagen=9 related records there. How to take those count like see above output dataset by variables are id,type,class

thanikondharish · ‎03-04-2021

by id type

thanikondharish · ‎03-04-2021

state=9 is nothing but stagen=9 spelling mistake

thanikondharish · ‎03-04-2021

data sample; input id type $ date mark $ stagen class $; informat date yymmdd10.; format date yymmdd10.; cards; 1001 aaa 2020-11-01 . 1 class1 1001 aaa 2020-11-01 . 2 class1 1001 aaa 2020-11-01 . 3 class1 1001 aaa 2020-11-01 first 4 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 . 9 class1 1001 aaa 2020-11-01 last 8 class1 1001 aaa 2020-11-01 . 1 class2 1001 aaa 2020-11-01 . 2 class2 1001 aaa 2020-11-01 . 3 class2 1001 aaa 2020-11-01 first 4 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 . 9 class2 1001 aaa 2020-11-01 last 8 class2 ; run; how to create sequence number between first and last values in mark variable and how to count stagen='9' for your reference see below outupt id type date mark stagen class seq state9(count) 1001 aaa 2020-11-01 . 1 class1 1001 aaa 2020-11-01 . 2 class1 1001 aaa 2020-11-01 . 3 class1 1001 aaa 2020-11-01 first 4 class1 4 1001 aaa 2020-11-01 . 9 class1 5 2 1001 aaa 2020-11-01 . 9 class1 6 2 1001 aaa 2020-11-01 last 8 class1 7 1001 aaa 2020-11-01 . 1 class2 1001 aaa 2020-11-01 . 2 class2 1001 aaa 2020-11-01 . 3 class2 1001 aaa 2020-11-01 first 4 class2 4 1001 aaa 2020-11-01 . 9 class2 5 2 1001 aaa 2020-11-01 . 9 class2 6 2 1001 aaa 2020-11-01 last 8 class2 7 in above output between seq 4 and 7 there are state=9 two records are there these count reflect next column count=2 by variables(id,type,class)

thanikondharish · ‎02-25-2021

Sorry , We have to do in arrays only

thanikondharish · ‎02-25-2021

data a1 ; var1='abc' ; var2='def' ; var3='ghi' ; var4='abc' ; var5='xyz' ; var6='def' ; run; I have above dataset. how to remove duplicate values column wise in arrays. output come should come like see below example var1=abc var2='def' var3='ghi' var4=' ' var5='xyz' var6=' ' var4 and var6 we have to assign missing values because there values already in var1 and var2. I have tried below code. Kindly help me out. code: data a1 ; var1='abc' ; var2='def' ; var3='ghi' ; var4='abc' ; var5='xyz' ; var6='def' ; run; data a2 ; set a1 ; array apple(6) $ var1-var6 ; do i=1 to 5; do j=2 to 6 ; if apple(i) ne ' ' and apple(j) ne ' ' then do ; if (apple(i) ne ' ' and apple(j) ne ' ') and apple(i)=apple(j) then apple(i)=' ' ; end; end; end; run;

thanikondharish · ‎02-22-2021

I want data like it should give means is zero and standard deviation is one.

thanikondharish · ‎02-20-2021

data _null_ ; call symput('name','aaa') ; %let name=bbb ; run; %put &name ; If I execute above program is showing (aaa) value . why %let is not working and what is the logic behind that. Kindly explain?

thanikondharish · ‎02-07-2021

I have written one code to create stars line wise.for your reference please find attachment file1. How to get values like from file2 . file1-code: data _null_ ; j=24 ; do i=24 to 0 by -2; b=repeat('*',i) ; c=(j-i)/2 ; put +c b ; end; run;

thanikondharish · ‎01-25-2021

amt new_amt 2 2 -3 0 -4 0 5 5(-7)=-2 so should come zero and (-2 remaining value) 6 -2+6=4 (value 4 should come)(until value get positive) 7 7 -4 0 2 -4+2=-2 (negative so value should come 0) finally amt new_amt 2 2 -3 0 -4 0 5 0 6 4 7 7 -4 0 2 0 we have one data like negative and positive values are there if negative value is there then we have to subtract next value until get positive. I have give raw data and final data

thanikondharish · ‎09-01-2020

What is vsam file and give one example(sample programming)

thanikondharish · ‎08-19-2020

Please find attachment I have some files . How to take into sas as datasets

thanikondharish · ‎08-19-2020

I have one file that is portion document file like TXT file How to import or take that file into sas

thanikondharish · ‎08-16-2020

ex: %sysexec scp D:\file1\profit.xlsx F:/file2 ; Note: File will transfer to 'F' drive

Online Status	Offline
Date Last Visited	‎08-13-2024 04:09 AM

how to repeat group value for next page proc report rtf

how to flag wrong entries

Re: how to assign sequence number group wise with every five records

Re: how to assign sequence number group wise with every five records

Re: how to assign sequence number group wise with every five records

Re: how to assign sequence number group wise with every five records

Re: how to assign sequence number group wise with every five records

how to assign sequence number group wise with every five records

how maintain single space if string skip one line to another line

Re: how to filter record second position of 'a' letter from last onwar...

how to generate sequence number in sql

Re: how to creat count with in the range

how to creat count with in the range

Re: how to create sequence number and count number

Re: how to create sequence number and count number

how to create sequence number and count number

Re: how to remove duplicate values by using arrays

how to remove duplicate values by using arrays

how to get means is zero and standard deviation is one

%let is not working in data step block

how to create star

get value until get positive value group wise

What is vsam file and how can we take file into sas as dataset

Re: How to take portion document extension file

How to take portion document extension file

Re: how to transfer folder sas server to Linux and UNIX servers