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: 
Daily1
‎08-11-2025
  • 106 Posts
  • 12 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: proc report / proc tabulate

by Quartz | Level 8 in SAS Enterprise Guide
‎05-27-2022 06:32 AM
‎05-27-2022 06:32 AM
  data have; input var1 $ var2 $ var3 var4 $ var5 var6 $ var7; datalines; A 2012 20 55 36 85 63 B 2019 30 13 14 55 55 C 2023 40 52 54 33 55 D 2024 50 96 37 66 23 ; run;   i want it is possible? ... View more

proc report / proc tabulate

by Quartz | Level 8 in SAS Enterprise Guide
‎05-27-2022 06:08 AM
‎05-27-2022 06:08 AM
data have; input var1 $ var2 $ var3 ; datalines; A 2012 20 B 2019 30 C 2023 40 D 2024 50 ; run;     i want    ... View more

Import excel file error ERROR: Physical file does not exist, /pbr/bico...

by Quartz | Level 8 in SAS Enterprise Guide
‎05-22-2022 07:53 AM
‎05-22-2022 07:53 AM
SAS EG proc import datafile="C:\Users\HP\Desktop\AMRA.xlsx" dbms=xlsx out=mydata replace; run;   log ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/C:\Users\HP\Desktop\/AMRA. ... View more

Just i want to create pdf output

by Quartz | Level 8 in ODS and Base Reporting
‎05-03-2022 02:30 PM
‎05-03-2022 02:30 PM
Just i want to create pdf output any ways like proc report , proc tabulate, proc print, proc freq ,etc as it is Please help me    ... View more

Re: proc report - merging headers (and columns) with across and groupe...

by Quartz | Level 8 in SAS Procedures
‎05-02-2022 02:04 PM
‎05-02-2022 02:04 PM
can i get this output on this format column first merge with cells    ... View more

PROC REPORT

by Quartz | Level 8 in ODS and Base Reporting
‎05-01-2022 06:02 AM
‎05-01-2022 06:02 AM
  how to create this type of table using proc report ... View more

Re: PROC REPORT

by Quartz | Level 8 in ODS and Base Reporting
‎04-29-2022 06:54 AM
‎04-29-2022 06:54 AM
i want this type      ... View more

Re: PROC REPORT

by Quartz | Level 8 in ODS and Base Reporting
‎04-29-2022 06:15 AM
‎04-29-2022 06:15 AM
dataline; A B C E F G I K L M N 1 japan 190 46 15 0 0 0 0 0 1 2 us 152 39 47 86 0 0 0 0 1 3 aus 50 6 36 41 0 0 0 0 1 D, H and J is strings used as headers ... View more

PROC REPORT

