About rajeshalwayswel

rajeshalwayswel · ‎01-13-2020

When visit=UNSCH value I need to retain before value and concatenate it by "UNSCH", Visit variable value

rajeshalwayswel · ‎01-13-2020

In new variables Visit_, Visitnum_.

rajeshalwayswel · ‎01-13-2020

DATA HAVE; INPUT VISIT $10. VISITNUM; CARDS; VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 UNSCH 999 UNSCH 999 RUN; Required Output: VISIT VISITNUM VISIT_ VISITNUM_ VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 VISIT 1 1 UNSCH 999 UNSCH VISIT 1 999.001 999.001 UNSCH 999 UNSCH VISIT 1 999.002 999.002

rajeshalwayswel · ‎12-05-2019

data have; input date $15.; cards; UN-UNK-2019 UN-NOV-2010 UN-JAN-2019 10-JAN-2018 ; run; Want: 2019-UNK-UN 2010-11-UN 2019-01-UN 2018-01-10

rajeshalwayswel · ‎11-30-2019

I'm unable to import excel file with extension xlsx. I'm using the below code. proc import datafile='.xlsx' dms=xlsx replace; run; Could you please help out how to resolve this...

rajeshalwayswel · ‎11-28-2019

Thanks so much Kurtbremser. It's worked....

rajeshalwayswel · ‎11-27-2019

Hi, It's work for the some the records but when I haves same visitnum it not working, Could you please have a look on the below data. data have; input subject visitnum results; cards; 101 1 3.9 101 2 1.1 101 3 2.2 101 4 2.0 101 5 0.9 101 5 0.9 ; run; Required: 101 1 3.9 . 101 2 1.1 3.9 101 3 2.2 1.1 101 4 2.0 1.1 101 5 0.9 1.1 101 5 0.9 0.9

rajeshalwayswel · ‎11-26-2019

oh, it's 1.1

rajeshalwayswel · ‎11-26-2019

data have; input subject visitnum results; cards; 101 1 1.1 101 2 2.2 101 3 2.2 101 4 2.0 101 5 0.9 101 6 2.0 run; Required Output: subject visitnum results required 101 1 3.9 . 101 2 2.2 3.9 101 3 2.2 2.2 101 4 2.0 2.2 101 5 0.9 2.0 101 6 2.0 0.9 The logicis for subject we need to get minimum value before to the visitnum

rajeshalwayswel · ‎10-24-2019

l is a character value, desired results needs to be in character.I too don't the logic I have data like this to show as required one.

rajeshalwayswel · ‎10-24-2019

data a; input l $10.; cards; 111.0000 1.0 0.00 0.000 0 22.120 262.100 run; required output 111 1.0 0.00 0.0000 0 22.120 262.1

rajeshalwayswel · ‎09-20-2019

yes, we have lot of ways to do this. But in interview asked me how can we do by only this function.

rajeshalwayswel · ‎09-20-2019

data have; var='this is sas'; run; Required output: thas is sas by using only translate function

rajeshalwayswel · ‎09-20-2019

I found the Solution of my question: :) data want; input date $20.; a1=put(input(date,anydtdte12.),yymmdd10.); cards; 21may2019 21-may-2012 21/may/2013 21-may-2014 21-may-12 12/21/2018 run;

rajeshalwayswel · ‎09-20-2019

data have; input date $20.; cards; 21may2019 21-may-2012 21/may/2013 21-may-2014 21-may-12 12/21/2018 run; want: 2019-05-21 2012-05-21 2013-05-21 2014-05-21 2012-05-21 2018-12-21

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?

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...

How to handle the decimals in the following the data? COuld you please...

Re: How can I do below data by using only translate function?

How can I do below data by using only translate function?

Re: How can I convert mixed type of date's to yymmdd10.?

How can I convert mixed type of date's to yymmdd10.?

CoDe SAS German