Hi. Peter you are right .It should have a same sql statement ahead. try this. [pre] options symbolgen; proc sql; select name from sashelp.class; select name into :name1 - :name&sqlobs from sashelp.class; quit; %put &name1 &name2 &&name&sqlobs.; %put _user_; [/pre] Ksharp ... View more

Looks like: N/N N/m m/m 1 0 1 0 1 1 0 0 1 Ksharp ... View more

Hi. data null;'s code is too difficulty to me . But I agree with Flip's suggestion. You can create three format for three disease variables. Ksharp Message was edited by: Ksharp ... View more

Hi. There is a auto macro variable (&sqlobs) created by proc sql , you can use it. [pre] proc sql; select division,manager into :division1 - :division&sqlobs , :manager1 - :manager&sqlobs from delivery_division_info; [/pre] Ksharp ... View more

[pre] mediandate = mean(startdate,enddate); format mediandate mmddyy8.; [/pre] Ksharp ... View more

[pre] proc freq data=sashelp.class; tables name /missing; format name fmt.; run; [/pre] [pre] proc tabulate data=sashelp.class; class name /preloadfmt; table name/printmiss; format name fmt.; run; [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. you do not say something about your error . and what do your log look like? proc format; value agefmt 0-<20= ??????? ; you also give nothing information. ... View more

Hi. Your sql statement should not be error during compile stage. But the output should not be what you want as your said. Flip has some right suggestion. ... View more

Hi. After Flip's suggestion. your sql statement " case value_held when value_held = . then value_held = price * shr_held else value_held = value_held end as value_held, price " Should be "price,case value_held when value_held = . then value_held = price * shr_held else value_held = value_held end as value_held" Because the calculated column should be behind the column used to calculate. Ksharp ... View more

Hi. Flip is right. Your sql have some problem. try Flip's suggestion : " case when lookup.id eq as.id and lookup.sal eq as.sal ..... then ' ' " to check whether if the value of cd is in lookup when I fix all DEPT with null values....... ... View more

Hi. I agree with data null; Try to use $CHARw. informat. ... View more

Hi. Can you give some what your dataset look like with some dummy data, and what output you would like to be . giving a example would help understand what your purpose. ... View more

Is Assets0908 numeric ? if it is not ,can use input() function to convert. if it is , try this Such As: [pre] length month1_Assets 4.; retain month1_Assets; ............. array month{3} $ ; do i=1 to 3; if month{i} eq '0908' then month1_Assets=sum(month1_Assets,Assets0908); ............... [/pre] Ksharp Message was edited by: Ksharp ... View more

Hi. I don't think your sql will work because sal =3 in lookup ,however sal =aa in as. and i do not understand your mean totally. If you want output like ' 1 200 aa aa ' , you can use filp ' s suggestion such as 'case when...' . also can use ' lookup.id ' in sql to check whether if the value of cd is in lookup...... of course , data step can do it too. ... View more

Hi. You can use ' create index ' in proc sql to index your dataset to enhance speed. ... View more