cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sasg
‎02-03-2021
  • 49 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: loading dynamic SAS dataset to teradata table.

by Calcite | Level 5 in SAS Programming
‎07-14-2016 04:13 PM
‎07-14-2016 04:13 PM
yes,based on proc datasets output i want to read the column names and datatypes and pass it to create table statement. ... View more

Re: loading dynamic SAS dataset to teradata table.

by Calcite | Level 5 in SAS Programming
‎07-14-2016 03:03 PM
‎07-14-2016 03:03 PM
it is very huge data with 115 columns,finding solution how to load this data in the database automatically. this table is the input for 10 other processes. ... View more

loading dynamic SAS dataset to teradata table.

by Calcite | Level 5 in SAS Programming
‎07-14-2016 02:48 PM
‎07-14-2016 02:48 PM
Hi All,   I have a sas data set,which will update with different column names everymonth.I have to create teradata table from this dataset.How can i define the structure of the table based on SAS dataset(how to choose index variable etc) it is a huge dataset??   Ex: dataset april month:   PRSN_ID exp1 exp2 exp3      .           1        0      1     111       2        3       1   dataset May month   Name  exp2 db008 behaviour rxt         1       2        good tuv         0       1        notbad ... View more

macro issue

by Calcite | Level 5 in SAS Programming
‎08-29-2011 05:55 PM
‎08-29-2011 05:55 PM
art,        It worked with dcreate.        Thanks a lot....but want to check,why it is not accepting spaces with mkdir. Regards, rk. ... View more

macro issue

by Calcite | Level 5 in SAS Programming
‎08-29-2011 05:43 PM
‎08-29-2011 05:43 PM
Hi Robby;              Same issue with md and mkdir.          %chk_dir(dir=c:\test); ERROR: Shell escape is not valid in this SAS session. Thanks, rk; ... View more

macro issue

by Calcite | Level 5 in SAS Programming
‎08-29-2011 03:50 PM
‎08-29-2011 03:50 PM
Hi,      Running below macro on EG 4.2....What command should i use instead of mkdir.     %macro chk_dir(dir=); %local rc fileref; %let rc = %sysfunc(filename(fileref,&dir)); %if %sysfunc(fexist(&fileref)) %then %put NOTE: The directory "&dir" exists; %else %do; %sysexec md &dir; %put %sysfunc(sysmsg()) The directory has been created.; %end; %let rc=%sysfunc(filename(fileref)); %mend chk_dir; %chk_dir(dir=C:\test); Thanks, rk. ... View more

Proc SQL problem

by Calcite | Level 5 in SAS Programming
‎08-26-2011 02:06 PM
‎08-26-2011 02:06 PM
Thanks all.....it worked. ... View more

Proc SQL problem

by Calcite | Level 5 in SAS Programming
‎08-26-2011 12:33 PM
‎08-26-2011 12:33 PM
Hi DF, If i hardcode date like datetime format it's working....is it gonna work with your logic. It's a very big query....taking two hours to pull the data....so i would like to confirm before running. WHERE (t1.RECEIVED_FILE_ID = t3.RECEIVED_FILE_ID AND t2.FILE_SENDER_ID = t3.FILE_SENDER_ID AND       t1.CLD_PATIENT_COOKED_ID = t4.CLD_PATIENT_COOKED_ID AND t1.CLD_PATIENT_COOKED_ID =t5.CLD_PATIENT_COOKED_ID)AND       ('1Jan2010:0:0:0'dt <= t3.FILE_DATE_OF_REPORT <= '25Aug2011:0:0:0'dt        AND t2.SENDER_NAME LIKE 'SDI %')) Thanks, rk.   ... View more

Proc SQL problem

by Calcite | Level 5 in SAS Programming
‎08-25-2011 06:47 PM
‎08-25-2011 06:47 PM
Hi,     I'm running below PROC SQL with range of dates in where clause giving issue.    I'm trying to pull this data from oracle DB.    (t3.FILE_DATE_OF_REPORT BETWEEN input("&Start_Date",date9.) AND input("&End_Date",date9.)                AND t2.SENDER_NAME LIKE 'SDI %')) Somebody help me what was issue? Thanks, rk. ... View more

Backup the file in sas

