About scb

scb · ‎02-02-2017

I have the below dataset and program. In the test1 output, I only want the first record (min number in product) of every ID. I have tried using HAVING....but got syntax error. Anyone can help? DATA TEST; INPUT PRODUCT $ ID $ AMT; DATALINES; ABC 123 10000 ABD 123 20000 ABE 123 40000 ABC 124 11300 ABD 124 21800 ABE 124 65600 ABC 125 111300 ABD 125 231800 ; RUN; PROC SQL; CREATE TABLE TEST1 AS SELECT DISTINCT ID, CASE WHEN PRODUCT NOT IN ('ABE') THEN COUNT(DISTINCT PRODUCT)-1 ELSE COUNT(DISTINCT PRODUCT) END AS PRODUCTS, SUM(AMT) AS AMT FROM TEST GROUP BY ID ORDER BY ID; QUIT;

scb · ‎01-30-2017

I have the below dataset. May I know how to create the following result from the test dataset? I tried to use proc transpose but I just could not get it. For prod ABC; Amt will be equally divided to 5 months, XYZ will be 4 months. Result: Case Prod Month1 Month2 Month3 Month4 Month5 Total ABC123 ABC 200 200 200 200 200 1000 ABC124 ABC 400 400 400 400 400 2000 XYZ123 XYZ 200 200 200 200 0 800 XYZ124 XYZ 50 50 50 50 0 200 DATA TEST; INPUT CASE $ PROD $ AMT; DATALINES; ABC123 ABC 1000 ABC124 ABC 2000 XYZ123 XYZ 800 XYZ124 XYZ 200 ; RUN; Thank you very much.

scb · ‎01-26-2017

Yes, SAS only.

scb · ‎01-26-2017

In the below dataset A, I have 4 names with ID numbers, may I know how to create new ID for the new names in dataset, from 1008 to 1011? Below is sample only, i could have thousands of new names. DATA A; INFILE CARDS; INPUT ID NAME $; CARDS; 1004 JESSICA 1005 UTAKA 1006 MORRISSON 1007 NELSON ; RUN; DATA B; INFILE CARDS; INPUT NAME $; CARDS; RYAN HOLLY MASON DORREN ; RUN;

scb · ‎01-25-2017

The codes help and I have added the proc import codes. When I run the proc import codes and use the file_name, I can only import the last day of the data instead of all 31 (days) files. Any comments? Thanks. %let month=1; %let year=2017; %let file_prefix=MB0101D; %let file_suffix=txt; data _null_; start = mdy(&month,2,&year); end = intnx('month',start,1,'begin'); length file_name $30; do date = start to end; file_name = "&file_prefix" !! put(date,ddmmyyn8.) !! ".&file_suffix"; call symput('file_name',trim(file_name)); end; proc import datafile="D:\&file_name" out=test dbms=TAB replace; getnames=no; run;

scb · ‎01-25-2017

I got this error message, is it due to the SAS version, mine is SAS 9.2. rc = filename csv_all (fnames); ------- 22 68 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=. ERROR 68-185: The function CSV_ALL is unknown, or cannot be accessed.

scb · ‎01-25-2017

Every month I have daily CSV files (from 2nd day of the month to 1st day of next month, e.g. 2 Oct to 1 Nov). I have no problem in importing the CSV file individually into SAS. May I know how to import all 31 days CSV in one csv import statement by controlling the date? Attached is 2 CSV files, the last 6 digit is the date of the file in format ddmmyyyy. Any idea? Thanks.

scb · ‎01-17-2017

DATA car; infile CARDS; INPUT BRAND $ MODEL $ PRICE; CARDS; Audi ABC 20000 Audi ABB 25000 BMW CDE 40000 BMW CEE 46000 ; run; DATA DISC; infile CARDS; INPUT BRAND $ DISCOUNT; CARDS; Audi 0.9 BMW 0.95 ; run; Data car; set car; if BRAND eq 'Audi' then price * &discount; if BRAND eq 'BMW' then price * &discount; run; May I know how can pass the value from a data file (Disc dataset) to a macro variable then use it in the above program? Thanks.

scb · ‎01-10-2017

The codes can't get the desired result. Offering Id Status Obtained Desired Status 101764 New New 101765 New New 107476 Old Old 107477 New Old 99370 New New 100263 Old Old 100264 New Old 100265 New Old

scb · ‎01-10-2017

When I run my earlier codes, the only thing can’t work was when 2 transactions done at the same date but only the first order was tagged as new. (offering id 101764 and 101765). What have I missed from here?

scb · ‎01-10-2017

I attached the dataset; I am sorry that i missed OFFERING ID earlier. The transaction status for offering id 101764, 101765 and 99370 should be NEW, the rest are OLD.

scb · ‎01-10-2017

Dataset_A Cust Order_DT TRANSACTION_STATUS 123 01JAN2017 NEW 123 01JAN2017 NEW 123 02JAN2017 OLD 124 01JAN2017 NEW 125 01JAN2017 NEW 125 02JAN2017 OLD To define the transaction status; the first transaction done by every cust is NEW, if there are more than 1 transaction on the same day then all transaction will be tagged as NEW. My code below but only 1 record tagged as NEW when order_dt is the same (Cust 123, Order_dt =01jan2017) DATA DATASET_A; SET DATASET_A; BY CUST ORDER_DT; IF FIRST.CUST AND FIRST.ORDER_DT THEN TRANSACTION_STATUS = ‘NEW’;ELSE TRANSACTION_STATUS = ‘OLD’; RUN; Anyone can help? Thanks.

scb · ‎12-20-2016

DATASET A CASE DATE CUST STATUS A1 01JAN1990 123 NEW A2 02JAN1990 290 NEW DATASET B CASE DATE CUST STATUS A3 01FEB1990 380 NEW A4 02FEB1990 490 NEW A5 02FEB1990 290 OLD A6 03FEB1990 490 OLD There are 2 monthly datasets.The customer status was determined by the DATE. If the CUST appears first time then categorized as NEW customer. If the customer appears in the same month, the first record will be categorized as NEW and subsequent will be as OLD. Anyone can help? Thanks.

scb · ‎12-20-2016

I have attached a sample dataset. I can get the date format in date9. in data step. DATA SAMPLE1; FORMAT SAMPLE_DT1 DATE9.; SET SAMPLE; SAMPLE_DT1 = DATEPART(SAMPLE_DT); RUN; May i know how to get similar answer in PROC SQL? I used datepart in SQL but could not get it. Any idea? Thanks.

scb · ‎12-18-2016

When i proc tabulate a dataset and output to a pdf file; the tabulated table was automatically displayed at the centre of the page, may i know how to make it start from the left instead of centre? Any idea? Thanks.

Online Status	Offline
Date Last Visited	‎05-19-2021 06:07 AM

SAS queries

Re: Multiple title in Proc Report

Multiple title in Proc Report

SAS Query - Score Overriding query

How to add information from one data set to another data set?

SAS query - Split data to different dataset

Re: SAS query

SAS query

Proc SQL Query

Re: SAS Query

Re: SAS Query - Score Overriding query

Re: SAS import text file

Re: SAS import text file

Proc Tabulate Query

Calculate percentage of total

PROC SQL QUERY

SAS base query

Re: SEQUENTIAL NUMBER CREATION

SEQUENTIAL NUMBER CREATION

Re: Multiple days CSV file import to SAS

Re: Multiple days CSV file import to SAS

Multiple days CSV file import to SAS

value from a data file to a macro variable

Re: SAS query

Re: SAS query

Re: SAS query

SAS query

SAS query

proc sql for date

proc tabulate query