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: 
Santt0sh
‎07-22-2025
  • 172 Posts
  • 29 Likes Given
  • 6 Solutions
  • 7 Likes Received

Re: Import an excel sheet which has the column header on two rows

by Lapis Lazuli | Level 10 in SAS Programming
‎03-28-2022 10:01 PM
‎03-28-2022 10:01 PM
The transpose results. Variable Name Variable Type C 2 E 2 F 2 G 2 GRAND TOTAL 1 H 2 I 2 J 2 K 2 L 2 M 2 N 2 O 2 PROGRAM_TYPE 2 PRODUCT_TYPE 2 R 2 S 2 T 2 U 2 V 2 W 2 X 2 Y 2 _2020 2 _2021 2 ... View more

Import an excel sheet which has the column header on two rows

by Lapis Lazuli | Level 10 in SAS Programming
‎03-28-2022 09:51 PM
‎03-28-2022 09:51 PM
Hi All, I'm trying to read an excel file into SAS which has headers on two rows, I tried using the solutions provided here but I was not able to get the desired output. I thought of reading the .xlsx file twice and assigning the variable names to the merged columns in excel but later realized that the excel sheet/dataset keeps growing for the upcoming months or years.   I also tried to transpose after importing the .xlsx file with GETNAME = NO OPTION. Please find the excel attached, Kindly Suggest.                     ... View more

Re: Create a Computed variable using SAS Proc Report.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-24-2022 01:00 PM
‎03-24-2022 01:00 PM
Hi Kurt, Thank you!! The Code works and is generating the report. Regards, Santosh ... View more

Re: Create a Computed variable using SAS Proc Report.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-24-2022 12:49 PM
‎03-24-2022 12:49 PM
Hi Kurt, Thank you for your quick response! We need to use the Mean(Average) of Tr_Amt to compute the LTD column. Thanks ... View more

Re: Create a Computed variable using SAS Proc Report.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-24-2022 11:33 AM
‎03-24-2022 11:33 AM
Hi Kurt, Thank you for your quick response! Since I was not able to upload a new attachment, I am posting the report and the dataset structure below. The below data set is the source - 2 datasets (Temp and Temp1). data TEMP; input grp_cnts Count_grp_cnts Tr_Amt Tdate ; datalines; 2 45 21000 200910 12 15 51000 200910 11 545 1000 200910 03 248 5000 200910 ; run; DATASET = TEMP1 Tdate Tr_Amt  grp_cnts Count_grp_cnts  200910 21000 2 45 200910 51000 12 15 200910 1000 11 545 200910 5000 3 248 The report/dataset should look something like this. Tdate= for the reporting month Tr_Amt = Average of Tr_Amt for the Reporting Month STD_TRNS_AMTS = STDEV of the Average of the Tr Amt for the reporting month. Count_grp_cnts= Sum of the group counts for the reporting month LMT is calcluated: LMT = Tr_Amt + 5 * STD_TRNS_AMTS Tdate Tr_Amt  STD_TRNS_AMTS Count_grp_cnts Tr_Amt  LMT 200910 19500 19665.96044 853 xxxxxxx Thank you for your Time and Help!! ... View more

Re: Create a Computed variable using SAS Proc Report.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 07:38 PM
‎03-23-2022 07:38 PM
Hi All,   I m trying to create a Report using Proc Report by creating computed columns. I m getting another ERROR: You can only BREAK on GROUPing and ORDERing variables.   kindly suggest.         ... View more

Create a Computed variable using SAS Proc Report.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 07:31 PM
‎03-23-2022 07:31 PM
data xxx; input grp_cnts Count_grp_cnts Tr_Amt Tdate ; datalines; 2 45 21000 200910 12 15 51000 200910 11 545 1000 200910 03 248 5000 200910 ; run; /*creating a report:*/ PROC REPORT DATA = XXX; COLUMN Tr_Amt  Tr_Amt  = STD_TRNS_AMTS Count_grp_cnts Tr_Amt  = LMT; DEFINE Tdate/ GROUP; DEFINE LMT/GROUP ORDER=DATA; DEFINE Tr_Amt  /ANALYSIS MEAN FORMAT = 20.2 ' AVG_AMT'; DEFINE  STD_TRNS_AMTS / ANALYSIS MEAN FORMAT = 20.2 ' STD_TRNS_AMTS '; DEFINE  Count_grp_cnts/ ANALYSIS SUM FORMAT = 20.2 ' Count_grp_cnts'; RBREAK AFTER /SUMMARIZE DOL; DEFINE LMT / COMPUTED 'LTD'; COMPUTE BEFORE LMT;     LMT = Tr_Amt  + 5 * STD_TRNS_AMTS ; ENDCOMP; RUN; Hi All, I am trying to create a Report using Proc Report. The details are attached, I am not able to generate the reports because of the  ERROR: COMPUTED conflicts with earlier use of Tr_Amt  Kindly suggest me this.   Thanks!             ... View more

