By using if then do ; We can create multiple variables based on one condition but how to do create multiple variables based on one condition in sql ... View more

data s ; length emp $ 10 boss $ 10 ; input emp $ boss ; cards ; harish ashok ashok siva siva madhavarao madhavarao ramaya ; by using above dataset assign super boss like see below   emp              boss                                   superboss harish            ashok                                 siva ashok             siva                                    madhavarao                                   siva                madhavarao                        ramaya madhavarao   ramaya ; ... View more

data s ; input studyid $ status $12. seq ; cards; 1001 screened 1 1001 randomized 2 1001 randomized 2 1002 screened 1 1002 complete 3 1003 screened 1 1003 non-complete 3 1003 non-complete 3 1004 screened 1 1004 screened 1 1005 screefailure 1 1005 screefailure 1 ;   studyid status seq work 1001 randomized 2 randomized 1001 randomized 2 randomized 1001 screened 1 randomized 1002 complete 3 complete 1002 screened 1 complete 1003 non-complete 3 non-comple 1003 non-complete 3 non-comple 1003 screened 1 non-comple 1004 screened 1 screened 1004 screened 1 screened 1005 screefailure 1 screefailu 1005 screefailure 1 screefailu   how to do convert s datasset like above ... View more

proc format ; value $ gender 'F'='female' 'M'='male' ; invalue sex 'F'=1 'M'=2 ; run; proc format fmtlib ; select $gender sex; run;     it i run above program it show only $ gender format. how to show two formats at a time ... View more

what is the difference between cards and datalines ... View more

proc printto print='D:\pha\ex1.log'; run; OPTIONS FORMCHAR='I----l+l---+=I-/\<>*' ; proc freq data=sashelp.class ; run; proc printto; run;     when i run this program it gives worng line boraders how to fix that boarders   ... View more

Proc format; Value $gen 'F'='female' 'M'='male' ; Run; How to delete above like use proc datasets or proc catalog ... View more

data name ; input (v1-v5) ($) ; cards ; john peter max jann kiyaa ; how to concatenate all variables of first letter like below   jpmjk ... View more

data test; input id age sex $; cards; 1 25 Male 2 35 Female 3 29 Female 4 37 Male 5 32 Male ; run; ex1:   data ex1 ; set test ; if sex='F' then flag=1 ; else flag=0 ; run;   data ex2 ; set test ; flag=sex='F' ; run; what is the difference between ex1 and ex2 can you give some more examples ... View more

PROC SQL ; CREATE TABLE AT AS SELECT 'LABEL'||' '||STRIP(F1)||' '||"='"||STRIP(F3)||"'" AS NEW, CASE WHEN UPCASE(F4)='STRING' THEN STRIP(F1)||' '||"='"||STRIP(F3)||"'"||' LENGTH=$'||STRIP(F5)||'.' END AS NEW1, case WHEN CALCULATED NEW1=' ' THEN NEW END AS NEW2 FROM S1 ; QUIT;   how to keep program lines in a order like see below ANY SHORT CUT KEY OR PROCEUDURE PROC SQL ;            CREATE TABLE AT AS                   SELECT 'LABEL'||' '||STRIP(F1)||' '||"='"||STRIP(F3)||"'" AS NEW,                  CASE WHEN UPCASE(F4)='STRING' THEN                 STRIP(F1)||' '||"='"||STRIP(F3)||"'"||' LENGTH=$'||STRIP(F5)||'.' END AS NEW1,                  case WHEN CALCULATED NEW1=' ' THEN NEW END AS NEW2               FROM S1 ; QUIT; ... View more

F1 F2 F3 F4 F5 STUDYID 1 Study Identifier string 8 DOMAIN 2 Domain Abbreviation string 2 USUBJID 3 Unique Subject Identifier string 16 DSSEQ 4 Sequence Number integer 8 DSTERM 5 Reported Term for the Disposition Event string 200 DSDECOD 6 Standardized Disposition Term string 200 DSCAT 7 Category for Disposition Event string 50 DSSCAT 8 Subcategory for Disposition Event string 50 VISITNUM 12 Visit Number integer 8 VISIT 13 Visit Name string 50 DSSTDTC 14 Start Date/Time of Disposition Event string 19 DSSTDY 16 Study Day of Start of Disposition Event integer 8   PROC SQL ; CREATE TABLE AT AS SELECT 'LABEL'||' '||STRIP(F1)||' '||"='"||STRIP(F3)||"'" AS NEW, CASE WHEN UPCASE(F4)='STRING' THEN STRIP(F1)||' '||"='"||STRIP(F3)||"'"||' LENGTH=$'||STRIP(F5)||'.' END AS NEW1, case WHEN CALCULATED NEW1=' ' THEN NEW END AS NEW2 FROM S1 ; QUIT; when concatinated some variable it gives error can you explain that ... View more

Proc SQL; Select dif(age) as difference from sashelp.class; Quit; When I run above program it gives error Dif function can't be used in sql then what is other alternative Please give me one more function ... View more

data s1 ; input id $ start_date:date9. end_date:date9. ; format start_date end_date date9. ; cards ; 101 23sep2018  24sep2018 101 25sep2018  27sep2018 101 .                  30sep2018 101 02oct2018  04oct2018 101 .                  08sep2018 ; Q1)in above dataset start_date has some missing values then how to assign previous values of end_date variable? id start_date end_date 101 23SEP2018 24SEP2018 101 25SEP2018 27SEP2018 101 27SEP2018 30SEP2018 101 02OCT2018 04OCT2018 101 04OCT2018 08SEP2018 Q2)in above dataset start_date has some missing values then how to assign previous values of end_date variable and add one day see below dataset? id start_date end_date 101 23SEP2018 24SEP2018 101 25SEP2018 27SEP2018 101 28SEP2018 30SEP2018 101 02OCT2018 04OCT2018 101 05OCT2018 08SEP2018   ... View more