Hi Team, I have dataset with data this way data dataset1; input v1 v2; cards; 10 12 12 21 23 22 22 45 33 24 ; run; And I am expecting the output which would diagonally compare and provides me the max value .. if diagonally  value was not found then it should return the same value with the column v2 (33 24 seen below) output:- V1 V2 10 21 23 45 33 24 Any help on this is really appreciated.. ... View more

Hi All, I need your  help to overcome this issue Lets say i have text file in unix server A  and I was trying to read that file into other server where my actual code is located to create SAS dataset. Ex sample. txt is on unix server  (host) 'abcd01' I am  running my sas code which converts this  txt file as my dataset. (host=abcd01) I did use this code below but no luck (I assume my servers use sftp connection) filename myfile ftp 'data' cd='/u/kudzu/mydata'   user='guest' host='hp720.hp.sas.com'   recfm=v prompt; data mydata / view=mydata; /* Create a view */   infile myfile;   input x $10. y 4.; run; proc print data=mydata; /* Print the data */ run; NOTE : I dont want copy the files using ftp just wanted to read the file and create the dataset. Any help is really appreciated!! thanks MVK ... View more

Hi All, Question  A I have situation where i need convert the SAS datasets into the flat files irrespective how many varaiables or how much data it has . ( i am trying out in such a way that if i give dataset name it should convert the data into flat file) "One observation should be read as single like example i am going to assign varchar(3000)  so on." Question  B Coverting the flat file into the sas dataset even in this case also i am not about the size but should read the variables and coloums data. Any help would really be apprciated .. I am trying out from end as well. MVK ... View more

Hi All, I would appreciate if someone could help in masking data in sas dataset. Example:  I have sas dataset like below Customer_name  Customer_ID John                    12345 Mke                     12346 I wanted mask one column in this say customer_name. how can we do that. In case if we encrypt the data is there a way to decrept also. Thanks in advance... MVK ... View more

I have dataset example Test which has huge data present in that, its located in unix server. I have some new data which need to be appended to the existing dataset (say test has 10 years data , 11th year data is new data) in that case i want to check the dataset filesize and disk free space before archiving the 1 year data. Anytime you open the file i should have only 10 years data. This has to be done through SAS coding. I would appreciate if someone help me on this. Thanks in advance..MVK ... View more

Hi I have sas code which i run in unix sas by using sas followed by the code name or program name ex: sas test.sas Now i was asked to create a trigger file to run the  sas code on unix environment as it was running manually so far... script .sh .. i am not sure how to create the tirgger file could some help me on this. The trigger file should have the current timestamp ... Any help really appriciated!! VK ... View more

how to calculate leap year thru SAS. In case if i have value say year 2000 its divisible by 4 so its called as leap year. Likewise i will i have set of years say 2000 to 2012 then how can i do the calculation. ... View more

Hi , I am a newbee to this community ,.. but i follow the question and answers posted here. My question is there a way that we can calculate days in a given month EX: Jan =31 days Feb = 28 or 29. Moreover i need to check given year is leap year or normail year then need to calculate number of days in each month. Any help appreciated!! ... View more