Hi, Once after the installation is done & every thing is in place do we need to have sasdemo account.Is there any future use for this account.Just want to make sure it's safe before getting rid of this account. ... View more

Hi, I need help regarding over riding passwords for SAS Internal & External accounts.Previous admin created the accounts and left the company with out letting them know the passwords.I want to override them with new passwords with out disturbing the current settings. Is there any way to do that? I really appreciate your help!!!! ... View more

Hi, In my data set I have columns C1 C2 C3 ------C20  C30----C41; There are no columns with names from C21--- C29 I require to assign label to those columns From c1 to c20 ATTRIB C1    LABEL='APP C1' ATTRIB C2    LABEL='APP C2'; From C30 to C41 ATTRIB C30  LABEL ='DEN C30'; ATTRIB C31  LABEL='DEN  C31'; I tried to use array to do that but it is not working. Any help will be appreciated. ... View more

Hi All, In our company we create PDF reports.The client requires to Create Excel reports as well.We have only Base sas installed in our prod.Scheduler runs our jobs and our FTP job will ftp them from unix box to another server. Just want to make sure there is no other way other than generating excel report through making code changes to current code to use ods tagsets.EXCELXP? Is there any tool they can use which can take PDF's and automatically create Excel? As far as i know it's not possible.Correct me if am wrong. ... View more

Hi, I have a data set with 5 million records.I need to pull them into spread sheets.When i splitted the data set into 6 data sets and created CSV it took a long time.It took about 5 hours for each CSV file. Our back end is unix.I am using SAS EG.The CSV files will be created on our Server. Is there any better way to do this. ods csv file="&path.&name..csv";    proc print data=&dataset noobs label;    run; ... View more

Hi, I am getting an error when doing the below logic %MACRO LOOP ; data cat; set rpt; if var = 'x' THEN CALL SYMPUT("var0",trim(name0)); else                             if var = 'y' THEN CALL SYMPUT("var1",trim(NAME1)); else                             if var = 'z' THEN CALL SYMPUT("var2",trim(NAME2)); else                             if var = 'l' THEN CALL SYMPUT("var3",trim(NAME3)); else                             if var = 'k' THEN CALL SYMPUT("var4",trim(NAME4)); RUN;    %IF "&var0" NE "" %THEN %FTP_LOOP(&var0);    %IF "&var1" NE "" %THEN %LOOP1(&var1);    %IF "&var2" NE "" %THEN %LOOP1(&var2);    %IF "&var3" NE "" %THEN %LOOP1(&var3);    %IF "&var4" NE "" %THEN %LOOP1(&var4);    %mend loop; %macro loop1; '''' ''' %mend loop1; I am calling loop1 macro only when there are values in "var" variables,but when i am executing if any one of the var variable is not resolved it is taking the condition as true and running it. This is causing the job to abend. warning &var1 not resolved %IF &var1  NE " " is true. How to overcome this situation? ... View more

Hi ... View more

Hi, The software deport is currently residing on solaris system.I want to put it in USB drive,so that if any new user is added it can be installed from USB drive. I want to know how the depot can be moved to USB drive from solaris server. ... View more

Hi Guys, I am new to this concept.I created a stored process and placed it in management console.I want to run that stored process using web application I want to create two web pages one for sas users who requires login and the other for all other user who can run sas jobs with out logging in. There must be some changed need to be done in Management console,but i am not sure what to do Your help will be appreciated!!!! ... View more