About india2016

india2016 · ‎03-27-2017

Book1 Gender female male Book2 Gender female transgender male I have this two datasets in excel format.After importing these two excel sheets I want to append book1 & book2. If I use append table in SAS EG then I got "transg" which takes the length of "female" from book2. What should I do to get the right result?("transg" as transgender)

india2016 · ‎03-27-2017

base data set and append data set having different variable length and force option is not working.Is there any solution to get proper variable length?

india2016 · ‎03-22-2017

This is what i am getting in output for match district,circle,station,district1,Circle1 west,chomu,harmara,west,chomu east,adarshnagar,jawaharnagar,east,adarshnagar Output for mismatch district,circle,station,district1,Circle1 east,gandhinagar,gandhinagar,, Match is correct but i am not getting correct data for mismatch

india2016 · ‎03-22-2017

This is my program that i had done proc sort data=WORK.CORRECT; by station; run; proc sort data=WORK.INCORRECT; by station; run; data match mismatch; merge WORK.CORRECT(in=PC) WORK.INCORRECT(in=PS1 rename=(Circle=Circle1 district=district1)); by station; if PC; if district eq district1 and Circle eq Circle1 then output match; if district ne district1 and Circle ne Circle1 then output mismatch; run;

india2016 · ‎03-22-2017

input district :$10. circle :$20. station :$20.; cards; east adarshnagar adarshnagar east adarshnagar jawaharnagar east gandhinagar gandhinagar west chomu harmara west chomu vishwakarma ; run; data incorrect; infile cards; input district :$10. circle :$20. station :$20.; cards; east chomu adarshnagar east adarshnagar jawaharnagar west chomu harmara east chomu vishwakarma ; run;

india2016 · ‎03-20-2017

I have 2 dataset described below name correct data and incorrect data. Now i want to map incorrect data from correct data. For example in incorrect data for adarsh nagar station circle is incorrect and for harmara station police district is incorrect. I have used proc sort by station for both the table and then i have used IN= option but it wokrs for just one variable but i want to map data using for both variable i.e. circle and station. Correct Data Incorrect data District Circle Station District Circle Station EAST ADARSH NAGAR ADARSH NAGAR EAST CHOMU ADARSH NAGAR EAST ADARSH NAGAR JAWAHAR NAGAR EAST ADARSH NAGAR JAWAHAR NAGAR WEST CHOMU HARMARA WEST CHOMU HARMARA WEST CHOMU VISHWAKARMA EAST CHOMU VISHWAKARMA

india2016 · ‎02-10-2017

what should I use? "Case" or "If then"? To reduce process time?

india2016 · ‎02-09-2017

Thank you very much.

india2016 · ‎02-09-2017

Are you sure that,hindi would not make any difference? because I can remove that variable(unnecessary variable).

india2016 · ‎02-09-2017

hi all, Actually I want to minimise the process time for my ETL.How can I minimise that time? We are using left joins and sort In ETL. and we are working on some variable which are in HINDI language so is it take more time than english variables? what I should change that will reduce process time ? Thanks in Advance

india2016 · ‎01-17-2017

Sir, Could you please explain about How to Migrate our SAS datasets from Windows to Linux

india2016 · ‎01-16-2017

How to swtich My SAS VA from windows server to LInux server step by step?

india2016 · ‎01-13-2017

We are planning to update the daily data running scripts in linux. I want autoload the daily data on linux environment. What is procedure for doing the same?. Kindly help me out. Thanks in advance. 🙂

india2016 · ‎01-13-2017

@JuanS_OCS Thank you very much for detail information.

india2016 · ‎01-13-2017

Could you please explain how we make checklist for migration planning.Our migration will be done by administrator but I need to provide him checklist only.

Online Status	Offline
Date Last Visited	‎07-25-2024 09:17 AM

Re: Split merged row data into two rows through SAS code

Split merged row data into two rows through SAS code

Re: Getting Error in Simple SAS Code via DataFlux

Re: Better subject line needed

SAS Code Debugging: Unanticipated Behavior in dataflux SAS code

Re: Providing VA Dashboard access to user which belongs to multiple gr...

Providing VA Dashboard access to user which belongs to multiple groups

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Creating multiple columns using single column

Re: Creating multiple columns using single column

Re: Split merged row data into two rows through SAS code

Re: Required input for SAS VA dashboard report link

Re: Import metadata from qlikview to SAS

Re: Free Webinar: SAS® Visual Statistics 8.3 on SAS Viya: Getting Sta...

Re: Hyperlinks in Report Designer

Re: Append multiple dataset

Append multiple dataset

Re: Mapping datavalues from 2 different datasets

Re: Mapping datavalues from 2 different datasets

Re: Mapping datavalues from 2 different datasets

Mapping datavalues from 2 different datasets

Re: Optimizing Process time

Re: Optimizing Process time

Re: Optimizing Process time

Optimizing Process time

Re: Migration plan of the SAS VA environment.

Migration plan of the SAS VA environment.

We are planning to update the daily data running scripts between envir...

Re: Migration plan of the SAS VA environment.

Re: Migration plan of the SAS VA environment.