by Calcite | Level 5 in SAS Programming
‎08-17-2011 02:08 PM
‎08-17-2011 02:08 PM
Hi,      I have one program which will generate error list for specified period.      Each time i ran that program results should be stored in the dataset with header and footnotes(is header and footnote  possible for dataset?) dataset: Header: generated report on 08/15/2011. Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13398 902 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 17370 Footer:  generated report on 08/15/2011. Header: generated report on 08/16/2011. Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13399 903 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 17370 Footer:  generated report on 08/16/2011. Then based on dates on header we have to create two promts with all the dates.....what ever dates they selected we have to generate the results. ex: date1...08/15/2011       date2...08/16/2011 outputfile1: Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13398 902 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 1737 outputfile2: Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13399 903 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 1737 can someone help me on this issue. Thanks, rk. ... View more

Backup the file in sas

by Calcite | Level 5 in SAS Programming
‎08-17-2011 01:25 PM
‎08-17-2011 01:25 PM
art127,          sorry,they want all the results(i mean each time i ran) that has to be stored in a dataset with header and footer.i have attached the file with example.         then i have to give two prompts for dates for comparing results.......in the prompt dropdown,i have to give all dates which are there in the header part of dataset.         Header: generated report on 08/15/2011. Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13398 902 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 17370 Footer:  generated report on 08/15/2011. Header: generated report on 08/16/2011. Speciality Pharmacy Milestone Period Raw Total Less:Missing Product Code Less:Missing Milestone Date Less:Missing Date and Product ACS 8/1/2010 13399 903 0 3112 ASRX 8/1/2010 39078 10 1901 92 Accredo 8/1/2010 158570 0 44042 0 Caremark 8/1/2010 220015 0 22998 38450 CuraScript 8/1/2010 96000 7876 754 58 Diplomat 8/1/2010 12034 313 1599 0 Humana 8/1/2010 5094 0 4603 0 Pharmacare 8/1/2010 8249 0 42 5 PrecisionRX 8/1/2010 61805 1 575 114 PrescriptionSolutions 8/1/2010 51233 14 30928 28 USOncology 8/1/2010 7118 0 5749 0 Walgreens 8/1/2010 89694 0 20408 17370 Footer:  generated report on 08/16/2011. Thanks, Bhavani. ... View more

Backup the file in sas

by Calcite | Level 5 in SAS Programming
‎08-17-2011 12:41 PM
‎08-17-2011 12:41 PM
ani,     i'm not comparing files in sas........i just have to send two files to them......previous ran results and current.     With date stamp with file they can't able to use that file in spot-fire it seems. Thanks, Bhavani. ... View more

Backup the file in sas

by Calcite | Level 5 in SAS Programming
‎08-17-2011 12:39 PM
‎08-17-2011 12:39 PM
Hi,    I want to make files to be permanent by simply creating them as a two level name, i.e., libname.yourfilename.  You can also rename files and find out if files exist.   I want to proceed with above code......can you send me sample code. Thanks, rk. ... View more

Backup the file in sas

by Calcite | Level 5 in SAS Programming
‎08-17-2011 10:12 AM
‎08-17-2011 10:12 AM
Hi,     I have a workflow in sas,it will generate the results and save those results on local machine.     After I ran next time,I have to backup this file and generate new results with this file.    Later I have to compare these two results.how can I do this in sas?....somebody help me. Thanks, Rk. ... View more

switching values based on id and date

by Calcite | Level 5 in SAS Programming
‎08-10-2011 02:03 PM
‎08-10-2011 02:03 PM
Hi art297,                             I have another scenario below...in that scenario above logic is not working. id  date            type 1702950901 03/22/2010 Referral 1702950901 03/29/2010 Approval 1702950901 03/29/2010 Referral 1702950901 03/30/2010 Ship 1702950901 05/19/2010 Ship 1702950901 08/02/2010 Ship 1702950901 08/31/2010 Ship 1702950901 09/20/2010 Ship 1702950901 10/18/2010 Ship 1702950901 11/15/2010 Ship 1702950901 12/13/2010 Ship 1702968901 05/18/2010 Referral 1702968901 06/04/2010 Approval 1702968901 06/22/2010 Referral 1702968901 06/29/2010 Ship 1702968901 08/23/2010 Ship 1702968901 09/28/2010 Ship 1702968901 10/20/2010 Ship Could you please check that once. Thanks, rk. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-03-2021 12:52 PM
Quick links