Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore1 2499
how can you get the single data set from the library(which has the number of data sets)?3 6926
what are the different ways of merging two datasets.name atleast 4.2 4273
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.1163
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?1 2231
how can u convert this 25-jul-2010 from numeric to charcter?3 5302
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.1 3565
which domain is better in sas? clinical trails or banking3 14955
Can you suggest us materials for sdtm mapping?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What are the statements that are executed only?
What are the different types of sas functions?
What is the difference between match merge and one to one merge?
how to remove duplicates using proc sql?
Name validation tools used in SAS
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What is Linear Regression?
Mention some common errors that are usually committed in sas programming.
how to do user inputs and command line arguments in sas?
What are the statements in proc sql?
What is the use of PROC gplot?
What is the difference between one to one merge and match merge? Give an example.
How many ways to overcome a missing values???