About Riteshdell

Riteshdell · ‎02-22-2017

I am trained in Di studio, but faced this question in an interview, this is community where any person can ask any technical questions related to SAS, whatever the person is trained on SAS or not. Don't tell me what I should ask or not.

Riteshdell · ‎02-22-2017

Hello Techiez, I am looking for some solution where I can print some selected random number of observation of data set. suppose a Data set contains 100 observation and i want to print some random observation like 8,25,47,56 observation. How can we do it. Can any one help me on it. thanks in advance. Regards, Ritesh

Riteshdell · ‎02-17-2017

hello All, Some body has asked me a question in a interview related to SAS DI. I have Oracle database as Source and Teradata database as Target. How can we load tables ORacle to Teradata with out using Extract transformation. Is it poosible , if yes. then How? Thanks in advance.

Riteshdell · ‎07-14-2016

hello all, I am getting a warning in some code: WARNING: The variable in the DROP, KEEP, or RENAME list has never been referenced Can any one tell me, what can be the scenario of this warning?

Riteshdell · ‎07-14-2016

@barelythere- Can you please post the answer , as I am also facing the same issue . and not able to fix it. Thanks & Regards, Ritesh Srivastava

Riteshdell · ‎07-04-2016

Firstly I didn't understand your question completly. But some how I am managing to giving you ans.: try this : Proc sql; select Product_id, avg(age),max(age),min(age) from X(library).Network group by Product_id; run; and Please post your question with more clearity.

Riteshdell · ‎07-02-2016

Use variable_name LIKE 'R%A'; Below I am creating a dataset which data consist start with R and end with A. Code to create sample data set " data demo; input name $; datalines; RITA SITA NITA RASHNA KAVITA ; RUN; code to search letter start with R and end with A. PROC PRINT DATA =DEMO; WHERE NAME LIKE 'R%A'; RUN;

Riteshdell · ‎06-29-2016

First try to Drop this symbol (<), then try to show this value 0.000001 in format. Later you change to character variable as a Normal process. (using put).

Riteshdell · ‎06-28-2016

hello, please try this one.

Riteshdell · ‎06-27-2016

why you are using double trail option to read it... @@ is used to divide varible name in to two observation.....any specific requirement for using double trail?

Riteshdell · ‎06-27-2016

I am not understadning your question completly, but I am guessing , your record length is less. So just try to increase the length of input data file. syntax: LINESIZE=n | MIN | MAX | hexX give maximum length of record. LS= 1024(I am assuming max number). try this or let us know complete issue.

Riteshdell · ‎06-27-2016

I believe , Reeza is talking about attached screenshot of Radio button.

Riteshdell · ‎06-27-2016

Every year, for Sas Studio, launches a new update on SAS studio, just wait for mid July , you will get a pop-up to update SAS studio. For share Folder issue, Please refer below url's. https://support.sas.com/software/products/university-edition/faq/shared_folder_whatis.htm https://support.sas.com/software/products/university-edition/faq/shared_folder_access_existing.htm

Riteshdell · ‎06-26-2016

Hello All, Can any one give me brief description about Job Deployement and Re-deployement ? There are two option comes in each job option . Deployement Redeploy

Riteshdell · ‎06-26-2016

Hello All, I want to Know , how to find missing values in Varible data of any Data set. Below is an example OF DATASET ID Name Gender 101 RaM mALE . tONY mALE 103 . fEMALE

Online Status	Offline
Date Last Visited	‎05-23-2025 02:53 AM

Re: Data manipulation of String from Right side

Data manipulation of String from Right side

How to Import .csv file from URL

Re: First.id result with proc sql

First.id result with proc sql

Re: How do I Data manipulate of remove special char and shift string i...

How do I Data manipulate of remove special char and shift string in to...

Re: OBS AND OUTOBS

Re: Index not finding string if there is a comma or dot etc after it

Re: Remove Duplicates First. and Last.

Re: Create a table to append everymonth data

Re: Removing/Deleting Observations

Re: Removing/Deleting Observations

Re: How to create a permanent Library in SAS University Edition tool

WARNING: The variable in the DROP, KEEP, or RENAME list has never been...

Re: Remove group by conditions

Re: Aggregate Transformation in SAS

Re: PROC SQL Continued – Basic Text Analytics Using Song Titles

Re: I am trying to get name starting with letter R and ending with A

Re: Load Oracle table to teradata without extract transformation in sa...

How can I print random number observations in Data set?

Load Oracle table to teradata without extract transformation in sas di

WARNING: The variable in the DROP, KEEP, or RENAME list has never been...

Re: why am I receiving a message WARNING: The variable _1 in the DROP,...

Re: PROC SQL Continued – Basic Text Analytics Using Song Titles

Re: I am trying to get name starting with letter R and ending with A

Re: Pvalue6.4 to character conversion

Re: functions

Re: double trailing option

Re: double trailing option

Re: SAS Studio

Re: SAS Studio

What is difference between Deployment and Redeployement?

Finding missing values from Variables Data