About Nitish1003

Nitish1003 · ‎11-29-2023

Thanks a lot this helped

Nitish1003 · ‎11-28-2023

Hi All, I am trying to create a run book to have all my code in one place with %include statement. I have a job code and code name. What I did is I created a dataset with Job_Code, code_name and added Sn_no. Now I am trying to create a macro so that I can pass the Sn_no and that particular code should get executed. Any suggestion on how should I proceed with this? Thanks a lot for looking into it

Nitish1003 · ‎03-17-2022

Thanks for looking into it. The datasets name is in XYZ_yyyymm and moving all datasets to one folder is not possible

Nitish1003 · ‎03-17-2022

One libname for each folder because I want to traverse each folder and check for datasets. Each folder will have 500 of datasets

Nitish1003 · ‎03-17-2022

Hello everyone, Need one help with sas programming I have folder structure "201601" i.e. YYYYMM this is from year 2016 and still going on so for every month we create new folder for that particular year. Now I want to create libname for all the folders starting from 201601 to till date (I.e. 201601 to the month when the code is getting executed) Example of i am running the code for June 2022 the libname should be created from 201601 to 202206. Any suggestions how can I achive it. Appreciate some help here

Nitish1003 · ‎11-02-2018

Good Day all I am new to SAS Viya. I am trying to learn visual Analytics from there, But not able to find out the dataset being used in tutorial videos i.e. Customer and Customer_Clean dataset. Any lead on this will be a big help. Regards Nitish Kumar

Nitish1003 · ‎04-22-2017

Thanks for the help. I am just trying to learn sas.

Nitish1003 · ‎04-22-2017

Thanks got your Point Naveen

Nitish1003 · ‎04-22-2017

Hi Naveen Thanks for the help. Can you please let me know the logic how this code works. Regards Nitish

Nitish1003 · ‎04-22-2017

Need a help to generate alternate gender output. Dataset :- data new; input id gender $; datalines ; 1 M 2 M 3 M 4 F 5 F 6 F 7 M 8 F ; RUN; Output :- 1 M 4 F 2 M 5 F 3 M 6 F 7 M 8 F Please let me know how can i achieve it Regards Nitish

Nitish1003 · ‎03-15-2017

Thanks sir for the help. I missed the Id part in first solution.Thanks a lot for help 🙂

Nitish1003 · ‎03-15-2017

Hi Sir Your solution allmost worked for me but facing one issue.I am getting duplicate data i.e. Example for Priya Name DOB count DOB2 diff Priya 01JAN2016 4 10DEC2016 344 Priya 10DEC2016 4 01JAN2016 344 Is there way to Over come this because i want only one row.

Nitish1003 · ‎03-14-2017

Sorry for the typo the output will be like NAME DIFF NITISH (10MAR2016-10MAR2016) i.e. 0 days PRIYA (10DEC2016-01JAN016) SAKSHI (20DEC2016-20APR2016) SAKSHI (20DEC2016-02JAN2016) SAKSHI (20APR2016-02JAN2016) This would ne my deisre reult. Please Collin if you check it and let me know how to solve this problem. Thanks Nitish

Nitish1003 · ‎03-14-2017

Hi I am trying to find out difference between dates as per Name. data test; INPUT NAME $ DOB; INFORMAT DOB DATE9.; FORMAT DOB DATE9.; DATALINES; NITISH 10MAR2016 PRIYA 10DEC2016 PRIYA 01JAN2016 SAKSHI 20DEC2016 SAKSHI 20APR2016 SAKSHI 02JAN2016 ; RUN; So output will be like NAME DIFF NITISH (10MAR2016-10MAR2016) i.e. 0 days PRIYA (10DEC2016-10DEC2016) SAKSHI (20DEC2016-20APR2016) SAKSHI (20DEC2016-02JAN2016) SAKSHI (20APR2016-02JAN2016) Please help me to reach to solution. Itried using proc sort and appling lag in my dataset but was not able to achieve the results

Nitish1003 · ‎03-13-2017

Thanks every one for the help. I have got my answer and i have also gone through the details of using subquery.

Online Status	Offline
Date Last Visited	‎11-29-2023 03:25 PM

Re: Creating a run book for different code to run

Creating a run book for different code to run

Re: Dynamic Libname creation

Re: Dynamic Libname creation

Dynamic Libname creation

SAS Viya Visual Analytics

Re: Alternate gender in output

Re: Alternate gender in output

Re: Alternate gender in output

Alternate gender in output

Re: Alternate gender in output

Re: Alternate gender in output

Re: Difference in terms of days between dates in same column

Re: Difference in terms of days between dates in same column

Re: Difference in terms of days between dates in same column

Re: Creating a run book for different code to run

Creating a run book for different code to run

Re: Dynamic Libname creation

Re: Dynamic Libname creation

Dynamic Libname creation

SAS Viya Visual Analytics

Re: Alternate gender in output

Re: Alternate gender in output

Re: Alternate gender in output

Alternate gender in output

Re: Difference in terms of days between dates in same column

Re: Difference in terms of days between dates in same column

Re: Difference in terms of days between dates in same column

Difference in terms of days between dates in same column

Re: Third highest salary as per Department