solasa


{ City } india
< Country > india
* Profession * associate
User No # 75825
Total Questions Posted # 1
Total Answers Posted # 11

Total Answers Posted for My Questions # 9
Total Views for My Questions # 10406

Users Marked my Answers as Correct # 67
Users Marked my Answers as Wrong # 25
Questions / { solasa }
Questions Answers Category Views Company eMail

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

Quintiles,

9 SAS 10406



Answers / { solasa }

Question { Quintiles, 18332 }

· What are some good SAS programming practices for
processing very large data sets?


Answer

for large datasets we use proc sql joins

Is This Answer Correct ?    3 Yes 1 No

Question { Quintiles, 12345 }

what kind of variables are collected in AE dataset?


Answer

AESEQ---SEQUEN NUMBER
AEDECODE---DICITONARY DERIVED TERM
AETERM---REPORTED TERM OF ADVERSE EVENT
AEBODSYS---BODY SYSTYEM OR ORGANCLASS
AESEV--SEVERITY/INTENSITY
AESEVN---
AESER---SERIOU EVENT
AEACN---ACTION TAKEN WITH STUDY TREATMETN
AEOUT--OUTCOME OF ADV EVENT
AEOUTN--OUTCOME OF ADV EVENT NUMERIC
AEDUR--DURATION OF ADV EVENT\
AEPOST---POST TREATMENT ADVERSE EVENT

Is This Answer Correct ?    9 Yes 0 No


Question { TNS, 10244 }

How to get any kind of data in SAS? Is it possible to take
data from notepad in SAS?


Answer

Data sample_accounts;
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
CARDS;
1234670 11-Sep-04 Z 2000
1234671 12-Sep-04 3000
1234672 13-Sep-04 Z 2500
1234673 14-Sep-04 T 3200
1234674 15-Sep-04 8000
run;


method1
--------------------------
Data sample_accounts;
INFILE "C:\Mydata\sample_accounts.txt";
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
RUN;

method 2
-----------------------------------
filename sacc "D:\Mydata\sample_accounts.txt";
Data sample_accounts;
INFILE sacc ;
INPUT Account 1-7 OpenDate $ 9-17 StatusCode $ 21-22
CreditLimit 25-29;
RUN;

method 3;
use proc import:

method 4:
use proc cimport for xpt files into sas

Is This Answer Correct ?    28 Yes 0 No

Question { Quintiles, 10406 }

1 new york 7,262,700
2 los angeles 3,259,340
3 philadelphia 1,642,900

how to read the above data using input statement
consider the above data is in txt format externally
u have to use infile and input statement.


Answer

data cityrank;
infile 'D:\miths data\Mithelesh\cityrank.txt' ;
input rank city & $12. amoutnt comma10.;
run;
proc print data=cityrank;
run;

problem with amount varible
tell what to do?

Is This Answer Correct ?    3 Yes 12 No

Question { Cognizant, 21757 }

what is washout period?


Answer

Washoutperiod is the defined as rest period b/w two
treatment periods for which the effect of one treatment
administered at one dosing period does not carry over to the
next.
More clearly,
Normally in clinical trials drug is given at certain intervals .

For example in a study the volunteer took dose 50mg of drug
,if the drug has half life of 2.5 hrs...,(that means it
takes 2.5 hrs of time for the drug concentration come to
25mg half of its concentration)

First period Initial drug dose given is 50mg,
Finally the minimum amountaccepatable, so that another 50 mg
of drug dose can be given is 0.00125mg.

It will take at least 38.219 hrs for that drug to be in the
least concentration (ie.0.00125 or 99.9% of drug dose 1 to
be eliminated).
50mg,25mg,12.5mg,6.5mg and
......................................................upto
0..00125mg is the least concentration ie 99.9% of drug
eliminated and does not have carryover effect and now
another drug of 50 mg can be given so that the effect of
first dose of drug cannot be seen on second dose of drug.

