About Ajayvit

Ajayvit

data test; set sashelp.class; where sex eq "F"; /* apply filter condition */ if _n_ <4; /* limit the observation number * / run;

Ajayvit · ‎08-14-2023

Hi Team, I have couple of datasets and they are appearing in SAS Studio library "A". But they are not opening. While opening I am getting error message. ERROR: Tables with 0 columns are not supported bu this object. My code is: libname a 'path\SDTM datasets'; options nofmterr; data test; set a.ae(encoding=ascii); run;

Ajayvit · ‎08-11-2023

Hi Team, I need help for below scenario. All dated will be in ascending order and if any date is smaller than its previous date then that is odd and need to be filter out. I applied lag function but it is getting applied on entire variable not on group if 1 and 2 separately. data test1; input id date$12.; datalines; 1 01JAN2010 1 04JAN2010 1 08JAN2010 1 07JAN2010 1 11JAN2010 2 05JAN2010 2 06JAN2010 2 04JAN2010 2 07JAN2010 2 10JAN2010 ; RUN; Expected output: 1 07JAN2010 2 04JAN2010

Ajayvit · ‎07-27-2023

What i did not understood is : here we are performing lookup for common variable and value which is like (if a and b in merge) but how to manipulate this condition like if a or if a and not b like this. Thank you.

Ajayvit · ‎07-27-2023

Hi Josvander, Thank you for your help. I have been there i was not able to understood the solution thats why i am here. Thank You.

Ajayvit · ‎07-27-2023

Hi Team, I want to understand about IORC process in Data Step by using Index. My requirement is we have two data set (A and B),(A) is small and (B)is very large. I do understand that for large data set we can create index. But how to merge tow data set using __IORC__ technique. ? *Index larger file; proc datasets lib=work; modify daset_name; index create variable_name/unique; quit;

Ajayvit · ‎06-12-2023

Hi Folks, just like in python (https://pythontutor.com/) i am looking for way to trace execution of SAS program step by step but unfortunately i did not found any such option. I also tried debug data set option but it is of no use. Is there a way to trace execution of program and see its result step by step then kindly share those information. Thank you.

Ajayvit · ‎09-26-2020

Hi Kurt, I took the reference to your code and did some modifications. This is also giving the same result. data sv_1; set sv; if find(visit,"cycle") then do; sq+1; nd=0; end; else nd+1; seq=catx(".",sq,nd); keep visit seq; run;

Ajayvit · ‎09-26-2020

Dear Kurt, Thank you so much for your kind help. Regards, Ajay

Ajayvit · ‎09-26-2020

Dear Rezza, Thank you for your help. My expectation is: visit Number ------ ------ cycle1 1 or 1.0 cycle2 2 or 2.0 unsch 2.1 unsch 2.2 cycle3 3 or 3.0 unsch 3.1 unsch 3.2 cycle4 4 or 4.0 cycle5 5 or 5.0 What I am getting is : visit Number ------ ------ cycle1 1.0 cycle2 2.0 unsch 2.1 unsch 2.2 cycle3 3.2 unsch 3.3 unsch 3.4 cycle4 4.4 cycle5 5.5 for cycle3 cycle4 cycle5 not getting the expected value.

Ajayvit · ‎09-26-2020

Question; data sv; input visit$; datalines; cycle1 cycle2 unsch unsch cycle3 unsch unsch cycle4 cycle5 ; run; Expecting; visit Number ------ ------ cycle1 1 cycle2 2 unsch 2.1 unsch 2.2 cycle3 3 unsch 3.1 unsch 3.2 cycle4 4 cycle5 5 ___________________________________ Code I used(but not giving expected result) data visit; set sv; if visit in ("cycle") then seq=1; else seq+1; retain seq; if visit in("unsch") then seq=seq+3; run;

Ajayvit · ‎07-14-2019

Dear Cynthia, Thank you for providing all these information. Actually the thing is this Big Data course is very very expensive. I was looking for other alternative to study this. Regards, Ajay

Ajayvit · ‎07-13-2019

Hi fellas, Its really nice to know that you have completed this course, could you please provide me information that where to study SAS Bigdata course, study material and syllabus and all.

Ajayvit · ‎06-01-2019

Dear, While executing below dataset I am getting error. Can some one help to figure out why is the error and how to correct it. Data testing3; infile datalines dlm=','; input pid name$ ad date9. dc date9. ; format ad dc date9.; datalines; 101,Thanaos,12Jan2019,29Jan2019 201,Dtrange,11Mar2019,18Mar2019 301,Steve,23Sep2018,19Feb2019 401,Steve,23Sep2018,01May2019 ; run; Error: Data testing3; 308 infile datalines dlm=','; 309 input pid name$ ad date9. dc date9. ; 310 format ad dc date9.; 311 datalines; NOTE: Invalid data for dc in line 312 21-29. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8---- 312 101,Thanao,12Jan2019,29Jan2019 pid=101 name=Thanao ad=12JAN2019 dc=. _ERROR_=1 _N_=1 NOTE: Invalid data for dc in line 313 22-30. 313 201,Dtrange,11Mar2019,18Mar2019 pid=201 name=Dtrange ad=11MAR2019 dc=. _ERROR_=1 _N_=2 NOTE: Invalid data for dc in line 314 20-28. 314 301,Steve,23Sep2018,19Feb2019 pid=301 name=Steve ad=23SEP2018 dc=. _ERROR_=1 _N_=3 NOTE: Invalid data for dc in line 315 20-28. 315 401,Steve,23Sep2018,01May2019 pid=401 name=Steve ad=23SEP2018 dc=. _ERROR_=1 _N_=4 NOTE: The data set WORK.TESTING3 has 4 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 316 ; 317 run;

Ajayvit · ‎05-29-2019

data demo2; set demo; days=intck('Day',bdate,svdate); /*how to conver this days into year*/ months=intck('Months',bdate,svdate); year=intck('Years',bdate,svdate); inyear=int(days/365); /*this will convert days into year and int which I have mention will eliminate decimal value and give year*/ run;

Online Status	Offline
Date Last Visited	Monday

Re: How do you limit the number of observations of the output dataset?

unable to open any dataset in SAS Studio

How to filter odd dates

Re: IORC process in Data Step by using Index.

Re: IORC process in Data Step by using Index.

IORC process in Data Step by using Index.

How to trace SAS program execution

Re: SAS 9.4

Re: SAS 9.4

Re: SAS 9.4

Re: Filtering based on Date

Re: Character function

Re: Call define in proc report

Re: How do you limit the number of observations of the output dataset?

Re: How do you limit the number of observations of the output dataset?

unable to open any dataset in SAS Studio

How to filter odd dates

Re: IORC process in Data Step by using Index.

Re: IORC process in Data Step by using Index.

IORC process in Data Step by using Index.

How to trace SAS program execution

Re: SAS 9.4

Re: SAS 9.4

Re: SAS 9.4

SAS 9.4

Re: Big Data Programming and Loading - certification

Re: Big Data Programming and Loading - certification

Getting _ERROR_=1 _N_=1

Re: How to convert no of days to years months days format.