Re: Macro variable using scan by splitting a Variable.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 11:59 AM
‎03-23-2022 11:59 AM
Hi, Thank you for your response!! I will try the below suggested and let you know. ... View more

Re: Macro variable using scan by splitting a Variable.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 11:58 AM
‎03-23-2022 11:58 AM
Thank you for your response, I will try the below method and let you know. ... View more

Re: Macro variable using scan by splitting a Variable.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 11:57 AM
‎03-23-2022 11:57 AM
Hi Paige, Thank you for your quick response and apologies for the delayed response. I need to create datasets by reading the files at the location. I believe I can find the solutions from the below responses ... View more

Re: Macro variable using scan by splitting a Variable.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-23-2022 11:56 AM
‎03-23-2022 11:56 AM
Hi Kurt, Thank you for your quick response and apologies for the delayed response. I need to create datasets by reading the files at the location. I believe I can find the solutions from the below responses ... View more

Macro variable using scan by splitting a Variable.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-19-2022 08:03 AM
‎03-19-2022 08:03 AM
Hi All, I am trying to create macro variables for the file names from a SAS data set.The dataset lists the File names from a Unix directory in order to create datasets by reading the files. I have listed all the files from a directory, but the Sas dataset looks something like this. Data Set file: Filename ABC.txt xyz.txt Def.txt wht.txt——————————————- Tyua.txt egg.txt Dder.txt hiy.txt ——————————————- Sret.txt Amy.txt vgu.txt uil.txt ——————————————— The Macro Variables are only created for the first observation and not for the other observations in the dataset. The variables are only created for the first observation. Even after I have tried to loop on the count of the table. I have tried taking the countW, Length of the macro variables. Proc sql; Select count(*) into :Recs from filenames: Quit; Proc sql; Select filenames into: fnme from filenames; Quit; I have tried looping the Scan for both the counts mentioned above. Please Suggest! ... View more

Re: To create a variable COUNTS which will have the counts of outliers...

by Lapis Lazuli | Level 10 in SAS Programming
‎03-19-2022 07:45 AM
‎03-19-2022 07:45 AM
Thank you for the suggestion!! It worked ... View more

Re: To create a variable COUNTS which will have the counts of outliers...

by Lapis Lazuli | Level 10 in SAS Programming
‎03-15-2022 11:37 PM
‎03-15-2022 11:37 PM
Hi, Thanks let me try this! Regards ... View more

To create a variable COUNTS which will have the counts of outliers.

by Lapis Lazuli | Level 10 in SAS Programming
‎03-15-2022 09:10 PM
‎03-15-2022 09:10 PM
Hi All,   I m trying to capture the count of the Outliers. I have used the below code.     DATA   A; INPUT A B C; DATALINES; 1 2 3 1 2 3 45 45 66 34 556 334 ; PROC UNIVARIATE DATA=A OUTTABLE=A1; VAR A; RUN;   DATA A2; SET A1; UPPER=_Q1_ *(1.5 + _QRANGE_); LOWER=_Q3_ *(1.5 - _QRANGE_); CALL SYMPUT('UPPER', UPPER); CALL SYMPUT('LOWER', LOWER); RUN; %PUT &UPPER. &LOWER.;   DATA X; U="&UPPER."; L="&LOWER."; RUN;   DATA X; SET A; WHERE A GE &UPPER. OR A LE &LOWER.; RUN;   DATA X1; SET A; WHERE A GE &UPPER. ; RUN;   DATA X2; SET A; WHERE A LE &LOWER.; RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-22-2025 10:17 AM
Likes given to
View All
Likes from
View All
Quick links