by Quartz | Level 8 in ODS and Base Reporting
‎04-29-2022 02:58 AM
‎04-29-2022 02:58 AM
HOW TO WRITE PROC REPORT CODE FOR THIS TABLE proc report data=WORK; column A B C (("D" F G) G ("H" I ('J' K L M) N); run; ... View more

Import delete append

by Quartz | Level 8 in SAS Enterprise Guide
‎04-26-2022 02:17 PM
‎04-26-2022 02:17 PM
I have main data base file is world then I want to update data by countries on excel file with india, Japan US names worksheet ..please give me sample code First step read code main data base file Second step delete observations by update records on main file Third step append data main file and updated records ... View more

Re: import excel files

by Quartz | Level 8 in SAS Enterprise Guide
‎04-26-2022 01:32 PM
‎04-26-2022 01:32 PM
First Format all the variable Name Type Length Format Informat Label no Numeric 8 BEST12. BEST12. YEAR Numeric 8 BEST12. BEST12. PSL Character 5 $CHAR5. $CHAR5. SCHEME Numeric 8 BEST12. BEST12. INDUSTRY Character 4 $CHAR4. $CHAR4. CD Character 5 $CHAR5. $CHAR5. STATE Numeric 8 BEST12. BEST12. District Numeric 8 BEST12. BEST12. SECTOR Numeric 8 BEST12. BEST12. just i want change this type format Name Type Length Format Informat Label no Numeric 8 6 BEST12. SCH_DES_NO YEAR Character 28 $28. $28. YEAR PSL Character 5 $5. $CHAR5. SCHEME Numeric 8 BEST12. BEST12. SCH_CODE INDUSTRY Character 40 $4. $40. NIC_04_4DIGIT CD Character 40 $5. $40. NIC_04_5DIGIT STATE Numeric 8 BEST12. BEST12. STATE_CODE District Numeric 8 2 SECTOR Numeric 8 BEST12. BEST12. SECTOR ... View more

Re: import excel files

by Quartz | Level 8 in SAS Enterprise Guide
‎04-26-2022 01:14 PM
‎04-26-2022 01:14 PM
i want to change format, data type (char/num) and length ..........just i want easy code to change this things /* -------------------------------------------------------------------- Code generated by a SAS task Generated on Tuesday, April 26, 2022 at 10:11:27 PM By task: Import Data Wizard Source file: C:\Users\HP\Downloads\Sample - Superstore.xls Server: Local File System Output data: WORK.Sample _ Superstore Server: SASApp Note: In preparation for running the following code, the Import Data wizard has used internal routines to transfer the source data file from the local file system to SASApp. There is no SAS code available to represent this action. -------------------------------------------------------------------- */ /* -------------------------------------------------------------------- This DATA step reads the data values from a temporary text file created by the Import Data wizard. The values within the temporary text file were extracted from the Excel source file. -------------------------------------------------------------------- */ DATA WORK.'Sample _ Superstore'n; LENGTH 'Row ID'n 8 'Order ID'n $ 14 'Order Date'n 8 'Ship Date'n 8 'Ship Mode'n $ 14 'Customer ID'n $ 8 'Customer Name'n $ 22 Segment $ 11 Country $ 13 City $ 17 State $ 20 'Postal Code'n $ 5 Region $ 7 'Product ID'n $ 15 Category $ 15 'Sub-Category'n $ 11 'Product Name'n $ 127 Sales 8 Quantity 8 Discount 8 Profit 8 ; FORMAT 'Row ID'n BEST12. 'Order ID'n $CHAR14. 'Order Date'n DATE9. 'Ship Date'n DATE9. 'Ship Mode'n $CHAR14. 'Customer ID'n $CHAR8. 'Customer Name'n $CHAR22. Segment $CHAR11. Country $CHAR13. City $CHAR17. State $CHAR20. 'Postal Code'n $CHAR5. Region $CHAR7. 'Product ID'n $CHAR15. Category $CHAR15. 'Sub-Category'n $CHAR11. 'Product Name'n $CHAR127. Sales BEST12. Quantity BEST12. Discount BEST12. Profit BEST12. ; INFORMAT 'Row ID'n BEST12. 'Order ID'n $CHAR14. 'Order Date'n DATE9. 'Ship Date'n DATE9. 'Ship Mode'n $CHAR14. 'Customer ID'n $CHAR8. 'Customer Name'n $CHAR22. Segment $CHAR11. Country $CHAR13. City $CHAR17. State $CHAR20. 'Postal Code'n $CHAR5. Region $CHAR7. 'Product ID'n $CHAR15. Category $CHAR15. 'Sub-Category'n $CHAR11. 'Product Name'n $CHAR127. Sales BEST12. Quantity BEST12. Discount BEST12. Profit BEST12. ; INFILE '/saswork/SAS_workA36A00006151_odaws01-apse1.oda.sas.com/#LN00015' LRECL=307 ENCODING="UTF-8" TERMSTR=CRLF DLM='7F'x MISSOVER DSD ; INPUT 'Row ID'n : BEST32. 'Order ID'n : $CHAR14. 'Order Date'n : BEST32. 'Ship Date'n : BEST32. 'Ship Mode'n : $CHAR14. 'Customer ID'n : $CHAR8. 'Customer Name'n : $CHAR22. Segment : $CHAR11. Country : $CHAR13. City : $CHAR17. State : $CHAR20. 'Postal Code'n : $CHAR5. Region : $CHAR7. 'Product ID'n : $CHAR15. Category : $CHAR15. 'Sub-Category'n : $CHAR11. 'Product Name'n : $CHAR127. Sales : BEST32. Quantity : BEST32. Discount : BEST32. Profit : BEST32. ; RUN; ... View more

import excel files

by Quartz | Level 8 in SAS Enterprise Guide
‎04-26-2022 12:51 PM
‎04-26-2022 12:51 PM
i have a dataset in excel file ,  then how to write format length datatype this type of variable  i want change this       ... View more

Append data

by Quartz | Level 8 in SAS Enterprise Guide
‎04-25-2022 05:33 AM
‎04-25-2022 05:33 AM
append this three table   proc import OUT = n_A datafile = "/SASDATASET/mednagar" DBMS = xlsx replace; run; proc import OUT = n_B datafile = "/SASDATASET/Ahmednagar" DBMS = xlsx replace; run; proc import OUT = n_C datafile = "/SASDATASET/nagar" DBMS = xlsx replace; run;   Log error NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 7109 observations and 82 variables.  ... View more

Proc append

by Quartz | Level 8 in SAS Enterprise Guide
‎04-20-2022 08:24 AM
‎04-20-2022 08:24 AM
i have 100000 observation in one dataset and another dataset have 200000 observation  how to use proc append or other ways? i want to joint this type of dataset  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-11-2025 05:19 AM
Group Hubs for Daily1
View All
Likes given to
Likes from
View All
Quick links