Thank you very much. This is helpful.   ... View more

LIBNAME mylib CLEAR;  This statement only deassign  In Log you can see NOTE: Libref mylib has been deassigned.  ... View more

data l; input name $ classes $40.; classes=compress(classes,'"'); c1=scan(classes,1); c2=scan(classes,2); c3=scan(classes,3); cards; ram "history,math geography" hari "physics,, math chemistry" run; ... View more

Information Map Studio is used to hide the complexity of the underlying tables to users so they can easily create reports without needing to knwo what tables to join etc. It also allows you to apply business friendly names to fields rather than showing the names in the tables (whihc are normally technical names) Web Report Studio allows users to create reports via a web browser and save them centrally so they can be accessed by other business users when required. ... View more

Hi, It seems nobody wants to take the shot to answer Ok. Stored process is used for a lot of purposes. To keep it simple it's a sas code anyone can execute and receive the result of it without knowing anything about SAS. The easiest way is passing through the Stored Process web server to execute your SP. In my case I use stored processes in Web Report Studio to aggregate seriously my data before reporting. I also use it to create new SAS tables, the user just selects the metadata and sas code is created in a folder. SP (stored processes)  should be seen as a SAS program who can be executed without having any tool on your computer and simply by accessing the SP web service. Hope I helped you. ... View more

I didn't use google but I did find it. Thanks. http://support.sas.com/resources/papers/proceedings11/TOC.html ... View more

Hi. The last thing you need to do is to concatenate these datasets vertically. I do not code it , you can do it by yourself. The following is the code i wrote before. [pre] [/pre] %let subdir=D😕sasdata\a\b\; filename dir pipe "dir &subdir.*.csv /B"; data new;  infile dir truncover end=last;  input filename  $100.;  filename=cats("&subdir",filename);  call symputx(cats('path',_n_),filename);  call symputx(cats('dsn',_n_),scan(scan(filename,5,'\'),1,'.'));  if last then call symputx('nobs',_n_); run; %put _user_;   %macro import; %do i=1 %to &nobs;   data WORK.&&dsn&i;                                       ;       %let _EFIERR_ = 0; /* set the ERROR detection macro variable */       infile "&&path&i" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;          informat VAR1 best32. ;          informat VAR2 $30. ;          informat VAR3 comma30. ;          informat VAR4 comma30.;          informat VAR5 comma30.;          informat VAR6 comma30.;          informat VAR7 comma30.;          informat VAR8 comma30.;          informat VAR9 best12.;          format VAR1 best12. ;          format VAR2 $30. ;          format VAR3 best32.2 ;          format VAR4 best32.2;          format VAR5 best32.2;          format VAR6 best32.2;          format VAR7 best32.2;          format VAR8 best32.2;          format VAR9 best12. ;       input                   VAR1                   VAR2                   VAR3                   VAR4                   VAR5                   VAR6                   VAR7                   VAR8                   VAR9       ;                     ;       if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */       run; %end; %mend import;   %import [pre] [/pre] Ksharp ... View more

You are welcome. 🙂 Ksharp ... View more

Dear Sbb, Thanks a lot for your information and explanation about this topic. Regards, Bina ... View more

Dear Raveenat, Thanks a lot for your kind information. Regards, Bina ... View more

Sigh. If you search support.sas.com by yourself ,you will find some example. I post some exampl code I wrote before.You can refer to it. [pre] %let subdir=D:\sasdata\temp\; data filename; input filename : $100.; cards; A.csv AA.csv ; run; data new; set filename end=last; filename=cats("&subdir",filename); call symputx(cats('path',_n_),filename); call symputx(cats('dsn',_n_),scan(scan(filename,5,'\'),1,'.')); if last then call symputx('nobs',_n_); run; %put _user_; %macro import; %do i=1 %to &nobs; data WORK.&&dsn&i; ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "&&path&i" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat VAR1 best32. ; informat VAR2 $30. ; informat VAR3 comma30. ; informat VAR4 comma30.; informat VAR5 comma30.; informat VAR6 comma30.; informat VAR7 comma30.; informat VAR8 comma30.; informat VAR9 best12.; format VAR1 best12. ; format VAR2 $30. ; format VAR3 best32.2 ; format VAR4 best32.2; format VAR5 best32.2; format VAR6 best32.2; format VAR7 best32.2; format VAR8 best32.2; format VAR9 best12. ; input VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 VAR9 ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; %end; %mend import; %import [/pre] Ksharp ... View more

Thanks a lot ieva and Ksharp for ur kind information ... View more

Hi: How about it: [pre] filename csv 'c:\test.csv'; data want; infile csv length=len; input whole $varying200. len; country=scan(whole,-1); drop whole; run; [/pre] Ksharp ... View more

odd repetition of msg., deleted - Peter.C ... View more

[pre] data temp; input month $ pay bonus; cards; jan 20000 1000 jan 10000 1100 jan 5000 2000 feb 4000 3000 feb 5000 4000 mar 4800 600 mar 5000 800 ; run; data _null_; declare hash hh(ordered: 'a'); declare hiter ff('hh'); hh.definekey('month'); hh.definedata('month','_hh'); hh.definedone(); declare hash _hh(ordered: 'a'); do until(last); count+1; set temp end=last; rc=hh.find(); if rc ne 0 then do; _hh= _new_ hash(ordered: 'a'); _hh.definekey('count'); _hh.definedata('month','pay','bonus'); _hh.definedone(); hh.replace(); end; _hh.replace(); end; rc=ff.first(); do while(rc =0); _hh.output(dataset: month); rc=ff.next(); end; run; [/pre] Ksharp ... View more