This period where the drug is reduced to least
concentration is called the washout period.

So that it does not have carry over effect when again
another 50mg drug is given.

Is This Answer Correct ?    7 Yes 1 No

Question { EXL, 8877 }

how can you sort the dataset having millions of OBS(instead
of sort procedure?


Answer

Using INDEX option save the cpu time and helps in fast
processing

Is This Answer Correct ?    1 Yes 2 No

Question { L&T, 8345 }

i have a dataset with 100000 records. i want 100 records
from that dataset and create a dataset.we need to pick the
observations random order like
100obs,500obs,1020obs,1890obs,2565obs like that i need 100
obs in random order? how can we create this one?


Answer

we can use PROC SURVEY SELECT

Is This Answer Correct ?    8 Yes 2 No

Question { Max India, 5351 }

what is validvarname and varnum? why we are using this
options; explain with a syntax for this options?


Answer

The following example shows how the Pass-Through Facility
works with
VALIDVARNAME=UPPERCASE.

options validvarname=uppercase;
proc sql;
connect to oracle as tables(user=USERID orapw=passward
path=’INSTANCE’);
create table lab as
select lab_rslt, lab_test
from connection to oracle
(select "laboratory result$", "laboratory test$"
from DBMStable);
quit;

When we check the Output we observe that the variables in
the DBMS column is changed to upper case as well as V7
(default option) converts those variables into UPPERCASE
variables. Ex: " laboratory result$" becomes LAB_RSLT and "
laboratory test$" becomes LAB_TEST


VARNUM returns the number of a variable's position in a SAS
data set, or 0 if the variable is not in the SAS data set.
This is the same variable number that is next to the
variable in the output from PROC CONTENTS.

Is This Answer Correct ?    3 Yes 0 No

Question { GSK, 8521 }

i have a null dataset with 10 variables; i want to print only
name of the varibales in log window and also output window.how
can we do this one?


Answer

data sm;
input name $ number;
datalines;
run;

dataset in created without observations but the dataset has
varibles.

Is This Answer Correct ?    4 Yes 6 No

Question { Cognizant, 5496 }

what is the use of catalog?


Answer

SAS CATALOG IS A TYPE OF SPECIAL SAS FILE THAT CONTAINS
ELEMENTS.MOST COMMMON ELEMENTS IN SAS CATALOG ARE 'FORMAT'
'SOURCE' OUTPUT,LOG EC.

PROC FORMAT IS USED TO CREATE THE FORMAT AND STORE THEN
IN THE SASCATALOG.

proc format library=SMA;
value $region
'1'='n orthwest'
'2'='southwest'
'3'='central'
;
run;

FORMAT NAME 'REGION' IS STORED IN CATALOG IN 'SMA' LIBRARY

TO KNOW THE CONTENTS OR TO MOVE THE CONTENTS OF ASA CATALOG
USE THE PROCEDURE 'PROC CATALOG'

Is This Answer Correct ?    1 Yes 0 No

Question { 4065 }

differnce between 8.2 and 9.1.3


Answer

NEW FORMATS:

The new length for numeric format names is 32. For
character names it is 31. Format names can be associated
with a data set. The only difference between SAS V9 and
previous versions of data sets is the existence of a format
name longer than the traditional 8 bytes.
Version 9 data sets that use 8 byte or shorter format names
can be read by Version 8.


NEW INFORMATS
The new length for numeric informat names is 31 and for
character names is 30. Informat names can be associated
with a data set. The only difference between SAS V9 and
previous versions of data sets is the existence of a format
name longer than the traditional 8 bytes. Version 9 data
sets that use 8 byte or shorter format names can be read by
Version 8.



FIND THE MATTER IN BELOW LINK:
http://www2.sas.com/proceedings/sugi30/266-30.pdf

PLEASE CORRECT IF ERROR IDENTIFIED.

Is This Answer Correct ?    0 Yes 1 No