%macro xportallfiles; options mprint symbolgen nofmterr ; %let filrf=mydir; %let rc=%sysfunc(filename(filrf,"E:\sas\TABLES PRACTICE\")); %let did=%sysfunc(dopen(&filrf)); %let fname=; %let memcount=%sysfunc(dnum(&did)); %if &memcount > 0 %then %do i=1 %to &memcount; %let fname=%sysfunc(dread(&did,&i)); %let iw=%index(&fname,.); /* find start of extension */ %let exts=%substr(&fname,&iw); /* find file extension */ libname xx xport "E:\sas\TABLES PRACTICE\&fname."; proc copy in=xx out=work ; run; %end; %let rc=%sysfunc(dclose(&did)); %mend xportallfiles; %xportallfiles; if i use this code i will get xpt files from where we will give location ... View more

sorry i can't get idea how to ask this question .This task will do myself thanq ... View more

code is good in this we used only two data sets but i gave one more dataset total three datasets how to solve matching and non matching data ... View more

s i know by using proc cport i get only one xpt file but how to get all xpt files at a time ... View more

Data Mh; Input Subjid $ Visit $ Dose $; Cards; U001 Week1 Asp-05mg U002 Week1 Asp-10mg U003 Week1 Asp-15mg U001 Week2 Asp-05mg U002 Week2 Asp-10mg U003 Week2 Placebo U001 Week3 Asp-05mg U002 Week3 Placebo U003 Week3 Asp-15mg ; Data Ae; Input Subjid $ Visit $ Aeterm $; Cards; U001 Week1 Headac U002 Week1 Rashs U003 Week1 Fever U001 Week2 Vomiting U002 Week2 Skinprb U003 Week2 Rashs U001 Week3 Headac U002 Week3 cold U003 Week3 Fever ; data lb ; input subjid $ visit $ test $ ; cards ; U001 Week1 RBC U002 Week1 WBC U003 Week1 PLASMA U001 Week2 ELISA U002 Week2 WBC U003 Week2 RBC ; How to get matching and non matching data by using sql ... View more

data lb ; input subjid $ visit $ test $ ; cards ; u101 week1 rbc u101 week2 wbc u102 week1 rbc u103 week2 plasma ; if we add this data also how will we do matching data and non matching data. because it is easy for me to solve the two datasets but somewhat hard for me if any other dataset added ... View more

U001 Week3 Asp-05mg U002 Week3 Placebo U003 Week3 Asp-15mg u003 week4 asprin u004 week1 drug ; Data Ae; Input Subjid $ Visit $ Aeterm $; Cards; U001 Week1 Headac U002 Week1 Rashs U003 Week1 Fever U001 Week2 Vomiting U002 Week2 Skinprb U003 Week2 Rashs U001 Week3 Headac U003 week6 pain u005 week1 fever ; some record not matched by subjid and visit wise so i want matching data and non matching data by using sql ... View more

i want state and city keep in one variable how will we do? ... View more

yes STATE/CITY is same variable .I want state and city keep in one variable ... View more

In this code nocellmerge notworking ... View more