Formatting Variables in SQL statement

proc sql; select max(date) format =ddmmyyp10. into :maxdat from indata; quit; %put &maxdat.;

General Integrity Constraints

Check: A user defined constraint on a single variable or a relationship among several variables. Not Null: Missing values are not allowed Primary Key: Values for this variable must unique and non-missing. Unique: Values for this variable must be unique. proc datasets library=work nolist; modify mydata; ic create ic_gender = check (where=(gender in(‘F’,’M’))); ic create … Continue reading →

My fav Videos

Schildkröten können fliegen (Originaltitel: لاک پشت ها هم پرواز می کنند‎, Lakposhtha hâm parvaz mikonand) http://de.wikipedia.org/wiki/Schildkr%C3%B6ten_k%C3%B6nnen_fliegen Die Farben des Paradieses (persisch رنگ خدا‎ Rang-e khoda) http://de.wikipedia.org/wiki/Die_Farben_des_Paradieses Kleine Schwester Zusje. NL 1996. Babel http://www.schnitt.de/202,1940,01 Drei Farben: Blau, Rot, Weiß

Integrating Websites in XP

Right Click on Desktop –> Properties –> Desktop –> Customize Desktop –> Web

Observations in ,-separated macro variable

proc sql ; select patnum into : name separated by ‘,’ from datain; quit; %put &name.;

Test Persisches alphabet

میش گوسفندی است که شاخ ندارد